explain.depesz.com

PostgreSQL's explain analyze made readable

Result: j5Oj

Settings
# exclusive inclusive rows x rows loops node
1. 1.866 41.694 ↑ 1.6 6,304 1

Unique (cost=5,064.49..5,339.49 rows=10,000 width=123) (actual time=38.118..41.694 rows=6,304 loops=1)

2. 14.513 39.828 ↑ 1.0 10,000 1

Sort (cost=5,064.49..5,089.49 rows=10,000 width=123) (actual time=38.118..39.828 rows=10,000 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.460 25.315 ↑ 1.0 10,000 1

Hash Left Join (cost=2,643.18..4,400.11 rows=10,000 width=123) (actual time=12.789..25.315 rows=10,000 loops=1)

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

Hash Left Join (cost=2,640.92..4,360.33 rows=10,000 width=122) (actual time=12.773..23.842 rows=10,000 loops=1)

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

Hash Left Join (cost=2,618.14..4,300.00 rows=10,000 width=118) (actual time=12.769..22.988 rows=10,000 loops=1)

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

Hash Join (cost=2,595.37..4,239.66 rows=10,000 width=114) (actual time=12.757..22.069 rows=10,000 loops=1)

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

Merge Right Join (cost=1,684.37..3,191.16 rows=10,000 width=118) (actual time=10.143..16.687 rows=10,000 loops=1)

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

Index Scan using mike_india on four (cost=0.42..79,826.93 rows=523,360 width=45) (actual time=0.008..2.800 rows=10,600 loops=1)

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

Sort (cost=1,683.48..1,708.48 rows=10,000 width=77) (actual time=10.124..11.973 rows=10,000 loops=1)

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

Hash Join (cost=604.60..1,019.10 rows=10,000 width=77) (actual time=3.250..7.517 rows=10,000 loops=1)

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

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

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

Hash (cost=479.82..479.82 rows=9,982 width=73) (actual time=3.150..3.150 rows=9,982 loops=1)

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

Seq Scan on quebec (cost=0.00..479.82 rows=9,982 width=73) (actual time=0.005..1.509 rows=9,982 loops=1)

14. 1.115 2.590 ↑ 1.0 10,000 1

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

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

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

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

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

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

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

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

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

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

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

  • Filter: (yankee five NULL)
20. 0.001 0.013 ↑ 1.0 1 1

Hash (cost=2.25..2.25 rows=1 width=8) (actual time=0.013..0.013 rows=1 loops=1)

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

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

  • Filter: ((yankee five NULL) AND (foxtrot_bravo_november = 3,304))
  • Rows Removed by Filter: 99
Planning time : 0.939 ms
Execution time : 41.970 ms