Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Ykyb4-0001kw-Oj for pgsql-performance@arkaria.postgresql.org; Wed, 22 Apr 2015 17:38:02 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Ykyb4-0000mt-73 for pgsql-performance@arkaria.postgresql.org; Wed, 22 Apr 2015 17:38:02 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Ykyb3-0000mm-3K for pgsql-performance@postgresql.org; Wed, 22 Apr 2015 17:38:01 +0000 Received: from aule.net ([173.255.233.100]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Ykyav-0007dM-1A for pgsql-performance@postgresql.org; Wed, 22 Apr 2015 17:38:00 +0000 Received: by aule.net (Postfix, from userid 110) id EF9581012E; Wed, 22 Apr 2015 19:37:50 +0200 (CEST) X-Spam-Checker-Version: SpamAssassin 3.3.2 (2011-06-06) on ackerman.aule.net X-Spam-Level: X-Spam-Status: No, score=-2.9 required=5.0 tests=ALL_TRUSTED,BAYES_00 autolearn=ham version=3.3.2 Received: from [192.168.178.21] (82-169-55-136.ip.telfort.nl [82.169.55.136]) by aule.net (Postfix) with ESMTPSA id 7D8F11012A for ; Wed, 22 Apr 2015 19:37:50 +0200 (CEST) Message-ID: <5537DC6D.2010300@aule.net> Date: Wed, 22 Apr 2015 19:37:49 +0200 From: Andomar User-Agent: Mozilla/5.0 (Windows NT 6.1; rv:31.0) Gecko/20100101 Thunderbird/31.6.0 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Query plan with missing timespans Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org This is a question about how to read "explain analyze". I've anonymized column names and table names. In the output of "explain analyze" below, what was the query doing between actual time 1.426 and 17.077? Kind regards, Andomar HashAggregate (cost=862.02..862.62 rows=48 width=90) (actual time=17.077..17.077 rows=0 loops=1) Group Key: col, col, col Buffers: shared hit=6018 -> Nested Loop (cost=1.52..861.18 rows=48 width=90) (actual time=17.077..17.077 rows=0 loops=1) Buffers: shared hit=6018 -> Nested Loop (cost=1.09..26.74 rows=303 width=41) (actual time=0.033..1.426 rows=384 loops=1) Buffers: shared hit=845 -> Index Scan using ind on tbl (cost=0.42..8.44 rows=1 width=8) (actual time=0.010..0.011 rows=1 loops=1) Index Cond: (col = 123) Buffers: shared hit=4 -> Index Scan using ind on tbl (cost=0.67..18.28 rows=2 width=49) (actual time=0.020..1.325 rows=384 loops=1) Index Cond: (col = col) Filter: (col = 'value') Rows Removed by Filter: 2720 Buffers: shared hit=841 -> Index Scan using index on tbl (cost=0.42..2.74 rows=1 width=57) (actual time=0.040..0.040 rows=0 loops=384) Index Cond: (col = col) Filter: (col = ANY (ARRAY[func('value1'::text), func('value2'::text)])) Rows Removed by Filter: 1 Buffers: shared hit=5173 Planning time: 0.383 ms Execution time: 17.128 ms Version: PostgreSQL 9.4.1 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-11), 64-bit -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance