explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5gYN

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.123 ↓ 0.0 0 1

GroupAggregate (cost=62.170..62.320 rows=1 width=252) (actual time=0.123..0.123 rows=0 loops=1)

  • Group Key: three_romeo.alpha_victor, whiskey_india.quebec_seven, romeo_two.sierra_zulu_november, three_romeo.five_six, (((three_romeo.seven_papa_alpha + 'papa_two'::interval golf))::date), (((three_romeo.four_uniform + 'papa_two'::interval golf))::date)
2.          

CTE mike

3. 0.018 0.018 ↑ 127.0 1 1

Seq Scan on lima_november_six (cost=0.000..10.340 rows=127 width=8) (actual time=0.018..0.018 rows=1 loops=1)

  • Filter: (alpha_victor = 22292)
  • Rows Removed by Filter: 1
4.          

CTE three_romeo

5. 0.001 0.048 ↓ 0.0 0 1

GroupAggregate (cost=17.380..17.420 rows=1 width=108) (actual time=0.047..0.048 rows=0 loops=1)

  • Group Key: sierra_zulu_mike.alpha_victor, alpha_november.papa_quebec, alpha_november.charlie_alpha, sierra_zulu_mike.seven_papa_alpha, sierra_zulu_mike.lima_echo, sierra_zulu_mike.oscar_india
6. 0.024 0.047 ↓ 0.0 0 1

Sort (cost=17.380..17.380 rows=1 width=50) (actual time=0.047..0.047 rows=0 loops=1)

  • Sort Key: alpha_november.papa_quebec, alpha_november.charlie_alpha, sierra_zulu_mike.seven_papa_alpha, sierra_zulu_mike.lima_echo, sierra_zulu_mike.oscar_india
  • Sort Method: quicksort Memory: 25kB
7. 0.000 0.023 ↓ 0.0 0 1

Nested Loop (cost=0.860..17.370 rows=1 width=50) (actual time=0.023..0.023 rows=0 loops=1)

8. 0.023 0.023 ↓ 0.0 0 1

Index Scan using sierra_mike on sierra_zulu_mike (cost=0.430..8.450 rows=1 width=24) (actual time=0.023..0.023 rows=0 loops=1)

  • Index Cond: (alpha_victor = 22292)
  • Filter: (((juliet)::text <> november ('quebec_india'::text[])) AND (seven_papa_alpha >= 'echo'::timestamp without time zone) AND (seven_papa_alpha < 'lima_seven'::timestamp without time zone))
9. 0.000 0.000 ↓ 0.0 0

Index Scan using charlie_india on alpha_november (cost=0.430..8.900 rows=2 width=30) (never executed)

  • Index Cond: (charlie_alpha = sierra_zulu_mike.quebec_seven)
  • Filter: ((yankee > 'lima_juliet'::timestamp without time zone) OR (yankee five_romeo NULL))
10. 0.037 0.122 ↓ 0.0 0 1

Sort (cost=34.410..34.410 rows=1 width=117) (actual time=0.122..0.122 rows=0 loops=1)

  • Sort Key: three_romeo.alpha_victor, whiskey_india.quebec_seven, romeo_two.sierra_zulu_november, three_romeo.five_six, (((three_romeo.seven_papa_alpha + 'papa_two'::interval golf))::date), (((three_romeo.four_uniform + 'papa_two'::interval golf))::date)
  • Sort Method: quicksort Memory: 25kB
11. 0.000 0.085 ↓ 0.0 0 1

Nested Loop Left Join (cost=13.140..34.400 rows=1 width=117) (actual time=0.085..0.085 rows=0 loops=1)

  • Join Filter: ((kilo_five.papa_quebec = three_romeo.papa_quebec) AND (romeo_two.charlie_alpha = three_romeo.charlie_alpha))
12. 0.001 0.085 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.030..22.220 rows=1 width=117) (actual time=0.084..0.085 rows=0 loops=1)

  • Join Filter: ((three_romeo.oscar_foxtrot)::text = (romeo_charlie.oscar_foxtrot)::text)
13. 0.000 0.084 ↓ 0.0 0 1

Nested Loop (cost=0.610..11.840 rows=1 width=128) (actual time=0.084..0.084 rows=0 loops=1)

14. 0.000 0.084 ↓ 0.0 0 1

Nested Loop (cost=0.320..11.380 rows=1 width=140) (actual time=0.084..0.084 rows=0 loops=1)

  • Join Filter: (mike.quebec_seven = whiskey_india.kilo_papa)
15. 0.014 0.084 ↓ 0.0 0 1

Hash Join (cost=0.030..3.060 rows=1 width=124) (actual time=0.084..0.084 rows=0 loops=1)

  • Hash Cond: (mike.alpha_victor = three_romeo.alpha_victor)
16. 0.020 0.020 ↑ 127.0 1 1

CTE Scan on mike (cost=0.000..2.540 rows=127 width=8) (actual time=0.020..0.020 rows=1 loops=1)

17. 0.002 0.050 ↓ 0.0 0 1

Hash (cost=0.020..0.020 rows=1 width=120) (actual time=0.048..0.050 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
18. 0.048 0.048 ↓ 0.0 0 1

CTE Scan on three_romeo (cost=0.000..0.020 rows=1 width=120) (actual time=0.048..0.048 rows=0 loops=1)

19. 0.000 0.000 ↓ 0.0 0

Index Scan using delta on whiskey_india (cost=0.290..8.310 rows=1 width=16) (never executed)

  • Index Cond: (quebec_seven = three_romeo.papa_quebec)
20. 0.000 0.000 ↓ 0.0 0

Index Scan using lima_hotel on seven_papa_oscar (cost=0.290..0.450 rows=1 width=8) (never executed)

  • Index Cond: (quebec_seven = whiskey_india.xray)
  • Filter: (whiskey_india.kilo_papa = kilo_papa)
21. 0.000 0.000 ↓ 0.0 0

Index Scan using four_victor on romeo_charlie (cost=0.420..10.360 rows=2 width=8) (never executed)

  • Index Cond: ((five_echo = 'four_delta'::date) AND ((alpha_delta)::text = 'three_victor'::text))
22. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=12.110..12.140 rows=1 width=20) (never executed)

  • Group Key: kilo_five.papa_quebec, romeo_two.charlie_alpha, romeo_two.sierra_zulu_november
23. 0.000 0.000 ↓ 0.0 0

Sort (cost=12.110..12.120 rows=1 width=16) (never executed)

  • Sort Key: kilo_five.papa_quebec, romeo_two.charlie_alpha, romeo_two.sierra_zulu_november
24. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=8.920..12.100 rows=1 width=16) (never executed)

  • Join Filter: (alpha_alpha1.papa_quebec = kilo_five.papa_quebec)
25. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=8.490..11.520 rows=1 width=16) (never executed)

  • Hash Cond: (sierra_tango1.quebec_seven = romeo_two.india)
26. 0.000 0.000 ↓ 0.0 0

CTE Scan on mike whiskey_quebec (cost=0.000..2.540 rows=127 width=4) (never executed)

27. 0.000 0.000 ↓ 0.0 0

Hash (cost=8.480..8.480 rows=1 width=20) (never executed)

28. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.430..8.480 rows=1 width=20) (never executed)

29. 0.000 0.000 ↓ 0.0 0

CTE Scan on three_romeo lima_november_victor (cost=0.000..0.020 rows=1 width=8) (never executed)

30. 0.000 0.000 ↓ 0.0 0

Index Scan using tango on romeo_two (cost=0.430..8.450 rows=1 width=16) (never executed)

  • Index Cond: (charlie_alpha = alpha_alpha1.charlie_alpha)
31. 0.000 0.000 ↓ 0.0 0

Index Scan using seven_lima on kilo_five (cost=0.430..0.560 rows=2 width=12) (never executed)

  • Index Cond: (papa_xray = romeo_two.quebec_seven)
  • Filter: (yankee five_romeo NULL)
Planning time : 8.961 ms
Execution time : 0.602 ms