explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sBb5

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

GroupAggregate (cost=35,037,559.81..35,138,304.05 rows=915,857 width=16) (actual rows= loops=)

  • Group Key: zz.shape_id, zz.ntile_bucket
2. 0.000 0.000 ↓ 0.0

Sort (cost=35,037,559.81..35,060,456.23 rows=9,158,567 width=16) (actual rows= loops=)

  • Sort Key: zz.shape_id, zz.ntile_bucket
3. 0.000 0.000 ↓ 0.0

Subquery Scan on zz (cost=33,322,036.83..33,665,483.09 rows=9,158,567 width=16) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

WindowAgg (cost=33,322,036.83..33,573,897.42 rows=9,158,567 width=16) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Sort (cost=33,322,036.83..33,344,933.25 rows=9,158,567 width=12) (actual rows= loops=)

  • Sort Key: facttable_noaa.shape_id, (((facttable_noaa.data ->> 'air_temperature_f_mean_prediction_autokrig'::text))::double precision)
6. 0.000 0.000 ↓ 0.0

Index Scan using idx_exposome_pici_facttable_noaa_data_id_startdate_enddate on facttable_noaa (cost=0.70..31,949,960.11 rows=9,158,567 width=12) (actual rows= loops=)

  • Index Cond: ((data_id = 118295) AND (startdate >= '2013-01-01 00:00:00'::timestamp without time zone) AND (startdate <= '2015-01-01 00:00:00'::timestamp without time zone) AND (enddate >= '2013-01-01 00:00:00'::timestamp without time zone) AND (enddate <= '2015-01-01 00:00:00'::timestamp without time zone))