explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Kxvr

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

Limit (cost=0.01..5.64 rows=1 width=1,012) (never executed)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.01..3,516,260.01 rows=625,000 width=1,012) (never executed)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.01..697,510.01 rows=125,000 width=972) (never executed)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.01..135,010.01 rows=25,000 width=940) (never executed)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.01..22,510.01 rows=5,000 width=908) (never executed)

6. 0.000 0.000 ↓ 0.0

Function Scan on read_intermediate_result intermediate_result (cost=0..10 rows=1,000 width=876) (never executed)

7. 0.000 0.000 ↓ 0.0

Function Scan on read_intermediate_result intermediate_result_1 (cost=0..10 rows=1,000 width=130) (never executed)

8. 0.000 0.000 ↓ 0.0

Function Scan on read_intermediate_result intermediate_result_2 (cost=0..10 rows=1,000 width=130) (never executed)

9. 0.000 0.000 ↓ 0.0

Function Scan on read_intermediate_result intermediate_result_3 (cost=0..10 rows=1,000 width=130) (never executed)

10. 0.000 0.000 ↓ 0.0

Function Scan on read_intermediate_result intermediate_result_4 (cost=0..10 rows=1,000 width=130) (never executed)

Planning time : 0.873 ms