explain.depesz.com

PostgreSQL's explain analyze made readable

Result: m3NB

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

HashAggregate (cost=271,534.970..271,535.000 rows=3 width=16) (actual rows= loops=)

  • Group Key: oscar
2. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on hotel (cost=3,963.450..270,171.140 rows=136,383 width=16) (actual rows= loops=)

  • Recheck Cond: ((bravo = 3596) AND (juliet >= 'quebec_hotel'::timestamp with time zone) AND (juliet < 'quebec_zulu'::timestamp with time zone))
3. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on november (cost=0.000..3,929.350 rows=136,383 width=0) (actual rows= loops=)

  • Index Cond: ((bravo = 3596) AND (juliet >= 'quebec_hotel'::timestamp with time zone) AND (juliet < 'quebec_zulu'::timestamp with time zone))