explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SjiD

Settings
# exclusive inclusive rows x rows loops node
1. 141.774 39,821.758 ↓ 13.9 263,076 1

Finalize GroupAggregate (cost=1,502,927.47..1,505,323.88 rows=18,934 width=69) (actual time=39,046.557..39,821.758 rows=263,076 loops=1)

  • Group Key: "timestamp", variant, mode
2. 98.182 39,679.984 ↓ 19.6 309,372 1

Gather Merge (cost=1,502,927.47..1,504,929.19 rows=15,802 width=37) (actual time=39,046.537..39,679.984 rows=309,372 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 335.343 39,581.802 ↓ 13.1 103,124 3 / 3

Partial GroupAggregate (cost=1,501,927.45..1,502,105.22 rows=7,901 width=37) (actual time=39,031.235..39,581.802 rows=103,124 loops=3)

  • Group Key: "timestamp", variant, mode
4. 912.654 39,246.459 ↓ 157.9 1,247,418 3 / 3

Sort (cost=1,501,927.45..1,501,947.20 rows=7,901 width=33) (actual time=39,031.221..39,246.459 rows=1,247,418 loops=3)

  • Sort Key: "timestamp", variant, mode
  • Sort Method: external merge Disk: 42056kB
  • Worker 0: Sort Method: external merge Disk: 40848kB
  • Worker 1: Sort Method: external merge Disk: 41688kB
5. 38,333.805 38,333.805 ↓ 157.9 1,247,418 3 / 3

Parallel Seq Scan on traffic_data_point (cost=0.00..1,501,415.95 rows=7,901 width=33) (actual time=7,023.966..38,333.805 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: 17513702