explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Pvpe

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

Nested Loop (cost=64,656.41..64,664.46 rows=1 width=101) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Index Scan using posting_pkey on posting p (cost=0.42..8.44 rows=1 width=93) (actual rows= loops=)

  • Index Cond: (posting_id = 108,123,362)
3. 0.000 0.000 ↓ 0.0

Finalize Aggregate (cost=64,655.99..64,656.00 rows=1 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Gather (cost=64,655.77..64,655.98 rows=2 width=8) (actual rows= loops=)

  • Workers Planned: 2
5. 0.000 0.000 ↓ 0.0

Partial Aggregate (cost=63,655.77..63,655.78 rows=1 width=8) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash Join (cost=32,915.36..62,098.85 rows=622,770 width=4) (actual rows= loops=)

  • Hash Cond: (i.posting_id = p_1.posting_id)
7. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on posting_item i (cost=0.00..27,548.70 rows=622,770 width=12) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Hash (cost=22,734.05..22,734.05 rows=814,505 width=8) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Seq Scan on posting p_1 (cost=0.00..22,734.05 rows=814,505 width=8) (actual rows= loops=)