explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dqhF : Title

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Sort (cost=599.330..599.330 rows=1 width=317) (actual rows= loops=)

  • Sort Key: (whiskey() zulu_quebec (?))
2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=518.550..599.320 rows=1 width=317) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=518.270..526.320 rows=1 width=228) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Limit (cost=517.990..518.010 rows=1 width=73) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

WindowAgg (cost=517.990..518.010 rows=1 width=73) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Sort (cost=517.990..517.990 rows=1 width=57) (actual rows= loops=)

  • Sort Key: oscar_oscar.four_victor DESC
7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=5.090..517.980 rows=1 width=57) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on india_golf (cost=4.800..179.740 rows=43 width=8) (actual rows= loops=)

  • Recheck Cond: (zulu_lima = 76,109,185)
  • Filter: ('kilo_delta'::integer[] && four_six_yankee)
9. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on charlie_tango (cost=0.000..4.790 rows=67 width=0) (actual rows= loops=)

  • Index Cond: (zulu_lima = 76,109,185)
10. 0.000 0.000 ↓ 0.0

Index Scan using uniform_india on sierra oscar_oscar (cost=0.290..7.860 rows=1 width=57) (actual rows= loops=)

  • Index Cond: ((four_victor = india_golf.four_victor) AND (oscar_alpha = 2) AND (two_golf = 0))
  • Filter: ((lima_tango >= 0) AND (lima_tango <> 6) AND (yankee_tango = 0) AND (CASE WHEN ((tango_romeo)::character varying five_romeo NULL) THEN 0 ELSE 1 END = 1) AND ((quebec_three_zulu)::date >= 'uniform_yankee'::date) AND ((quebec_three_zulu)::date <= 'tango_juliet'::date))
11. 0.000 0.000 ↓ 0.0

Index Scan using november_three on juliet_six hotel_quebec (cost=0.290..8.300 rows=1 width=155) (actual rows= loops=)

  • Index Cond: (quebec_seven = oscar_oscar.four_victor)
12. 0.000 0.000 ↓ 0.0

Index Scan using foxtrot on four_charlie four_sierra (cost=0.280..0.310 rows=1 width=37) (actual rows= loops=)

  • Index Cond: (four_victor = hotel_quebec.quebec_seven)
13.          

SubPlan (for Nested Loop Left Join)

14. 0.000 0.000 ↓ 0.0

Index Only Scan using golf_zulu_whiskey on india_two (cost=0.290..8.310 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((three_golf = 1) AND (four_six_charlie = 0) AND (four_victor = hotel_quebec.quebec_seven))
15. 0.000 0.000 ↓ 0.0

Index Only Scan using golf_zulu_whiskey on india_two echo_uniform (cost=0.290..12.120 rows=16 width=8) (actual rows= loops=)

  • Index Cond: ((three_golf = 1) AND (four_six_charlie = 0))
16. 0.000 0.000 ↓ 0.0

Index Only Scan using charlie_romeo on hotel_golf (cost=0.290..8.310 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((zulu_lima = 76,109,185) AND (four_victor = hotel_quebec.quebec_seven))
17. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on hotel_golf oscar_two (cost=9.810..263.650 rows=197 width=8) (actual rows= loops=)

  • Recheck Cond: (zulu_lima = 76,109,185)
18. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on charlie_romeo (cost=0.000..9.760 rows=197 width=0) (actual rows= loops=)

  • Index Cond: (zulu_lima = 76,109,185)
19. 0.000 0.000 ↓ 0.0

Seq Scan on lima_three (cost=0.000..1.550 rows=1 width=0) (actual rows= loops=)

  • Filter: ((four_victor = hotel_quebec.quebec_seven) AND (zulu_lima = 76,109,185))
20. 0.000 0.000 ↓ 0.0

Seq Scan on lima_three seven_hotel (cost=0.000..1.460 rows=1 width=8) (actual rows= loops=)

  • Filter: (zulu_lima = 76,109,185)
21. 0.000 0.000 ↓ 0.0

Index Only Scan using kilo_lima on yankee_golf (cost=0.270..8.420 rows=2 width=0) (actual rows= loops=)

  • Index Cond: (four_victor = hotel_quebec.quebec_seven)
22. 0.000 0.000 ↓ 0.0

Seq Scan on yankee_golf juliet_november (cost=0.000..8.330 rows=433 width=8) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

Seq Scan on tango_bravo (cost=0.000..19.110 rows=3 width=0) (actual rows= loops=)

  • Filter: ((four_victor = hotel_quebec.quebec_seven) OR (xray_foxtrot = hotel_quebec.quebec_seven))
24. 0.000 0.000 ↓ 0.0

Limit (cost=0.290..10.120 rows=1 width=8) (actual rows= loops=)

25. 0.000 0.000 ↓ 0.0

Index Scan using uniform_india on sierra (cost=0.290..10.120 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (four_victor = hotel_quebec.quebec_seven)
  • Filter: (delta five_romeo NOT NULL)
26. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.570..16.650 rows=1 width=0) (actual rows= loops=)

27. 0.000 0.000 ↓ 0.0

Index Scan using kilo_india on alpha_lima seven_india (cost=0.280..8.320 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (four_victor = hotel_quebec.quebec_seven)
  • Filter: ((three_kilo > 0) OR (mike(((echo_tango('six_uniform'::text, (seven_golf - (CURRENT_DATE)::timestamp without time zone)))::integer)::double precision) <= 'echo_oscar'::double precision))
28. 0.000 0.000 ↓ 0.0

Index Only Scan using kilo_whiskey on xray_uniform kilo_hotel (cost=0.290..8.310 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((quebec_seven = seven_india.zulu_lima) AND (echo_victor = 2))
29. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,648.250..1,749.370 rows=19 width=8) (actual rows= loops=)

  • Hash Cond: (alpha_sierra1.zulu_lima = echo_six1.quebec_seven)
30. 0.000 0.000 ↓ 0.0

Seq Scan on alpha_lima november_kilo (cost=0.000..98.720 rows=919 width=16) (actual rows= loops=)

  • Filter: ((three_kilo > 0) OR (mike(((echo_tango('six_uniform'::text, (seven_golf - (CURRENT_DATE)::timestamp without time zone)))::integer)::double precision) <= 'echo_oscar'::double precision))
31. 0.000 0.000 ↓ 0.0

Hash (cost=1,637.770..1,637.770 rows=838 width=8) (actual rows= loops=)

32. 0.000 0.000 ↓ 0.0

Index Scan using two_bravo on xray_uniform papa (cost=0.290..1,637.770 rows=838 width=8) (actual rows= loops=)

  • Index Cond: (echo_victor = 2)
33. 0.000 0.000 ↓ 0.0

Limit (cost=0.730..17.020 rows=1 width=32) (actual rows= loops=)

34. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.730..17.020 rows=1 width=32) (actual rows= loops=)

35. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.430..16.470 rows=1 width=20) (actual rows= loops=)

36. 0.000 0.000 ↓ 0.0

Index Only Scan using quebec_three_victor on six_hotel five_four (cost=0.140..8.160 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (four_victor = hotel_quebec.quebec_seven)
37. 0.000 0.000 ↓ 0.0

Index Scan using kilo_whiskey on xray_uniform romeo_charlie (cost=0.290..8.310 rows=1 width=28) (actual rows= loops=)

  • Index Cond: (quebec_seven = five_four.quebec_hotel)
38. 0.000 0.000 ↓ 0.0

Index Scan using victor on golf_zulu_alpha romeo_november (cost=0.290..0.540 rows=1 width=46) (actual rows= loops=)

  • Index Cond: (quebec_seven = echo_six2.echo_victor)