explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OGXr

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

GroupAggregate (cost=6,266,350.05..6,374,967.76 rows=81,076 width=84) (actual rows= loops=)

  • Group Key: shape_id
2. 0.000 0.000 ↓ 0.0

Sort (cost=6,266,350.05..6,268,868.63 rows=1,007,429 width=1,188) (actual rows= loops=)

  • Sort Key: shape_id
3. 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,595,717.57 rows=1,007,429 width=1,188) (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))