explain.depesz.com

PostgreSQL's explain analyze made readable

Result: C6MO : a

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↑ 1.1 557 1

Finalize GroupAggregate (cost=494,481.72..494,496.79 rows=603 width=12) (actual rows=557 loops=1)

  • Output: power_plant_id, count(quantity)
  • Group Key: meteringpo0_.power_plant_id
  • Buffers: shared hit=30274 read=244877
2. 0.000 0.000 ↑ 1.5 789 1

Sort (cost=494,481.72..494,484.73 rows=1,206 width=12) (actual rows=789 loops=1)

  • Output: power_plant_id, (PARTIAL count(quantity))
  • Sort Key: meteringpo0_.power_plant_id
  • Sort Method: quicksort Memory: 61kB
  • Buffers: shared hit=30274 read=244877
3. 0.000 0.000 ↑ 1.5 789 1

Gather (cost=494,293.36..494,419.99 rows=1,206 width=12) (actual rows=789 loops=1)

  • Output: power_plant_id, (PARTIAL count(quantity))
  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=30274 read=244877
4. 0.000 0.000 ↑ 2.3 263 3 / 3

Partial HashAggregate (cost=493,293.36..493,299.39 rows=603 width=12) (actual rows=263 loops=3)

  • Output: power_plant_id, PARTIAL count(quantity)
  • Group Key: meteringpo0_.power_plant_id
  • Buffers: shared hit=30274 read=244877
  • Worker 0: actual rows=252 loops=1
  • Buffers: shared hit=10603 read=80910
  • Worker 1: actual rows=258 loops=1
  • Buffers: shared hit=9362 read=81421
5. 0.000 0.000 ↑ 103.6 17,824 3 / 3

Parallel Seq Scan on public.metering_point_measurement meteringpo0_ (cost=0.00..484,056.41 rows=1,847,390 width=8) (actual rows=17,824 loops=3)

  • Output: power_plant_id, quantity
  • Filter: ((meteringpo0_.start_time >= '2019-10-12 22:00:00'::timestamp without time zone) AND (meteringpo0_.end_time <= '2019-10-13 22:00:00'::timestamp without time zone) AND (meteringpo0_.status >= '5'::numeric) AND ((meteringpo0_.value_name)::text = 'REAL_POWER_GENERATION'::text) AND ((meteringpo0_.resolution)::text = 'PT15M'::text))
  • Rows Removed by Filter: 7409924
  • Buffers: shared hit=30274 read=244877
  • Worker 0: actual rows=16419 loops=1
  • Buffers: shared hit=10603 read=80910
  • Worker 1: actual rows=18195 loops=1
  • Buffers: shared hit=9362 read=81421