explain.depesz.com

PostgreSQL's explain analyze made readable

Result: w56A

Settings
# exclusive inclusive rows x rows loops node
1. 608.780 666.646 ↓ 103.6 173,675 1

Bitmap Heap Scan on foxtrot (cost=196.040..26,567.420 rows=1,676 width=1,945) (actual time=68.037..666.646 rows=173,675 loops=1)

  • Recheck Cond: (((charlie)::text = 'whiskey'::text) OR ((charlie)::text = 'yankee'::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: 10
  • Heap Blocks: exact=8817 lossy=163471
2. 0.003 57.866 ↓ 0.0 0 1

BitmapOr (cost=196.040..196.040 rows=6,677 width=0) (actual time=57.866..57.866 rows=0 loops=1)

3. 57.830 57.830 ↓ 52.0 173,677 1

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

  • Index Cond: ((charlie)::text = 'three'::text)
4. 0.033 0.033 ↑ 417.2 8 1

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

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