explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bxt8

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

Finalize GroupAggregate (cost=6,138.72..6,157.97 rows=1,100 width=26) (actual rows= loops=)

  • Group Key: item.item_id
2. 0.000 0.000 ↓ 0.0

Sort (cost=6,138.72..6,141.47 rows=1,100 width=26) (actual rows= loops=)

  • Sort Key: item.item_id
3. 0.000 0.000 ↓ 0.0

Gather (cost=5,962.15..6,083.15 rows=1,100 width=26) (actual rows= loops=)

  • Workers Planned: 1
4. 0.000 0.000 ↓ 0.0

Partial HashAggregate (cost=4,962.15..4,973.15 rows=1,100 width=26) (actual rows= loops=)

  • Group Key: item.item_id
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=31.75..4,226.86 rows=147,059 width=26) (actual rows= loops=)

  • Hash Cond: (store.item_id = item.item_id)
6. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on store (cost=0.00..3,807.59 rows=147,059 width=16) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash (cost=18.00..18.00 rows=1,100 width=18) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Seq Scan on item (cost=0.00..18.00 rows=1,100 width=18) (actual rows= loops=)