explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pQrb

Settings
# exclusive inclusive rows x rows loops node
1. 265.377 1,416.618 ↓ 1.0 211,712 1

Finalize HashAggregate (cost=62,258.19..64,290.78 rows=203,259 width=8) (actual time=1,315.949..1,416.618 rows=211,712 loops=1)

  • Group Key: case_id
2. 27.244 1,151.241 ↓ 1.2 211,712 1

Gather (cost=43,121.93..61,388.36 rows=173,966 width=8) (actual time=1,017.492..1,151.241 rows=211,712 loops=1)

  • Workers Planned: 2
  • Workers Launched: 0
3. 321.698 1,123.997 ↓ 2.4 211,712 1

Partial HashAggregate (cost=42,121.93..42,991.76 rows=86,983 width=8) (actual time=1,017.003..1,123.997 rows=211,712 loops=1)

  • Group Key: case_id
4. 802.299 802.299 ↓ 2.4 211,712 1

Parallel Seq Scan on event e (cost=0.00..41,687.02 rows=86,983 width=8) (actual time=0.049..802.299 rows=211,712 loops=1)

  • Filter: (event_type = 'summary_judgment'::text)
  • Rows Removed by Filter: 2670693