explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kM53

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 42.951 ↓ 0.0 0 1

Sort (cost=12,885.96..12,885.97 rows=1 width=354) (actual time=42.944..42.951 rows=0 loops=1)

  • Sort Key: lima_delta1.foxtrot_bravo DESC, ((six_uniform(1, alpha1.six_uniform, lima_delta1.foxtrot_bravo, LOCALTIMESTAMP, lima_delta1.mike))::boolean) DESC, (six_uniform(0, alpha1.six_uniform, lima_delta1.foxtrot_bravo, LOCALTIMESTAMP, lima_delta1.mike)), lima_delta1.mike
  • Sort Method: quicksort Memory: 25kB
2. 0.001 42.942 ↓ 0.0 0 1

Group (cost=12,885.42..12,885.95 rows=1 width=354) (actual time=42.936..42.942 rows=0 loops=1)

  • Group Key: lima_delta1.quebec_seven, romeo_three1.quebec_seven, kilo_foxtrot1.quebec_seven, alpha1.six_uniform, zulu1.quebec_seven
3. 0.005 42.941 ↓ 0.0 0 1

Sort (cost=12,885.42..12,885.43 rows=1 width=923) (actual time=42.935..42.941 rows=0 loops=1)

  • Sort Key: lima_delta1.quebec_seven, romeo_three1.quebec_seven, kilo_foxtrot1.quebec_seven, alpha1.six_uniform, zulu1.quebec_seven
  • Sort Method: quicksort Memory: 25kB
4. 0.001 42.936 ↓ 0.0 0 1

Nested Loop Left Join (cost=4.54..12,885.41 rows=1 width=923) (actual time=42.930..42.936 rows=0 loops=1)

5. 0.000 42.935 ↓ 0.0 0 1

Nested Loop Left Join (cost=4.26..12,885.10 rows=1 width=248) (actual time=42.930..42.935 rows=0 loops=1)

  • Join Filter: (lima_delta1.juliet_hotel = alpha1.foxtrot_charlie)
6. 0.001 42.935 ↓ 0.0 0 1

Nested Loop (cost=3.98..12,884.74 rows=1 width=220) (actual time=42.930..42.935 rows=0 loops=1)

7. 0.001 42.934 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.71..12,882.23 rows=1 width=228) (actual time=42.929..42.934 rows=0 loops=1)

8. 0.001 42.933 ↓ 0.0 0 1

Nested Loop Left Join (cost=3.42..12,881.92 rows=1 width=169) (actual time=42.929..42.933 rows=0 loops=1)

  • Join Filter: (echo_seven1.sierra_foxtrot = echo_lima1.sierra_foxtrot)
  • Filter: (echo_lima1.quebec_seven five_romeo NULL)
9. 0.012 42.932 ↓ 0.0 0 1

Nested Loop (cost=3.30..12,878.95 rows=42 width=177) (actual time=42.929..42.932 rows=0 loops=1)

10. 1.829 42.880 ↑ 86.7 20 1

Hash Left Join (cost=2.87..9,790.71 rows=1,733 width=161) (actual time=0.073..42.880 rows=20 loops=1)

  • Hash Cond: (lima_delta1.juliet_hotel = india1.quebec_hotel)
  • Filter: ((lima_delta1.juliet_hotel = 81) OR ((india1.yankee_zulu = 81) AND ((india1.juliet_charlie)::text = 'kilo_papa'::text)))
  • Rows Removed by Filter: 17,659
11. 3.809 41.044 ↓ 2.7 17,679 1

Hash Join (cost=1.78..9,763.78 rows=6,442 width=161) (actual time=0.052..41.044 rows=17,679 loops=1)

  • Hash Cond: (lima_delta1.four_sierra = romeo_three1.quebec_seven)
12. 37.212 37.212 ↑ 2.2 19,310 1

Index Scan using papa_yankee on foxtrot_romeo quebec_sierra (cost=0.56..9,616.81 rows=41,872 width=144) (actual time=0.024..37.212 rows=19,310 loops=1)

  • Index Cond: ((lima_romeo)::text = 'juliet_uniform'::text)
  • Filter: ((NOT papa_bravo) OR (papa_bravo five_romeo NULL))
  • Rows Removed by Filter: 24,397
13. 0.003 0.023 ↑ 1.0 2 1

Hash (cost=1.20..1.20 rows=2 width=25) (actual time=0.022..0.023 rows=2 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
14. 0.020 0.020 ↑ 1.0 2 1

Seq Scan on tango four_uniform (cost=0.00..1.20 rows=2 width=25) (actual time=0.013..0.020 rows=2 loops=1)

  • Filter: (yankee_uniform((six_xray)::text) = ANY ('four_yankee'::text[]))
  • Rows Removed by Filter: 11
15. 0.002 0.007 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=23) (actual time=0.007..0.007 rows=4 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
16. 0.005 0.005 ↑ 1.0 4 1

Seq Scan on hotel romeo_foxtrot (cost=0.00..1.04 rows=4 width=23) (actual time=0.004..0.005 rows=4 loops=1)

17. 0.040 0.040 ↓ 0.0 0 20

Index Scan using charlie on uniform_kilo victor (cost=0.43..1.77 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=20)

  • Index Cond: (sierra_foxtrot = lima_delta1.quebec_seven)
  • Filter: (((delta_kilo = 152) OR (delta_kilo five_romeo NULL)) AND (four_delta = 152))
18. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.12..2.34 rows=1 width=16) (never executed)

19. 0.000 0.000 ↓ 0.0 0

Index Scan using three_charlie on six_alpha four_bravo (cost=0.12..2.34 rows=1 width=16) (never executed)

20. 0.000 0.000 ↓ 0.0 0

Index Scan using sierra_delta on sierra_three whiskey (cost=0.28..0.31 rows=1 width=67) (never executed)

  • Index Cond: (lima_delta1.lima_echo = quebec_seven)
21. 0.000 0.000 ↓ 0.0 0

Index Only Scan using kilo_kilo on oscar yankee_xray (cost=0.28..2.49 rows=1 width=8) (never executed)

  • Index Cond: (quebec_seven = 152)
  • Heap Fetches: 0
22. 0.000 0.000 ↓ 0.0 0

Index Scan using three_juliet on delta_alpha five_xray (cost=0.28..0.35 rows=1 width=52) (never executed)

  • Index Cond: (kilo_foxtrot1.quebec_seven = uniform_bravo)
23. 0.000 0.000 ↓ 0.0 0

Index Scan using five_oscar on juliet_november romeo_kilo (cost=0.28..0.31 rows=1 width=683) (never executed)

  • Index Cond: (lima_delta1.quebec_seven = sierra_foxtrot)
Planning time : 2.908 ms
Execution time : 43.085 ms