explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Mkwk

Settings
# exclusive inclusive rows x rows loops node
1. 549.896 4,369.719 ↓ 13.6 263,076 1

GroupAggregate (cost=20,928.81..21,411.18 rows=19,280 width=69) (actual time=3,483.557..4,369.719 rows=263,076 loops=1)

  • Group Key: "timestamp", variant, mode
2. 1,517.728 3,819.823 ↓ 193.8 3,742,254 1

Sort (cost=20,928.81..20,977.08 rows=19,310 width=33) (actual time=3,483.539..3,819.823 rows=3,742,254 loops=1)

  • Sort Key: "timestamp", variant, mode
  • Sort Method: external merge Disk: 124,576kB
3. 2,302.095 2,302.095 ↓ 193.8 3,742,254 1

Index Scan using traffic_data_point_exp_id_timestamp_idx on traffic_data_point (cost=0.56..19,554.22 rows=19,310 width=33) (actual time=0.034..2,302.095 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))