explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KJlD

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

Delete on golf_delta (cost=57,242.370..57,411.430 rows=20 width=34) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=57,242.370..57,411.430 rows=20 width=34) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

HashAggregate (cost=57,241.930..57,242.130 rows=20 width=32) (actual rows= loops=)

  • Group Key: "zulu".quebec_seven
4. 0.000 0.000 ↓ 0.0

Subquery Scan on four_romeo (cost=56,676.250..57,241.880 rows=20 width=32) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Limit (cost=56,676.250..57,241.680 rows=20 width=4) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash Anti Join (cost=56,676.250..1,267,149.270 rows=42,816 width=4) (actual rows= loops=)

  • Hash Cond: (((kilo_foxtrot.papa_hotel)::text = (quebec_sierra.alpha_quebec)::text) AND ((papa_kilo.quebec_foxtrot)::text = (quebec_sierra.golf_juliet)::text) AND ((papa_kilo.six)::text = (quebec_sierra.quebec_juliet)::text) AND (papa_kilo.alpha_lima = quebec_sierra.uniform) AND (papa_kilo.whiskey = quebec_sierra.five) AND ((papa_kilo.mike_foxtrot)::text = (quebec_sierra.kilo_juliet)::text) AND ((papa_kilo.yankee)::text = (quebec_sierra.november)::text))
7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=31,605.300..1,240,863.420 rows=42,816 width=71) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on golf_delta papa_kilo (cost=31,604.890..1,119,058.300 rows=42,816 width=62) (actual rows= loops=)

  • Filter: ((NOT (mike_mike delta 1)) AND (quebec_kilo = 1))
9.          

SubPlan (for Seq Scan)

10. 0.000 0.000 ↓ 0.0

Unique (cost=31,600.340..31,603.390 rows=600 width=4) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Sort (cost=31,600.340..31,601.860 rows=609 width=4) (actual rows= loops=)

  • Sort Key: alpha_delta.xray
12. 0.000 0.000 ↓ 0.0

Seq Scan on alpha_delta (cost=0.000..31,572.170 rows=609 width=4) (actual rows= loops=)

  • Filter: (quebec_kilo = 1)
13. 0.000 0.000 ↓ 0.0

Index Scan using lima on seven kilo_foxtrot (cost=0.420..2.830 rows=1 width=17) (actual rows= loops=)

  • Index Cond: (quebec_seven = papa_kilo.xray)
14. 0.000 0.000 ↓ 0.0

Hash (cost=15,222.320..15,222.320 rows=358,132 width=78) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Seq Scan on four_six quebec_sierra (cost=0.000..15,222.320 rows=358,132 width=78) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Index Scan using quebec_seven on golf_delta (cost=0.440..8.460 rows=1 width=10) (actual rows= loops=)

  • Index Cond: (quebec_seven = "zulu".quebec_seven)