explain.depesz.com

A tool for finding a real cause for slow queries.

Result: wZD : recent

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

Hash Semi Join (cost=1194.610..1584.650 rows=1 width=1645) (actual time=.. rows= loops=)

  • Hash Cond: (charlie_alpha.quebec_seven = delta.quebec_seven)
2. 0.000 0.000 ↓ 0.0
→

Nested Loop Left Join (cost=359.110..749.120 rows=10 width=1645) (actual time=.. rows= loops=)

3. 0.000 0.000 ↓ 0.0
→

Nested Loop Left Join (cost=359.110..662.390 rows=10 width=1483) (actual time=.. rows= loops=)

4. 0.000 0.000 ↓ 0.0
→

Hash Left Join (cost=359.110..567.460 rows=10 width=1085) (actual time=.. rows= loops=)

  • Hash Cond: (charlie_alpha.xray = charlie_hotel.quebec_seven)
5. 0.000 0.000 ↓ 0.0
→

Nested Loop Left Join (cost=352.540..560.760 rows=10 width=1042) (actual time=.. rows= loops=)

6. 0.000 0.000 ↓ 0.0
→

Nested Loop Left Join (cost=352.540..477.950 rows=10 width=1017) (actual time=.. rows= loops=)

7. 0.000 0.000 ↓ 0.0
→

Hash Right Join (cost=352.540..392.420 rows=10 width=739) (actual time=.. rows= loops=)

  • Hash Cond: (tango.quebec_seven = three_romeo.mike_juliet)
8. 0.000 0.000 ↓ 0.0
→

Seq Scan on tango (cost=0.000..33.570 rows=1657 width=45) (actual time=.. rows= loops=)

9. 0.000 0.000 ↓ 0.0
→

Hash (cost=352.410..352.410 rows=10 width=698) (actual time=.. rows= loops=)

10. 0.000 0.000 ↓ 0.0
→

Nested Loop Left Join (cost=47.170..352.410 rows=10 width=698) (actual time=.. rows= loops=)

11. 0.000 0.000 ↓ 0.0
→

Bitmap Heap Scan on charlie_alpha (cost=42.860..82.560 rows=10 width=694) (actual time=.. rows= loops=)

  • Recheck Cond: (quebec_seven = ANY ('oscar_sierra'::integer[]))
12. 0.000 0.000 ↓ 0.0
→

Bitmap Index Scan on papa (cost=0.000..42.860 rows=10 width=0) (actual time=.. rows= loops=)

  • Index Cond: (quebec_seven = ANY ('oscar_sierra'::integer[]))
13. 0.000 0.000 ↓ 0.0
→

Bitmap Heap Scan on three_romeo (cost=4.310..26.910 rows=6 width=8) (actual time=.. rows= loops=)

  • Recheck Cond: (whiskey_delta = charlie_alpha.quebec_seven)
14. 0.000 0.000 ↓ 0.0
→

Bitmap Index Scan on three_papa (cost=0.000..4.310 rows=6 width=0) (actual time=.. rows= loops=)

  • Index Cond: (whiskey_delta = charlie_alpha.quebec_seven)
15. 0.000 0.000 ↓ 0.0
→

Index Scan using whiskey_alpha on lima_november (cost=0.000..8.540 rows=1 width=278) (actual time=.. rows= loops=)

  • Index Cond: (hotel = charlie_alpha.quebec_seven)
  • Filter: ((victor_oscar)::text = 'six'::text)
16. 0.000 0.000 ↓ 0.0
→

Index Scan using lima_four on yankee (cost=0.000..8.270 rows=1 width=25) (actual time=.. rows= loops=)

  • Index Cond: (quebec_seven = charlie_alpha.juliet)
17. 0.000 0.000 ↓ 0.0
→

Hash (cost=4.030..4.030 rows=203 width=43) (actual time=.. rows= loops=)

18. 0.000 0.000 ↓ 0.0
→

Seq Scan on charlie_hotel (cost=0.000..4.030 rows=203 width=43) (actual time=.. rows= loops=)

19. 0.000 0.000 ↓ 0.0
→

Index Scan using sierra on victor_xray (cost=0.000..9.450 rows=3 width=398) (actual time=.. rows= loops=)

  • Index Cond: (whiskey_delta = charlie_alpha.quebec_seven)
20. 0.000 0.000 ↓ 0.0
→

Index Scan using november on kilo (cost=0.000..8.650 rows=2 width=162) (actual time=.. rows= loops=)

  • Index Cond: (whiskey_delta = charlie_alpha.quebec_seven)
21. 0.000 0.000 ↓ 0.0
→

Hash (cost=835.190..835.190 rows=25 width=8) (actual time=.. rows= loops=)

22. 0.000 0.000 ↓ 0.0
→

Nested Loop (cost=0.000..835.190 rows=25 width=8) (actual time=.. rows= loops=)

23. 0.000 0.000 ↓ 0.0
→

Nested Loop (cost=0.000..626.550 rows=25 width=4) (actual time=.. rows= loops=)

24. 0.000 0.000 ↓ 0.0
→

Nested Loop (cost=0.000..338.700 rows=20 width=4) (actual time=.. rows= loops=)

25. 0.000 0.000 ↓ 0.0
→

Nested Loop (cost=0.000..162.810 rows=14 width=8) (actual time=.. rows= loops=)

26. 0.000 0.000 ↓ 0.0
→

Index Scan using romeo_five on victor_xray (cost=0.000..43.100 rows=14 width=4) (actual time=.. rows= loops=)

  • Index Cond: (oscar_quebec = 2710)
27. 0.000 0.000 ↓ 0.0
→

Index Scan using papa on charlie_alpha quebec_five (cost=0.000..8.540 rows=1 width=12) (actual time=.. rows= loops=)

  • Index Cond: (quebec_seven = mike_hotel.victor_xray.whiskey_delta)
28. 0.000 0.000 ↓ 0.0
→

Index Scan using four on charlie_mike (cost=0.000..12.540 rows=2 width=12) (actual time=.. rows= loops=)

  • Index Cond: (india = quebec_five.india)
29. 0.000 0.000 ↓ 0.0
→

Index Scan using golf on whiskey_quebec (cost=0.000..14.350 rows=3 width=8) (actual time=.. rows= loops=)

  • Index Cond: ((foxtrot = charlie_mike.quebec_seven) AND ((lima_seven)::text = 'romeo_victor'::text))
30. 0.000 0.000 ↓ 0.0
→

Index Scan using papa on charlie_alpha delta (cost=0.000..8.330 rows=1 width=4) (actual time=.. rows= loops=)

  • Index Cond: (quebec_seven = whiskey_quebec.whiskey_delta)