explain.depesz.com

PostgreSQL's explain analyze made readable

Result: a43a

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

Hash Join (cost=70,750.08..79,298.41 rows=1,020 width=12) (never executed)

2. 0.000 0.000 ↓ 0.0

Seq Scan on tt4x t1 (cost=0..30.4 rows=2,040 width=12) (never executed)

3. 0.000 0.000 ↓ 0.0

Hash (cost=35,232.23..35,232.23 rows=2,164,868 width=4) (never executed)

4. 0.000 0.000 ↓ 0.0

Merge Join (cost=2,384.93..35,232.23 rows=2,164,868 width=4) (never executed)

5. 0.000 0.000 ↓ 0.0

Merge Join (cost=285.08..607.4 rows=20,808 width=4) (never executed)

6. 0.000 0.000 ↓ 0.0

Sort (cost=142.54..147.64 rows=2,040 width=4) (never executed)

  • Sort Key: t4.c2
7. 0.000 0.000 ↓ 0.0

Seq Scan on tt4x t4 (cost=0..30.4 rows=2,040 width=4) (never executed)

8. 0.000 0.000 ↓ 0.0

Sort (cost=142.54..147.64 rows=2,040 width=4) (never executed)

  • Sort Key: t5.c1
9. 0.000 0.000 ↓ 0.0

Seq Scan on tt4x t5 (cost=0..30.4 rows=2,040 width=4) (never executed)

10. 0.000 0.000 ↓ 0.0

Sort (cost=2,099.84..2,151.86 rows=20,808 width=8) (never executed)

  • Sort Key: t3.c2
11. 0.000 0.000 ↓ 0.0

Merge Join (cost=285.08..607.4 rows=20,808 width=8) (never executed)

12. 0.000 0.000 ↓ 0.0

Sort (cost=142.54..147.64 rows=2,040 width=8) (never executed)

  • Sort Key: t2.c3
13. 0.000 0.000 ↓ 0.0

Seq Scan on tt4x t2 (cost=0..30.4 rows=2,040 width=8) (never executed)

14. 0.000 0.000 ↓ 0.0

Sort (cost=142.54..147.64 rows=2,040 width=8) (never executed)

  • Sort Key: t3.c1
15. 0.000 0.000 ↓ 0.0

Seq Scan on tt4x t3 (cost=0..30.4 rows=2,040 width=8) (never executed)