explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UQIk

Settings
# exclusive inclusive rows x rows loops node
1. 1.908 71.436 ↑ 1.6 6,304 1

Unique (cost=5,283.65..5,558.65 rows=10,000 width=124) (actual time=68.393..71.436 rows=6,304 loops=1)

2. 16.754 69.528 ↓ 1.0 10,001 1

Sort (cost=5,283.65..5,308.65 rows=10,000 width=124) (actual time=68.391..69.528 rows=10,001 loops=1)

  • Sort Key: golf_quebec_kilo.india DESC, quebec.golf_november DESC, quebec.papa, (CASE WHEN (lima.foxtrot_three five NOT NULL) THEN true ELSE false END), quebec.juliet, four.foxtrot_bravo_november, golf_quebec_delta
  • Sort Method: quicksort Memory: 2,380kB
3. 1.833 52.774 ↓ 1.0 10,001 1

Hash Left Join (cost=2,644.11..4,619.26 rows=10,000 width=124) (actual time=12.791..52.774 rows=10,001 loops=1)

  • Hash Cond: (quebec.papa = lima.papa)
4. 1.221 50.919 ↑ 1.0 10,000 1

Hash Left Join (cost=2,640.86..4,565.01 rows=10,000 width=123) (actual time=12.763..50.919 rows=10,000 loops=1)

  • Hash Cond: (quebec.papa = foxtrot_bravo_foxtrot.papa)
5. 1.256 49.697 ↑ 1.0 10,000 1

Hash Left Join (cost=2,618.08..4,504.68 rows=10,000 width=119) (actual time=12.759..49.697 rows=10,000 loops=1)

  • Hash Cond: (quebec.papa = golf_quebec_kilo.papa)
6. 3.396 48.436 ↑ 1.0 10,000 1

Hash Join (cost=2,595.31..4,444.34 rows=10,000 width=115) (actual time=12.745..48.436 rows=10,000 loops=1)

  • Hash Cond: (foxtrot_delta.mike_alpha = hotel.mike_alpha)
7. 2.611 42.565 ↑ 1.0 10,000 1

Merge Right Join (cost=1,684.31..3,395.84 rows=10,000 width=119) (actual time=10.260..42.565 rows=10,000 loops=1)

  • Merge Cond: (four.foxtrot_bravo_november = quebec.foxtrot_bravo_november)
8. 27.501 27.501 ↑ 49.4 10,600 1

Index Scan using mike_india on four (cost=0.42..79,308.66 rows=523,862 width=46) (actual time=0.007..27.501 rows=10,600 loops=1)

  • Filter: (yankee five NULL)
9. 5.307 12.453 ↑ 1.0 10,000 1

Sort (cost=1,683.89..1,708.89 rows=10,000 width=77) (actual time=10.243..12.453 rows=10,000 loops=1)

  • Sort Key: quebec.foxtrot_bravo_november
  • Sort Method: quicksort Memory: 1,957kB
10. 2.517 7.146 ↑ 1.0 10,000 1

Hash Join (cost=605.00..1,019.50 rows=10,000 width=77) (actual time=3.151..7.146 rows=10,000 loops=1)

  • Hash Cond: (foxtrot_delta.papa = quebec.papa)
11. 1.588 1.588 ↑ 1.0 10,000 1

Seq Scan on foxtrot_delta (cost=0.00..277.00 rows=10,000 width=8) (actual time=0.056..1.588 rows=10,000 loops=1)

  • Filter: (yankee five NULL)
12. 1.587 3.041 ↑ 1.0 9,982 1

Hash (cost=480.00..480.00 rows=10,000 width=73) (actual time=3.041..3.041 rows=9,982 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 1,230kB
13. 1.454 1.454 ↑ 1.0 9,982 1

Seq Scan on quebec (cost=0.00..480.00 rows=10,000 width=73) (actual time=0.004..1.454 rows=9,982 loops=1)

14. 0.937 2.475 ↑ 1.0 10,000 1

Hash (cost=786.00..786.00 rows=10,000 width=4) (actual time=2.475..2.475 rows=10,000 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 480kB
15. 1.538 1.538 ↑ 1.0 10,000 1

Seq Scan on hotel (cost=0.00..786.00 rows=10,000 width=4) (actual time=0.006..1.538 rows=10,000 loops=1)

  • Filter: (yankee five NULL)
16. 0.000 0.005 ↓ 0.0 0 1

Hash (cost=22.70..22.70 rows=6 width=8) (actual time=0.005..0.005 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
17. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on golf_quebec_kilo (cost=0.00..22.70 rows=6 width=8) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: (yankee five NULL)
18. 0.000 0.001 ↓ 0.0 0 1

Hash (cost=22.70..22.70 rows=6 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
19. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on foxtrot_bravo_foxtrot (cost=0.00..22.70 rows=6 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (yankee five NULL)
20. 0.010 0.022 ↑ 1.0 100 1

Hash (cost=2.00..2.00 rows=100 width=8) (actual time=0.022..0.022 rows=100 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 12kB
21. 0.012 0.012 ↑ 1.0 100 1

Seq Scan on lima (cost=0.00..2.00 rows=100 width=8) (actual time=0.005..0.012 rows=100 loops=1)

  • Filter: (yankee five NULL)
Planning time : 1.063 ms
Execution time : 71.730 ms