explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nUuO

Settings
# exclusive inclusive rows x rows loops node
1. 7.874 426.459 ↑ 1.0 1 1

Aggregate (cost=8,385.84..8,385.85 rows=1 width=32) (actual time=426.459..426.459 rows=1 loops=1)

2.          

Initplan (for Aggregate)

3. 0.003 0.003 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=1)

4. 2.379 418.582 ↑ 2.7 1,518 1

Hash Join (cost=3,508.40..8,365.06 rows=4,153 width=43) (actual time=281.358..418.582 rows=1,518 loops=1)

  • Hash Cond: (s.id = wdqmsapi_synopobservationbysixhourperiod_110.station_id)
5. 136.574 136.574 ↑ 2.7 2,134 1

Seq Scan on wdqmsapi_synopstation s (cost=0.00..4,841.72 rows=5,691 width=37) (actual time=1.406..136.574 rows=2,134 loops=1)

  • Filter: st_intersects(geom, $0)
  • Rows Removed by Filter: 14,938
6. 6.310 279.629 ↑ 1.2 10,802 1

Hash (cost=3,352.68..3,352.68 rows=12,458 width=10) (actual time=279.629..279.629 rows=10,802 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 572kB
7. 31.131 273.319 ↑ 1.2 10,802 1

HashAggregate (cost=3,103.52..3,228.10 rows=12,458 width=10) (actual time=266.847..273.319 rows=10,802 loops=1)

  • Group Key: wdqmsapi_synopobservationbysixhourperiod_110.station_id
8. 7.136 242.188 ↑ 1.0 42,051 1

Append (cost=0.57..2,679.06 rows=42,446 width=10) (actual time=8.441..242.188 rows=42,051 loops=1)

9. 235.052 235.052 ↑ 1.0 42,051 1

Index Scan using wdqmsapi_synopobservationbysixhourperiod_110_period_id_idx on wdqmsapi_synopobservationbysixhourperiod_110 (cost=0.57..2,466.83 rows=42,446 width=10) (actual time=8.440..235.052 rows=42,051 loops=1)

  • Index Cond: (period_id = ANY ('{13038,11925,11929,11921}'::integer[]))
  • Filter: ((quality_only IS FALSE) AND (var_id = ANY ('{110,1}'::integer[])) AND ((nr_received > 0) OR (nr_expected > 0)))
  • Rows Removed by Filter: 1,218
Planning time : 180.931 ms
Execution time : 427.742 ms