explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FVFm

Settings
# exclusive inclusive rows x rows loops node
1. 55.347 16,012.720 ↑ 10.2 263,076 1

Finalize GroupAggregate (cost=617,190.58..1,050,879.52 rows=2,674,962 width=69) (actual time=15,547.549..16,012.720 rows=263,076 loops=1)

  • Group Key: "timestamp", variant, mode
2. 120.772 15,957.373 ↑ 10.1 289,146 1

Gather Merge (cost=617,190.58..988,157.52 rows=2,928,498 width=37) (actual time=15,547.537..15,957.373 rows=289,146 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 184.033 15,836.601 ↑ 15.2 96,382 3 / 3

Partial GroupAggregate (cost=616,190.56..649,136.16 rows=1,464,249 width=37) (actual time=15,537.405..15,836.601 rows=96,382 loops=3)

  • Group Key: "timestamp", variant, mode
4. 775.132 15,652.568 ↑ 1.2 1,247,418 3 / 3

Sort (cost=616,190.56..619,851.18 rows=1,464,249 width=33) (actual time=15,537.397..15,652.568 rows=1,247,418 loops=3)

  • Sort Key: "timestamp", variant, mode
  • Sort Method: external merge Disk: 43480kB
  • Worker 0: Sort Method: external merge Disk: 40424kB
  • Worker 1: Sort Method: external merge Disk: 40680kB
5. 14,877.436 14,877.436 ↑ 1.2 1,247,418 3 / 3

Parallel Index Scan using traffic_data_point_exp_id_timestamp_idx on traffic_data_point (cost=0.56..293,494.80 rows=1,464,249 width=33) (actual time=0.207..14,877.436 rows=1,247,418 loops=3)

  • 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))