explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AaVn

Settings
# exclusive inclusive rows x rows loops node
1. 70.676 252.095 ↑ 1.4 36,708 1

HashAggregate (cost=5,953.92..6,578.92 rows=50,000 width=8) (actual time=237.634..252.095 rows=36,708 loops=1)

  • Group Key: f.id
2. 49.357 181.419 ↓ 1.0 66,521 1

Hash Join (cost=1,648.08..5,621.72 rows=66,440 width=8) (actual time=23.404..181.419 rows=66,521 loops=1)

  • Hash Cond: (b.flight_id = f.id)
3. 75.439 110.968 ↓ 1.0 66,521 1

Hash Join (cost=204.08..4,003.30 rows=66,440 width=8) (actual time=1.883..110.968 rows=66,521 loops=1)

  • Hash Cond: (b.pax_id = p.id)
4. 33.704 33.704 ↑ 1.0 200,000 1

Seq Scan on booking b (cost=0.00..3,274.00 rows=200,000 width=8) (actual time=0.019..33.704 rows=200,000 loops=1)

5. 0.734 1.825 ↑ 1.0 3,322 1

Hash (cost=162.56..162.56 rows=3,322 width=4) (actual time=1.825..1.825 rows=3,322 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 149kB
6. 0.877 1.091 ↑ 1.0 3,322 1

Bitmap Heap Scan on pax p (cost=66.03..162.56 rows=3,322 width=4) (actual time=0.228..1.091 rows=3,322 loops=1)

  • Recheck Cond: (race = 'Men'::race)
  • Heap Blocks: exact=55
7. 0.214 0.214 ↑ 1.0 3,322 1

Bitmap Index Scan on idx_pax (cost=0.00..65.20 rows=3,322 width=0) (actual time=0.213..0.214 rows=3,322 loops=1)

  • Index Cond: (race = 'Men'::race)
8. 12.379 21.094 ↑ 1.0 50,000 1

Hash (cost=819.00..819.00 rows=50,000 width=4) (actual time=21.094..21.094 rows=50,000 loops=1)

  • Buckets: 65,536 Batches: 1 Memory Usage: 2,270kB
9. 8.715 8.715 ↑ 1.0 50,000 1

Seq Scan on flight f (cost=0.00..819.00 rows=50,000 width=4) (actual time=0.018..8.715 rows=50,000 loops=1)