explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4xQs

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

Limit (cost=14,203.140..14,203.170 rows=15 width=11) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=14,203.140..14,203.240 rows=42 width=11) (actual rows= loops=)

  • Sort Key: three
3. 0.000 0.000 ↓ 0.0

HashAggregate (cost=14,201.680..14,202.100 rows=42 width=11) (actual rows= loops=)

  • Group Key: three
4. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on bravo quebec (cost=139.640..13,972.190 rows=6,557 width=11) (actual rows= loops=)

  • Recheck Cond: ((five(golf) >= 'alpha'::date) AND (five(golf) <= 'foxtrot'::date))
5. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mike (cost=0.000..138.000 rows=6,557 width=0) (actual rows= loops=)

  • Index Cond: ((five(golf) >= 'alpha'::date) AND (five(golf) <= 'foxtrot'::date))