explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OZnj

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

GroupAggregate (cost=97,784,761.75..99,521,212.20 rows=81,076 width=84) (actual rows= loops=)

  • Group Key: shape_id
2. 0.000 0.000 ↓ 0.0

Sort (cost=97,784,761.75..97,826,038.25 rows=16,510,598 width=1,188) (actual rows= loops=)

  • Sort Key: shape_id
3. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on facttable_epa (cost=592,258.83..61,494,309.87 rows=16,510,598 width=1,188) (actual rows= loops=)

  • Recheck Cond: ((data_id = 118299) AND (startdate >= '2013-01-01 00:00:00'::timestamp without time zone) AND (startdate <= '2014-12-31 00:00:00'::timestamp without time zone))
4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_exposome_pici_facttable_epa_data_id_startdate_enddate (cost=0.00..588,131.18 rows=16,510,598 width=0) (actual rows= loops=)

  • Index Cond: ((data_id = 118299) AND (startdate >= '2013-01-01 00:00:00'::timestamp without time zone) AND (startdate <= '2014-12-31 00:00:00'::timestamp without time zone))