explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Fc9o

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Aggregate (cost=442,208.310..442,208.320 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on foxtrot (cost=40.930..441,925.870 rows=112,977 width=8) (actual rows= loops=)

  • Recheck Cond: ((five >= 'two'::timestamp without time zone) AND (five <= 'xray'::timestamp without time zone))
3. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on whiskey (cost=0.000..12.680 rows=144,717 width=0) (actual rows= loops=)

  • Index Cond: ((five >= 'two'::timestamp without time zone) AND (five <= 'xray'::timestamp without time zone))