explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oyVh : no limit

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

Limit (cost=44,429.930..44,431.180 rows=500 width=198) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=44,429.930..44,587.680 rows=63,100 width=198) (actual rows= loops=)

  • Sort Key: quebec_sierra.six_three, 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=17,022.420..41,285.730 rows=63,100 width=198) (actual rows= loops=)

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

Hash Semi Join (cost=17,000.070..40,584.180 rows=63,100 width=162) (actual rows= loops=)

  • Hash Cond: (quebec_three.quebec_seven = romeo.quebec_seven)
5. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=0.850..22,551.690 rows=126,200 width=162) (actual rows= loops=)

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

Index Scan using six_whiskey on kilo_xray quebec_three (cost=0.420..21,989.930 rows=126,200 width=124) (actual rows= loops=)

  • Filter: ((NOT whiskey_delta) AND (whiskey_juliet five_romeo NULL) AND ((juliet_victor = ANY ('zulu_charlie'::integer[])) OR (juliet_victor five_romeo NULL)))
7. 0.000 0.000 ↓ 0.0

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

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

Hash (cost=16,096.750..16,096.750 rows=72,198 width=4) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

HashAggregate (cost=14,652.790..15,374.770 rows=72,198 width=4) (actual rows= loops=)

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

Hash Join (cost=8,077.830..14,472.300 rows=72,198 width=4) (actual rows= loops=)

  • Hash Cond: (romeo.quebec_seven = mike_november1.bravo)
11. 0.000 0.000 ↓ 0.0

Seq Scan on kilo_xray romeo (cost=0.000..5,833.960 rows=144,396 width=4) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Hash (cost=8,054.060..8,054.060 rows=1,902 width=4) (actual rows= loops=)

13. 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
14. 0.000 0.000 ↓ 0.0

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

15. 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
16. 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)
17. 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)
18. 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)
19. 0.000 0.000 ↓ 0.0

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

20. 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))
21. 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)
22. 0.000 0.000 ↓ 0.0

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

23. 0.000 0.000 ↓ 0.0

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

  • Sort Key: mike_november2.bravo
24. 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))
25. 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)
26. 0.000 0.000 ↓ 0.0

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

27. 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)