explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qH1h : Optimization for: plan #uzkK

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.017 0.133 ↑ 1.0 1 1

GroupAggregate (cost=11.92..11.95 rows=1 width=12) (actual time=0.132..0.133 rows=1 loops=1)

  • Group Key: (date_part('year'::text, (valid)::timestamp without time zone))
2. 0.116 0.116 ↑ 1.0 2 1

Sort (cost=11.92..11.92 rows=2 width=12) (actual time=0.115..0.116 rows=2 loops=1)

  • Sort Key: (date_part('year'::text, (valid)::timestamp without time zone))
  • Sort Method: quicksort Memory: 25kB
  • -> Index Scan using iemre_daily_2019_gid_valid_idx on iemre_daily_2019 (cost=0.42..11.91 rows=2 width=12) (actual time=0.081..0.091 rows=2
  • Index Cond: ((gid = 53402) AND (valid > '2017-01-01'::date))
Planning time : 0.481 ms
Execution time : 0.217 ms