explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vI4a : enable_partitionwise_join on

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

GroupAggregate (cost=21,596,647.78..26,108,502.44 rows=1,055,405 width=80) (actual rows= loops=)

  • Group Key: deal_y2020_m06.login, deal_y2020_m06.position_id
  • Filter: ((count(deal_y2020_m06.deal) > 2) AND (sum(deal_y2020_m06.volume) FILTER (WHERE (deal_y2020_m06.entry = 0)) < sum(deal_y2020_m06.volume) FILTER (WHERE (deal_y2020_m06.entry = 1))))
  • Functions: 18
2. 0.000 0.000 ↓ 0.0

Sort (cost=21,596,647.78..21,834,113.82 rows=94,986,414 width=44) (actual rows= loops=)

  • Sort Key: deal_y2020_m06.login, deal_y2020_m06.position_id
3. 0.000 0.000 ↓ 0.0

Append (cost=0.42..7,298,943.44 rows=94,986,414 width=44) (actual rows= loops=)

  • Subplans Removed: 95
4. 0.000 0.000 ↓ 0.0

Seq Scan on deal_y2020_m06 (cost=0.00..2,231,968.54 rows=30,066,636 width=44) (actual rows= loops=)

  • Filter: ((time_deal >= '2020-06-01 00:00:00'::timestamp without time zone) AND (time_deal < '2020-08-28 00:00:00'::timestamp without time zone))
5. 0.000 0.000 ↓ 0.0

Seq Scan on deal_y2020_m07 (cost=0.00..2,459,005.46 rows=34,512,164 width=44) (actual rows= loops=)

  • Filter: ((time_deal >= '2020-06-01 00:00:00'::timestamp without time zone) AND (time_deal < '2020-08-28 00:00:00'::timestamp without time zone))
6. 0.000 0.000 ↓ 0.0

Seq Scan on deal_y2020_m08 (cost=0.00..2,132,803.09 rows=30,407,519 width=44) (actual rows= loops=)

  • Filter: ((time_deal >= '2020-06-01 00:00:00'::timestamp without time zone) AND (time_deal < '2020-08-28 00:00:00'::timestamp without time zone))