explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 63XO

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

GroupAggregate (cost=4,876,395.85..4,887,477.57 rows=100,743 width=16) (actual rows= loops=)

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

Sort (cost=4,876,395.85..4,878,914.42 rows=1,007,429 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=4,720,945.27..4,758,723.86 rows=1,007,429 width=16) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

WindowAgg (cost=4,720,945.27..4,748,649.57 rows=1,007,429 width=16) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Sort (cost=4,720,945.27..4,723,463.84 rows=1,007,429 width=12) (actual rows= loops=)

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

Index Scan using idx_exposome_pici_facttable_epa_data_id_startdate_enddate on facttable_epa (cost=0.71..4,603,273.28 rows=1,007,429 width=12) (actual rows= loops=)

  • Index Cond: ((data_id = 118299) 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))