explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LbxW

Settings
# exclusive inclusive rows x rows loops node
1. 161.470 66,731.848 ↓ 13.9 263,076 1

Finalize GroupAggregate (cost=1,500,219.28..1,502,611.44 rows=18,900 width=69) (actual time=65,926.459..66,731.848 rows=263,076 loops=1)

  • Group Key: "timestamp", variant, mode
2. 98.489 66,570.378 ↓ 19.6 308,771 1

Gather Merge (cost=1,500,219.28..1,502,217.45 rows=15,774 width=37) (actual time=65,926.433..66,570.378 rows=308,771 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 333.676 66,471.889 ↓ 13.0 102,924 3 / 3

Partial GroupAggregate (cost=1,499,219.26..1,499,396.71 rows=7,887 width=37) (actual time=65,914.473..66,471.889 rows=102,924 loops=3)

  • Group Key: "timestamp", variant, mode
4. 903.270 66,138.213 ↓ 158.2 1,247,418 3 / 3

Sort (cost=1,499,219.26..1,499,238.97 rows=7,887 width=33) (actual time=65,914.464..66,138.213 rows=1,247,418 loops=3)

  • Sort Key: "timestamp", variant, mode
  • Sort Method: external merge Disk: 41,664kB
  • Worker 0: Sort Method: external merge Disk: 42,288kB
  • Worker 1: Sort Method: external merge Disk: 40,632kB
5. 65,234.943 65,234.943 ↓ 158.2 1,247,418 3 / 3

Parallel Seq Scan on traffic_data_point (cost=0.00..1,498,708.76 rows=7,887 width=33) (actual time=11,536.984..65,234.943 rows=1,247,418 loops=3)

  • Filter: (((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 Filter: 17,481,318