explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YNl6

Settings
# exclusive inclusive rows x rows loops node
1. 0.041 3.441 ↑ 5.1 22 1

Hash Join (cost=385.410..393.440 rows=113 width=18) (actual time=3.384..3.441 rows=22 loops=1)

  • Hash Cond: (alpha_tango.uniform_uniform = alpha_foxtrot.foxtrot)
2. 0.062 0.062 ↑ 1.0 219 1

Seq Scan on alpha_tango (cost=0.000..6.190 rows=219 width=22) (actual time=0.031..0.062 rows=219 loops=1)

3. 0.016 3.338 ↑ 5.1 22 1

Hash (cost=384.000..384.000 rows=113 width=4) (actual time=3.338..3.338 rows=22 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
4. 0.073 3.322 ↑ 5.1 22 1

HashAggregate (cost=382.870..384.000 rows=113 width=4) (actual time=3.319..3.322 rows=22 loops=1)

  • Group Key: alpha_foxtrot.foxtrot
5. 0.208 3.249 ↓ 2.4 410 1

Nested Loop (cost=323.840..382.440 rows=174 width=4) (actual time=1.885..3.249 rows=410 loops=1)

6. 0.127 1.381 ↓ 3.0 332 1

HashAggregate (cost=323.420..324.540 rows=112 width=4) (actual time=1.326..1.381 rows=332 loops=1)

  • Group Key: tango.uniform_five
7. 0.029 1.254 ↓ 3.0 332 1

Nested Loop (cost=9.320..323.140 rows=112 width=4) (actual time=0.958..1.254 rows=332 loops=1)

8. 0.119 0.119 ↑ 1.0 1 1

Seq Scan on alpha_xray (cost=0.000..16.650 rows=1 width=3) (actual time=0.118..0.119 rows=1 loops=1)

  • Filter: (((november)::text <> 'india'::text) AND ((november)::text = 'yankee'::text))
  • Rows Removed by Filter: 509
9. 0.284 1.106 ↓ 2.8 332 1

Bitmap Heap Scan on tango (cost=9.320..305.320 rows=117 width=7) (actual time=0.832..1.106 rows=332 loops=1)

  • Recheck Cond: (sierra = alpha_xray.uniform_uniform)
  • Heap Blocks: exact=38
10. 0.822 0.822 ↓ 2.8 332 1

Bitmap Index Scan on xray (cost=0.000..9.290 rows=117 width=0) (actual time=0.822..0.822 rows=332 loops=1)

  • Index Cond: (sierra = alpha_xray.uniform_uniform)
11. 1.660 1.660 ↑ 2.0 1 332

Index Only Scan using hotel on alpha_foxtrot (cost=0.420..0.500 rows=2 width=8) (actual time=0.005..0.005 rows=1 loops=332)

  • Index Cond: (uniform_five = tango.uniform_five)
  • Heap Fetches: 410
Planning time : 2.372 ms