explain.depesz.com

PostgreSQL's explain analyze made readable

Result: l41V

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

Finalize Aggregate (cost=3,531.20..3,531.21 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Gather (cost=1,001.88..3,531.19 rows=4 width=8) (actual rows= loops=)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Parallel Append (cost=1.88..2,530.79 rows=2 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Partial Aggregate (cost=2,528.88..2,528.89 rows=1 width=8) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Parallel Hash Join (cost=932.64..2,455.37 rows=29,406 width=0) (actual rows= loops=)

  • Hash Cond: (p2_1.c1 = p1_1.c1)
6. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on part2p2 p2_1 (cost=0.00..1,129.18 rows=58,818 width=4) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=565.06..565.06 rows=29,406 width=4) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on part1p2 p1_1 (cost=0.00..565.06 rows=29,406 width=4) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Partial Aggregate (cost=1.88..1.89 rows=1 width=8) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.14..1.87 rows=5 width=0) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on part2p1 p2 (cost=0.00..1.05 rows=5 width=4) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Index Only Scan using part1p1_c1_idx on part1p1 p1 (cost=0.14..0.15 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (c1 = p2.c1)