explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aPaI

Settings
# exclusive inclusive rows x rows loops node
1. 642.018 16,421.622 ↓ 2.1 467,412 1

Nested Loop (cost=42,727.570..480,022.220 rows=227,484 width=358) (actual time=649.366..16,421.622 rows=467,412 loops=1)

2. 299.785 15,779.604 ↓ 4.1 467,412 1

Hash Join (cost=42,727.290..477,174.340 rows=113,742 width=358) (actual time=649.344..15,779.604 rows=467,412 loops=1)

  • Hash Cond: (three_charlie.three_delta = three_three.quebec)
3. 301.514 15,479.801 ↓ 4.1 467,412 1

Hash Join (cost=42,725.960..475,609.050 rows=113,742 width=331) (actual time=649.317..15,479.801 rows=467,412 loops=1)

  • Hash Cond: (two.yankee = three_golf.quebec)
4. 1,103.405 15,178.195 ↓ 4.1 467,412 1

Hash Join (cost=42,710.310..474,029.450 rows=113,742 width=257) (actual time=649.217..15,178.195 rows=467,412 loops=1)

  • Hash Cond: (two.kilo = three_charlie.kilo)
5. 13,426.476 13,426.476 ↓ 4.1 469,930 1

Index Scan using sierra on six_romeo two (cost=0.570..418,991.760 rows=113,742 width=228) (actual time=0.772..13,426.476 rows=469,930 loops=1)

  • Index Cond: (oscar_five = 'six_sierra'::date)
  • Filter: (delta five NULL)
6. 211.650 648.314 ↑ 1.0 467,422 1

Hash (cost=33,210.330..33,210.330 rows=467,633 width=33) (actual time=648.314..648.314 rows=467,422 loops=1)

  • Buckets: 65536 Batches: 16 Memory Usage: 2450kB
7. 436.664 436.664 ↑ 1.0 467,422 1

Seq Scan on foxtrot_uniform three_charlie (cost=0.000..33,210.330 rows=467,633 width=33) (actual time=0.008..436.664 rows=467,422 loops=1)

8. 0.026 0.092 ↑ 1.0 73 1

Hash (cost=14.730..14.730 rows=73 width=78) (actual time=0.092..0.092 rows=73 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 16kB
9. 0.066 0.066 ↑ 1.0 73 1

Seq Scan on three_golf (cost=0.000..14.730 rows=73 width=78) (actual time=0.003..0.066 rows=73 loops=1)

10. 0.006 0.018 ↑ 1.2 12 1

Hash (cost=1.150..1.150 rows=15 width=31) (actual time=0.018..0.018 rows=12 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
11. 0.012 0.012 ↑ 1.2 12 1

Seq Scan on three_three (cost=0.000..1.150 rows=15 width=31) (actual time=0.007..0.012 rows=12 loops=1)

12. 0.000 0.000 ↑ 2.0 1 467,412

Materialize (cost=0.280..4.330 rows=2 width=4) (actual time=0.000..0.000 rows=1 loops=467,412)

13. 0.017 0.017 ↑ 2.0 1 1

Index Only Scan using oscar_bravo on foxtrot_two lima (cost=0.280..4.330 rows=2 width=4) (actual time=0.016..0.017 rows=1 loops=1)

  • Index Cond: ((foxtrot_lima = 'uniform'::text) AND (hotel = 'six_sierra'::date) AND (juliet = 'six_golf'::text))
  • Heap Fetches: 0
Planning time : 1.025 ms
Execution time : 16,509.523 ms