Query plan with missing timespans

Поиск
Список
Период
Сортировка
От Andomar
Тема Query plan with missing timespans
Дата
Msg-id 5537DC6D.2010300@aule.net
обсуждение исходный текст
Ответы Re: Query plan with missing timespans
Список pgsql-performance
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



В списке pgsql-performance по дате отправления:

Предыдущее
От: Jim Nasby
Дата:
Сообщение: Re: extract(year from date) doesn't use index but maybe could?
Следующее
От: Kevin Grittner
Дата:
Сообщение: Re: Query plan with missing timespans