explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mhdB

Settings
# exclusive inclusive rows x rows loops node
1. 2.459 35.257 ↓ 233.7 1,402 1

GroupAggregate (cost=512.49..512.66 rows=6 width=43) (actual time=32.598..35.257 rows=1,402 loops=1)

  • Output: wdqmsapi_synopobservationbysixhourperiod.station_id, max(wdqmsapi_synopobservationbysixhourperiod.nr_received), COALESCE((max(wdqmsapi_synopobservationbysixhourperiod.nr_expected))::integer, 0), wdqmsapi_synopobservationbysixhourperiod.in_oscar, wdqmsapi_synopobservationbysixhourperiod.geom
  • Group Key: wdqmsapi_synopobservationbysixhourperiod.station_id, wdqmsapi_synopobservationbysixhourperiod.in_oscar, wdqmsapi_synopobservationbysixhourperiod.geom
2. 2.333 32.798 ↓ 466.3 2,798 1

Sort (cost=512.49..512.51 rows=6 width=41) (actual time=32.581..32.798 rows=2,798 loops=1)

  • Output: wdqmsapi_synopobservationbysixhourperiod.station_id, wdqmsapi_synopobservationbysixhourperiod.in_oscar, wdqmsapi_synopobservationbysixhourperiod.geom, wdqmsapi_synopobservationbysixhourperiod.nr_received, wdqmsapi_synopobservationbysixhourperiod.nr_expected
  • Sort Key: wdqmsapi_synopobservationbysixhourperiod.station_id, wdqmsapi_synopobservationbysixhourperiod.in_oscar, wdqmsapi_synopobservationbysixhourperiod.geom
  • Sort Method: quicksort Memory: 315kB
3. 19.625 30.465 ↓ 466.3 2,798 1

Bitmap Heap Scan on public.wdqmsapi_synopobservationbysixhourperiod (cost=5.32..512.41 rows=6 width=41) (actual time=17.023..30.465 rows=2,798 loops=1)

  • Output: wdqmsapi_synopobservationbysixhourperiod.station_id, wdqmsapi_synopobservationbysixhourperiod.in_oscar, wdqmsapi_synopobservationbysixhourperiod.geom, wdqmsapi_synopobservationbysixhourperiod.nr_received, wdqmsapi_synopobservationbysixhourperiod.nr_expected
  • Recheck Cond: ('0103000020110F000001000000050000000000000000000000DA1B7C45F81B73C100000000000000000000000000000000DA1B7C45F81B73410000000000000000DA1B7C45F81B7341DA1B7C45F81B73C10000000000000000DA1B7C45F81B73C1'::geometry ~ wdqmsapi_synopobservationbysixhourperiod.geom)
  • Filter: ((wdqmsapi_synopobservationbysixhourperiod.period_id = ANY ('{2,1}'::integer[])) AND (wdqmsapi_synopobservationbysixhourperiod.var_id = ANY ('{110,1}'::integer[])) AND ((wdqmsapi_synopobservationbysixhourperiod.nr_received > 0) OR (wdqmsapi_synopobservationbysixhourperiod.nr_expected > 0)) AND _st_contains('0103000020110F000001000000050000000000000000000000DA1B7C45F81B73C100000000000000000000000000000000DA1B7C45F81B73410000000000000000DA1B7C45F81B7341DA1B7C45F81B73C10000000000000000DA1B7C45F81B73C1'::geometry, wdqmsapi_synopobservationbysixhourperiod.geom))
  • Rows Removed by Filter: 15,344
  • Heap Blocks: exact=1,219
4. 10.840 10.840 ↓ 131.5 18,142 1

Bitmap Index Scan on wdqmsapi_synopobservationbysixhourperiod_geom_id (cost=0.00..5.32 rows=138 width=0) (actual time=10.840..10.840 rows=18,142 loops=1)

  • Index Cond: ('0103000020110F000001000000050000000000000000000000DA1B7C45F81B73C100000000000000000000000000000000DA1B7C45F81B73410000000000000000DA1B7C45F81B7341DA1B7C45F81B73C10000000000000000DA1B7C45F81B73C1'::geometry ~ wdqmsapi_synopobservationbysixhourperiod.geom)
Planning time : 12.965 ms
Execution time : 36.248 ms