explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OwYT

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

GroupAggregate (cost=46,725,660.26..47,937,140.78 rows=2,370,217 width=285) (actual rows= loops=)

  • Group Key: alpha.quebec
2. 0.000 0.000 ↓ 0.0

Sort (cost=46,725,660.26..46,871,910.48 rows=58,500,086 width=321) (actual rows= loops=)

  • Sort Key: alpha.quebec
3. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=1,908,975.40..3,987,119.06 rows=58,500,086 width=321) (actual rows= loops=)

  • Hash Cond: (((mike.two_kilo)::text = (alpha.two_kilo)::text) AND ((mike.golf)::text = (alpha.golf)::text))
4. 0.000 0.000 ↓ 0.0

Seq Scan on kilo mike (cost=0.00..407,852.45 rows=13,458,545 width=57) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash (cost=1,362,052.52..1,362,052.52 rows=10,302,592 width=287) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=178,046.40..1,362,052.52 rows=10,302,592 width=287) (actual rows= loops=)

  • Hash Cond: (((four.two_kilo)::text = (yankee.two_kilo)::text) AND ((four.sierra)::text = (yankee.xray)::text))
7. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=178,042.42..1,181,753.19 rows=10,302,592 width=280) (actual rows= loops=)

  • Hash Cond: (((four.two_kilo)::text = (alpha.two_kilo)::text) AND ((four.golf)::text = (alpha.golf)::text))
8. 0.000 0.000 ↓ 0.0

Seq Scan on victor four (cost=0.00..393,082.92 rows=10,302,592 width=109) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Hash (cost=79,993.17..79,993.17 rows=2,370,217 width=189) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Seq Scan on two_six alpha (cost=0.00..79,993.17 rows=2,370,217 width=189) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Hash (cost=2.79..2.79 rows=79 width=11) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Seq Scan on zulu yankee (cost=0.00..2.79 rows=79 width=11) (actual rows= loops=)