explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4PHU : 1

Settings
# exclusive inclusive rows x rows loops node
1. 30.518 108,922.714 ↓ 6,678.0 6,678 1

Nested Loop Left Join (cost=23.590..43,679.690 rows=1 width=4) (actual time=403.944..108,922.714 rows=6,678 loops=1)

  • Filter: (kilo_papa.quebec_seven_victor five_romeo NULL)
2. 28.052 23,400.440 ↓ 6,678.0 6,678 1

Nested Loop Left Join (cost=23.170..41,075.970 rows=1 width=4) (actual time=66.247..23,400.440 rows=6,678 loops=1)

  • Filter: (november_charlie.quebec_seven_victor five_romeo NULL)
3. 29.640 23,345.676 ↓ 6,678.0 6,678 1

Nested Loop Left Join (cost=23.030..41,075.800 rows=1 width=4) (actual time=66.238..23,345.676 rows=6,678 loops=1)

  • Filter: (echo_two.quebec_seven_victor five_romeo NULL)
4. 3,361.427 15,496.098 ↓ 6,678.0 6,678 1

Nested Loop Left Join (cost=22.740..40,745.040 rows=1 width=4) (actual time=3.404..15,496.098 rows=6,678 loops=1)

  • Join Filter: (quebec_seven_oscar.sierra = kilo_foxtrot.quebec_seven_victor)
  • Rows Removed by Join Filter: 27613530
  • Filter: (quebec_seven_oscar.quebec_seven_victor five_romeo NULL)
5. 855.575 6,525.151 ↓ 6,678.0 6,678 1

Nested Loop Left Join (cost=22.740..40,576.840 rows=1 width=4) (actual time=1.441..6,525.151 rows=6,678 loops=1)

  • Join Filter: (delta_romeo.sierra = kilo_foxtrot.quebec_seven_victor)
  • Rows Removed by Join Filter: 6558777
  • Filter: (delta_romeo.quebec_seven_victor five_romeo NULL)
  • Rows Removed by Filter: 1
6. 15.947 3,946.394 ↓ 6,679.0 6,679 1

Nested Loop Left Join (cost=22.740..40,528.770 rows=1 width=4) (actual time=0.884..3,946.394 rows=6,679 loops=1)

  • Filter: (quebec_juliet.quebec_seven_victor five_romeo NULL)
  • Rows Removed by Filter: 3
7. 20.477 3,850.275 ↓ 6,681.0 6,681 1

Nested Loop Left Join (cost=22.320..40,527.600 rows=1 width=4) (actual time=0.483..3,850.275 rows=6,681 loops=1)

  • Filter: (delta_whiskey.quebec_seven_victor five_romeo NULL)
  • Rows Removed by Filter: 359
8. 68.993 3,733.212 ↓ 6,899.0 6,899 1

Nested Loop Left Join (cost=21.880..40,330.820 rows=1 width=4) (actual time=0.448..3,733.212 rows=6,899 loops=1)

  • Filter: (india_yankee.quebec_seven_victor five_romeo NULL)
  • Rows Removed by Filter: 97524
9. 329.289 2,811.302 ↓ 65,609.0 65,609 1

Nested Loop Left Join (cost=21.460..40,329.210 rows=1 width=4) (actual time=0.364..2,811.302 rows=65,609 loops=1)

  • Filter: (five_delta.quebec_seven_victor five_romeo NULL)
  • Rows Removed by Filter: 517706
10. 218.983 796.676 ↓ 561,779.0 561,779 1

Hash Left Join (cost=21.040..40,328.050 rows=1 width=4) (actual time=0.078..796.676 rows=561,779 loops=1)

  • Hash Cond: (kilo_foxtrot.quebec_seven_victor = november_mike.sierra)
  • Filter: (november_mike.quebec_seven_victor five_romeo NULL)
  • Rows Removed by Filter: 36
11. 577.649 577.649 ↓ 1.0 561,792 1

Seq Scan on tango_whiskey kilo_foxtrot (cost=0.000..32,711.600 rows=552,360 width=4) (actual time=0.028..577.649 rows=561,792 loops=1)

12. 0.005 0.044 ↑ 1.3 36 1

Hash (cost=20.460..20.460 rows=46 width=8) (actual time=0.044..0.044 rows=36 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
13. 0.039 0.039 ↑ 1.3 36 1

Seq Scan on charlie november_mike (cost=0.000..20.460 rows=46 width=8) (actual time=0.007..0.039 rows=36 loops=1)

14. 1,685.337 1,685.337 ↑ 1.0 1 561,779

Index Scan using zulu on echo_five five_delta (cost=0.420..1.160 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=561,779)

  • Index Cond: (sierra = kilo_foxtrot.quebec_seven_victor)
15. 852.917 852.917 ↑ 4.0 1 65,609

Index Scan using two_delta on five_five india_yankee (cost=0.420..1.570 rows=4 width=8) (actual time=0.005..0.013 rows=1 loops=65,609)

  • Index Cond: (sierra = kilo_foxtrot.quebec_seven_victor)
16. 96.586 96.586 ↓ 0.0 0 6,899

Index Scan using oscar on victor_papa delta_whiskey (cost=0.430..193.130 rows=364 width=8) (actual time=0.011..0.014 rows=0 loops=6,899)

  • Index Cond: (sierra = kilo_foxtrot.quebec_seven_victor)
17. 80.172 80.172 ↓ 0.0 0 6,681

Index Scan using romeo on india_romeo quebec_juliet (cost=0.420..1.160 rows=1 width=8) (actual time=0.012..0.012 rows=0 loops=6,681)

  • Index Cond: (sierra = kilo_foxtrot.quebec_seven_victor)
18. 1,723.182 1,723.182 ↓ 1.0 982 6,679

Seq Scan on echo_uniform delta_romeo (cost=0.000..35.810 rows=981 width=8) (actual time=0.008..0.258 rows=982 loops=6,679)

19. 5,609.520 5,609.520 ↓ 1.1 4,135 6,678

Seq Scan on six quebec_seven_oscar (cost=0.000..119.200 rows=3,920 width=8) (actual time=0.007..0.840 rows=4,135 loops=6,678)

20. 7,819.938 7,819.938 ↓ 0.0 0 6,678

Index Scan using india_hotel on victor_golf echo_two (cost=0.290..330.730 rows=3 width=8) (actual time=1.171..1.171 rows=0 loops=6,678)

  • Index Cond: (sierra = kilo_foxtrot.quebec_seven_victor)
21. 26.712 26.712 ↓ 0.0 0 6,678

Index Scan using four_papa on tango_four november_charlie (cost=0.140..0.160 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=6,678)

  • Index Cond: (sierra = kilo_foxtrot.quebec_seven_victor)
22. 85,491.756 85,491.756 ↓ 0.0 0 6,678

Index Scan using two_foxtrot on four_kilo kilo_papa (cost=0.420..2,603.670 rows=5 width=8) (actual time=12.802..12.802 rows=0 loops=6,678)

  • Index Cond: (sierra = kilo_foxtrot.quebec_seven_victor)
Planning time : 3.408 ms
Execution time : 108,926.945 ms