explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vv6g : with limit

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

Limit (cost=11,340.840..11,341.280 rows=174 width=198) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=11,340.840..11,341.280 rows=174 width=198) (actual rows= loops=)

  • Sort Key: quebec_sierra.six, quebec_sierra.quebec_seven, (golf((five_hotel.lima_bravo)::text)), quebec_three.quebec_seven
3. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=11,090.870..11,334.370 rows=174 width=198) (actual rows= loops=)

  • Hash Cond: (quebec_three.juliet_victor = quebec_sierra.quebec_seven)
4. 0.000 0.000 ↓ 0.0

Merge Right Join (cost=11,068.520..11,310.140 rows=174 width=162) (actual rows= loops=)

  • Merge Cond: (five_hotel.kilo_charlie = quebec_three.juliet_victor)
5. 0.000 0.000 ↓ 0.0

Index Scan using yankee on hotel_seven five_hotel (cost=0.430..192,023.920 rows=2,393 width=42) (actual rows= loops=)

  • Filter: ((seven)::text = 'kilo_uniform'::text)
6. 0.000 0.000 ↓ 0.0

Sort (cost=11,068.100..11,068.530 rows=174 width=124) (actual rows= loops=)

  • Sort Key: quebec_three.juliet_victor
7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=9,537.070..11,061.620 rows=174 width=124) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Unique (cost=9,536.650..9,537.640 rows=199 width=4) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Sort (cost=9,536.650..9,537.140 rows=199 width=4) (actual rows= loops=)

  • Sort Key: romeo.quebec_seven
10. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8,016.440..9,529.050 rows=199 width=4) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Limit (cost=8,016.020..8,018.010 rows=199 width=4) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

HashAggregate (cost=8,016.020..8,035.040 rows=1,902 width=4) (actual rows= loops=)

  • Group Key: mike_november1.bravo
13. 0.000 0.000 ↓ 0.0

Append (cost=7,390.460..8,011.260 rows=1,902 width=4) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

HashAggregate (cost=7,390.460..7,408.910 rows=1,845 width=4) (actual rows= loops=)

  • Group Key: mike_november1.bravo
15. 0.000 0.000 ↓ 0.0

Hash Join (cost=7,023.430..7,385.850 rows=1,845 width=4) (actual rows= loops=)

  • Hash Cond: (quebec_hotel.echo = mike_november1.kilo_charlie)
16. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on juliet_seven quebec_hotel (cost=4.500..78.170 rows=28 width=4) (actual rows= loops=)

  • Recheck Cond: (zulu_lima = 153)
  • Filter: (oscar_oscar five_romeo NULL)
17. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on mike_xray (cost=0.000..4.500 rows=28 width=0) (actual rows= loops=)

  • Index Cond: (zulu_lima = 153)
18. 0.000 0.000 ↓ 0.0

Hash (cost=6,661.770..6,661.770 rows=28,573 width=8) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on papa_india juliet_xray (cost=1,907.830..6,661.770 rows=28,573 width=8) (actual rows= loops=)

  • Recheck Cond: ((seven)::text = 'zulu_seven'::text)
  • Filter: ((oscar_oscar five_romeo NULL) AND ((lima_delta)::text = 'xray'::text) AND ((papa_four)::text = 'lima_golf'::text))
20. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on quebec_xray (cost=0.000..1,900.680 rows=66,168 width=0) (actual rows= loops=)

  • Index Cond: ((seven)::text = 'zulu_seven'::text)
21. 0.000 0.000 ↓ 0.0

Unique (cost=583.040..583.330 rows=57 width=4) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Sort (cost=583.040..583.190 rows=57 width=4) (actual rows= loops=)

  • Sort Key: mike_november2.bravo
23. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on papa_india oscar_four (cost=5.750..581.380 rows=57 width=4) (actual rows= loops=)

  • Recheck Cond: (kilo_charlie = 153)
  • Filter: ((oscar_oscar five_romeo NULL) AND ((lima_delta)::text = 'xray'::text) AND ((papa_four)::text = 'lima_golf'::text) AND ((seven)::text = 'zulu_echo'::text))
24. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on india (cost=0.000..5.740 rows=175 width=0) (actual rows= loops=)

  • Index Cond: (kilo_charlie = 153)
25. 0.000 0.000 ↓ 0.0

Index Only Scan using hotel_delta on kilo_xray romeo (cost=0.420..7.570 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (quebec_seven = mike_november1.bravo)
26. 0.000 0.000 ↓ 0.0

Index Scan using hotel_delta on kilo_xray quebec_three (cost=0.420..7.640 rows=1 width=124) (actual rows= loops=)

  • Index Cond: (quebec_seven = romeo.quebec_seven)
  • Filter: ((NOT whiskey_delta) AND (whiskey_juliet five_romeo NULL) AND (oscar_oscar five_romeo NULL) AND ((juliet_victor = ANY ('zulu_charlie'::integer[])) OR (juliet_victor five_romeo NULL)))
27. 0.000 0.000 ↓ 0.0

Hash (cost=21.500..21.500 rows=68 width=10) (actual rows= loops=)

28. 0.000 0.000 ↓ 0.0

Seq Scan on whiskey_november quebec_sierra (cost=0.000..21.500 rows=68 width=10) (actual rows= loops=)

  • Filter: (oscar_oscar five_romeo NULL)