explain.depesz.com

PostgreSQL's explain analyze made readable

Result: r3V1

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

Finalize GroupAggregate (cost=11,281.70..11,334.25 rows=234 width=139) (actual rows= loops=)

  • Group Key: deal_date
2. 0.000 0.000 ↓ 0.0

Gather Merge (cost=11,281.70..11,322.64 rows=308 width=139) (actual rows= loops=)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Partial GroupAggregate (cost=10,281.68..10,287.07 rows=154 width=139) (actual rows= loops=)

  • Group Key: deal_date
4. 0.000 0.000 ↓ 0.0

Sort (cost=10,281.68..10,282.06 rows=154 width=29) (actual rows= loops=)

  • Sort Key: deal_date
5. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on profit_or_loss_ref_order_ids (cost=0.00..10,276.08 rows=154 width=29) (actual rows= loops=)

  • Filter: ((host_id = 15) AND (fund_id = 0) AND (sub_id = 38))