explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bCpVW

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

Gather Merge (cost=4,840,037.15..16,813,501.20 rows=100,000,000 width=14) (actual rows= loops=)

  • Output: id, data, user_id
  • Workers Planned: 4
2. 0.000 0.000 ↓ 0.0

Sort (cost=4,839,037.09..4,901,537.09 rows=25,000,000 width=14) (actual rows= loops=)

  • Output: id, data, user_id
  • Sort Key: purchase.id, purchase.user_id
3. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on public.purchase (cost=0.00..790,541.00 rows=25,000,000 width=14) (actual rows= loops=)

  • Output: id, data, user_id