explain.depesz.com

PostgreSQL's explain analyze made readable

Result: via9

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

Hash Join (cost=873.56..4,366.66 rows=34 width=600) (never executed)

2. 0.000 0.000 ↓ 0.0

Hash Join (cost=696.62..4,179.76 rows=4 width=1,128) (never executed)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=200..3,680.46 rows=4 width=1,096) (never executed)

4. 0.000 0.000 ↓ 0.0

Foreign Scan (cost=100..150.95 rows=1,365 width=36) (never executed)

5. 0.000 0.000 ↓ 0.0

Materialize (cost=100..274.01 rows=9 width=1,124) (never executed)

6. 0.000 0.000 ↓ 0.0

Foreign Scan (cost=100..273.96 rows=9 width=1,124) (never executed)

7. 0.000 0.000 ↓ 0.0

Hash (cost=480.65..480.65 rows=1,065 width=104) (never executed)

8. 0.000 0.000 ↓ 0.0

Hash Join (cost=351.23..480.65 rows=1,065 width=104) (never executed)

9. 0.000 0.000 ↓ 0.0

Foreign Scan (cost=100..186.8 rows=2,560 width=8) (never executed)

10. 0.000 0.000 ↓ 0.0

Hash (cost=250.19..250.19 rows=83 width=104) (never executed)

11. 0.000 0.000 ↓ 0.0

Foreign Scan (cost=100..250.19 rows=83 width=104) (never executed)

12. 0.000 0.000 ↓ 0.0

Hash (cost=157.25..157.25 rows=1,575 width=28) (never executed)

13. 0.000 0.000 ↓ 0.0

Foreign Scan (cost=100..157.25 rows=1,575 width=28) (never executed)