explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CpQ

Settings
# exclusive inclusive rows x rows loops node
1. 2,035.082 2,054.717 ↓ 1.0 365 1

Bitmap Heap Scan on iemre_daily_2018 (cost=8.24..1,417.43 rows=359 width=12) (actual time=29.761..2,054.717 rows=365 loops=1)

  • Recheck Cond: ((gid = 5402) AND (valid > '2017-01-01'::date))
  • Heap Blocks: exact=365
2. 19.635 19.635 ↓ 1.0 365 1

Bitmap Index Scan on iemre_daily_2018_gid_valid_idx (cost=0.00..8.16 rows=359 width=0) (actual time=19.635..19.635 rows=365 loops=1)

  • Index Cond: ((gid = 5402) AND (valid > '2017-01-01'::date))
Planning time : 0.615 ms
Execution time : 2,055.073 ms