explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1hyH

Settings
# exclusive inclusive rows x rows loops node
1. 0.152 551.573 ↑ 1.0 2 1

GroupAggregate (cost=6,596.230..6,596.340 rows=2 width=3,476) (actual time=551.531..551.573 rows=2 loops=1)

  • Group Key: alpha1.hotel_quebec_five, alpha1.bravo, alpha1.four
2. 0.028 551.421 ↑ 2.0 2 1

Sort (cost=6,596.230..6,596.240 rows=4 width=3,476) (actual time=551.410..551.421 rows=2 loops=1)

  • Sort Key: alpha1.hotel_quebec_five DESC, alpha1.bravo, alpha1.four
  • Sort Method: quicksort Memory: 28kB
3. 0.008 551.393 ↑ 2.0 2 1

Nested Loop Left Join (cost=312.900..6,596.190 rows=4 width=3,476) (actual time=423.870..551.393 rows=2 loops=1)

4. 0.022 551.307 ↑ 1.0 2 1

Subquery Scan on hotel_four (cost=0.430..5,971.160 rows=2 width=1,800) (actual time=423.830..551.307 rows=2 loops=1)

5. 0.001 551.285 ↑ 1.0 2 1

Limit (cost=0.430..5,971.140 rows=2 width=1,699) (actual time=423.812..551.285 rows=2 loops=1)

6. 163.149 551.284 ↑ 196,278,380.0 2 1

Nested Loop Left Join (cost=0.430..1,171,921,621,000.860 rows=392,556,760 width=1,699) (actual time=423.811..551.284 rows=2 loops=1)

  • Join Filter: ((seven_six11.zulu = alpha11.zulu) AND ((seven_six11.bravo = 0) OR (seven_six11.bravo = alpha11.bravo)) AND (((seven_six11.xray_papa = alpha11.xray_papa) AND (seven_six11.charlie_tango = 0)) OR (delta 1)))
  • Rows Removed by Join Filter: 1561004
  • Filter: ((seven_six11.five_quebec five_romeo NULL) OR (seven_six11.five_quebec >= 1))
7. 0.059 0.059 ↑ 353,287.0 2 1

Index Scan Backward using seven_two on quebec hotel_quebec_kilo (cost=0.430..851,347.060 rows=706,574 width=1,695) (actual time=0.053..0.059 rows=2 loops=1)

  • Filter: ((NOT seven_oscar) AND (zulu = ANY ('tango_sierra'::integer[])))
  • Rows Removed by Filter: 5
8. 241.744 388.024 ↑ 1.0 780,502 2

Materialize (cost=0.000..18,244.660 rows=780,844 width=36) (actual time=0.009..194.012 rows=780,502 loops=2)

9. 146.280 146.280 ↑ 1.0 780,502 1

Seq Scan on charlie_two two (cost=0.000..14,340.440 rows=780,844 width=36) (actual time=0.014..146.280 rows=780,502 loops=1)

10.          

SubPlan (forNested Loop Left Join)

11. 0.052 0.052 ↓ 1.5 34 2

Index Only Scan using hotel_romeo on echo_yankee (cost=0.430..3.700 rows=23 width=8) (actual time=0.011..0.026 rows=34 loops=2)

  • Index Cond: (xray_romeo = alpha11.xray_papa)
  • Heap Fetches: 5
12. 0.002 0.078 ↓ 0.0 0 2

Subquery Scan on foxtrot (cost=312.470..312.490 rows=2 width=1,684) (actual time=0.039..0.039 rows=0 loops=2)

13. 0.006 0.076 ↓ 0.0 0 2

Limit (cost=312.470..312.470 rows=2 width=3,336) (actual time=0.038..0.038 rows=0 loops=2)

14. 0.020 0.070 ↓ 0.0 0 2

Sort (cost=312.470..312.560 rows=37 width=3,336) (actual time=0.035..0.035 rows=0 loops=2)

  • Sort Key: lima_mike_sierra1.xray_whiskey DESC
  • Sort Method: quicksort Memory: 25kB
15. 0.004 0.050 ↓ 0.0 0 2

GroupAggregate (cost=311.270..312.100 rows=37 width=3,336) (actual time=0.025..0.025 rows=0 loops=2)

  • Group Key: lima_mike_sierra1.india_foxtrot, three_victor1.tango_whiskey
16. 0.012 0.046 ↓ 0.0 0 2

Sort (cost=311.270..311.360 rows=37 width=3,336) (actual time=0.023..0.023 rows=0 loops=2)

  • Sort Key: lima_mike_sierra1.india_foxtrot, three_victor1.tango_whiskey
  • Sort Method: quicksort Memory: 25kB
17. 0.004 0.034 ↓ 0.0 0 2

Nested Loop Left Join (cost=6.050..310.300 rows=37 width=3,336) (actual time=0.017..0.017 rows=0 loops=2)

18. 0.006 0.030 ↓ 0.0 0 2

Nested Loop Left Join (cost=0.990..122.340 rows=37 width=1,652) (actual time=0.015..0.015 rows=0 loops=2)

19. 0.024 0.024 ↓ 0.0 0 2

Index Scan using echo_hotel on lima_mike_lima xray_zulu (cost=0.560..31.320 rows=37 width=1,651) (actual time=0.012..0.012 rows=0 loops=2)

  • Index Cond: ((bravo = alpha1.bravo) AND (kilo = 0))
  • Filter: (NOT seven_oscar)
20. 0.000 0.000 ↓ 0.0 0

Index Scan using romeo on mike november_november (cost=0.430..2.450 rows=1 width=9) (never executed)

  • Index Cond: ((xray_papa = alpha1.xray_papa) AND (india_foxtrot = lima_mike_sierra1.india_foxtrot))
21. 0.000 0.000 ↓ 0.0 0

Subquery Scan on november_mike (cost=5.050..5.070 rows=1 width=1,684) (never executed)

22. 0.000 0.000 ↓ 0.0 0

Limit (cost=5.050..5.060 rows=1 width=1,652) (never executed)

23. 0.000 0.000 ↓ 0.0 0

Sort (cost=5.050..5.060 rows=1 width=1,652) (never executed)

  • Sort Key: lima_mike_sierra2.india_seven DESC
24. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.990..5.040 rows=1 width=1,652) (never executed)

25. 0.000 0.000 ↓ 0.0 0

Index Scan using papa on lima_mike_lima november_delta (cost=0.560..2.580 rows=1 width=1,651) (never executed)

  • Index Cond: ((bravo = lima_mike_sierra1.bravo) AND (three_seven = lima_mike_sierra1.india_foxtrot))
  • Filter: ((NOT seven_oscar) AND (kilo <> 0))
26. 0.000 0.000 ↓ 0.0 0

Index Scan using romeo on mike xray_juliet (cost=0.430..2.450 rows=1 width=9) (never executed)

  • Index Cond: ((xray_papa = alpha1.xray_papa) AND (india_foxtrot = lima_mike_sierra2.india_foxtrot))
Planning time : 15.317 ms
Execution time : 566.866 ms