explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JVGu : query 1

Settings
# exclusive inclusive rows x rows loops node
1. 0.033 6,626.047 ↓ 4.5 9 1

Sort (cost=35,352.320..35,352.330 rows=2 width=199) (actual time=6,626.045..6,626.047 rows=9 loops=1)

  • Sort Key: kilo_uniform.delta_india
  • Sort Method: quicksort Memory: 27kB
2. 0.015 6,626.014 ↓ 4.5 9 1

Nested Loop (cost=1,629.150..35,352.310 rows=2 width=199) (actual time=6,625.492..6,626.014 rows=9 loops=1)

3. 0.010 6,625.981 ↓ 4.5 9 1

Nested Loop (cost=1,628.710..35,351.120 rows=2 width=174) (actual time=6,625.486..6,625.981 rows=9 loops=1)

4. 0.023 6,625.917 ↓ 4.5 9 1

Nested Loop (cost=1,628.280..35,349.920 rows=2 width=149) (actual time=6,625.472..6,625.917 rows=9 loops=1)

5. 0.022 6,625.849 ↓ 4.5 9 1

Nested Loop (cost=1,627.840..35,348.790 rows=2 width=140) (actual time=6,625.458..6,625.849 rows=9 loops=1)

  • Join Filter: (six_hotel.juliet_india = india_kilo.xray_sierra)
6. 0.012 6,625.764 ↓ 9.0 9 1

Nested Loop (cost=1,627.410..35,339.970 rows=1 width=133) (actual time=6,625.435..6,625.764 rows=9 loops=1)

7. 0.022 6,625.698 ↓ 9.0 9 1

Nested Loop (cost=1,626.980..35,339.380 rows=1 width=115) (actual time=6,625.418..6,625.698 rows=9 loops=1)

8. 15.280 6,625.604 ↓ 9.0 9 1

Hash Join (cost=1,626.540..35,333.400 rows=1 width=115) (actual time=6,625.391..6,625.604 rows=9 loops=1)

  • Hash Cond: (six_hotel.juliet_india = kilo_uniform.quebec_seven)
  • Join Filter: ((six_hotel.uniform_quebec > (('juliet_five'::cstring)::date - 2)) OR (kilo_uniform.three_charlie_papa five NULL))
  • Rows Removed by Join Filter: 12
9. 5,221.816 5,221.816 ↑ 2.1 4,053 1

Index Scan using uniform_two on six_hotel (cost=0.430..33,579.400 rows=8,485 width=42) (actual time=1.862..5,221.816 rows=4,053 loops=1)

  • Index Cond: (six_mike = 10984)
  • Filter: ((india_golf five NULL) AND ((delta_romeo five NULL) OR (delta_romeo > (('juliet_five'::cstring)::date - 2))))
  • Rows Removed by Filter: 5312
10. 17.209 1,388.508 ↓ 1.4 26,969 1

Hash (cost=1,381.660..1,381.660 rows=19,556 width=73) (actual time=1,388.508..1,388.508 rows=26,969 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 2950kB
11. 1,371.299 1,371.299 ↓ 1.4 26,969 1

Index Scan using november on kilo_uniform (cost=0.440..1,381.660 rows=19,556 width=73) (actual time=0.815..1,371.299 rows=26,969 loops=1)

  • Index Cond: (delta_uniform > (('juliet_five'::cstring)::date - 3))
12. 0.072 0.072 ↑ 1.0 1 9

Index Scan using papa on tango (cost=0.430..5.960 rows=1 width=16) (actual time=0.008..0.008 rows=1 loops=9)

  • Index Cond: (quebec_seven = kilo_uniform.charlie_four)
13. 0.054 0.054 ↑ 1.0 1 9

Index Scan using sierra_india on sierra_zulu (cost=0.430..0.580 rows=1 width=26) (actual time=0.006..0.006 rows=1 loops=9)

  • Index Cond: (quebec_seven = tango.india_sierra)
14. 0.063 0.063 ↑ 2.0 1 9

Index Scan using juliet_victor on quebec_five india_kilo (cost=0.430..8.790 rows=2 width=23) (actual time=0.006..0.007 rows=1 loops=9)

  • Index Cond: ((xray_sierra = kilo_uniform.quebec_seven) AND (oscar = 2))
15. 0.045 0.045 ↑ 1.0 1 9

Index Scan using whiskey on three_charlie_xray kilo_foxtrot (cost=0.430..0.560 rows=1 width=25) (actual time=0.005..0.005 rows=1 loops=9)

  • Index Cond: (quebec_seven = india_kilo.alpha)
16. 0.054 0.054 ↑ 1.0 1 9

Index Scan using six_golf on victor xray_whiskey (cost=0.430..0.590 rows=1 width=41) (actual time=0.006..0.006 rows=1 loops=9)

  • Index Cond: (quebec_seven = kilo_foxtrot.uniform_kilo)
17. 0.018 0.018 ↑ 1.0 1 9

Index Scan using six_golf on victor charlie_mike (cost=0.430..0.590 rows=1 width=41) (actual time=0.002..0.002 rows=1 loops=9)

  • Index Cond: (quebec_seven = kilo_foxtrot.two)