explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Xucv : Without bitmap Or

Settings
# exclusive inclusive rows x rows loops node
1. 495.013 1,116.496 ↓ 207.2 173,675 1

Sort (cost=13,386.550..13,388.640 rows=838 width=1,945) (actual time=1,025.477..1,116.496 rows=173,675 loops=1)

  • Sort Key: tango_india DESC
  • Sort Method: external merge Disk: 59176kB
  • Planning time: 0.217 ms
  • Execution time: 1158.462 ms
2. 564.966 621.483 ↓ 207.2 173,675 1

Bitmap Heap Scan on foxtrot (cost=97.810..13,345.860 rows=838 width=1,945) (actual time=66.738..621.483 rows=173,675 loops=1)

  • Recheck Cond: ((charlie)::text = 'whiskey'::text)
  • Rows Removed by Index Recheck: 863707
  • Filter: ((tango_india >= 'tango_papa'::timestamp with time zone) AND (tango_india <= 'bravo'::timestamp with time zone) AND (kilo = 4271))
  • Rows Removed by Filter: 2
  • Heap Blocks: exact=8809 lossy=163471
3. 56.517 56.517 ↓ 52.0 173,677 1

Bitmap Index Scan on november (cost=0.000..97.600 rows=3,338 width=0) (actual time=56.517..56.517 rows=173,677 loops=1)

  • Index Cond: ((charlie)::text = 'whiskey'::text)