explain.depesz.com

PostgreSQL's explain analyze made readable

Result: b78

Settings
# exclusive inclusive rows x rows loops node
1. 554.106 90,437.133 ↓ 13.6 263,076 1

GroupAggregate (cost=71,141.35..71,623.70 rows=19,279 width=69) (actual time=89,547.464..90,437.133 rows=263,076 loops=1)

  • Group Key: "timestamp", variant, mode
2. 1,665.415 89,883.027 ↓ 193.8 3,742,254 1

Sort (cost=71,141.35..71,189.62 rows=19,309 width=33) (actual time=89,547.446..89,883.027 rows=3,742,254 loops=1)

  • Sort Key: "timestamp", variant, mode
  • Sort Method: external merge Disk: 124576kB
3. 87,696.072 88,217.612 ↓ 193.8 3,742,254 1

Bitmap Heap Scan on traffic_data_point (cost=886.75..69,766.84 rows=19,309 width=33) (actual time=530.273..88,217.612 rows=3,742,254 loops=1)

  • Recheck Cond: (((experiment_id)::text = 'd0935d0f-316f-4bc5-90a7-10123b085867'::text) AND (date_part('epoch'::text, "timestamp") >= '1420819927'::double precision) AND (date_part('epoch'::text, "timestamp") <= '1578586327'::double precision))
  • Rows Removed by Index Recheck: 12668706
  • Heap Blocks: exact=43740 lossy=265012
4. 521.540 521.540 ↓ 193.8 3,742,254 1

Bitmap Index Scan on traffic_data_point_exp_id_timestamp_idx (cost=0.00..881.93 rows=19,309 width=0) (actual time=521.540..521.540 rows=3,742,254 loops=1)

  • Index Cond: (((experiment_id)::text = 'd0935d0f-316f-4bc5-90a7-10123b085867'::text) AND (date_part('epoch'::text, "timestamp") >= '1420819927'::double precision) AND (date_part('epoch'::text, "timestamp") <= '1578586327'::double precision))