explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6Nu3

Settings
# exclusive inclusive rows x rows loops node
1. 582.679 54,282.269 ↓ 13.6 263,076 1

GroupAggregate (cost=20,939.64..21,422.24 rows=19,289 width=69) (actual time=53,360.788..54,282.269 rows=263,076 loops=1)

  • Group Key: "timestamp", variant, mode
2. 1,507.355 53,699.590 ↓ 193.7 3,742,254 1

Sort (cost=20,939.64..20,987.94 rows=19,319 width=33) (actual time=53,360.773..53,699.590 rows=3,742,254 loops=1)

  • Sort Key: "timestamp", variant, mode
  • Sort Method: external merge Disk: 124,576kB
3. 52,192.235 52,192.235 ↓ 193.7 3,742,254 1

Index Scan using traffic_data_point_exp_id_timestamp_idx on traffic_data_point (cost=0.56..19,564.35 rows=19,319 width=33) (actual time=2.094..52,192.235 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))
Planning time : 8.040 ms
Execution time : 54,306.703 ms