explain.depesz.com

PostgreSQL's explain analyze made readable

Result: galZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.046 107.245 ↑ 1.0 1 1

Aggregate (cost=316,866.890..316,866.900 rows=1 width=24) (actual time=107.244..107.245 rows=1 loops=1)

  • Buffers: shared hit=35091
2. 99.525 107.199 ↑ 231.4 162 1

Bitmap Heap Scan on quebec (cost=3,812.330..316,398.210 rows=37,494 width=20) (actual time=106.291..107.199 rows=162 loops=1)

  • Recheck Cond: (zulu = 39894)
  • Filter: (seven && 'foxtrot'::tsrange)
  • Rows Removed by Filter: 46053
  • Heap Blocks: exact=34432
  • Buffers: shared hit=35091
3. 7.674 7.674 ↑ 1.6 46,215 1

Bitmap Index Scan on delta (cost=0.000..3,802.960 rows=74,987 width=0) (actual time=7.674..7.674 rows=46,215 loops=1)

  • Index Cond: (zulu = 39894)
  • Buffers: shared hit=659
Planning time : 0.083 ms
Execution time : 107.297 ms