explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4Abu : master

Settings
# exclusive inclusive rows x rows loops node
1. 91.940 57,762.994 ↑ 8.8 265,540 1

Finalize GroupAggregate (cost=1,953,409.25..2,231,639.43 rows=2,325,659 width=69) (actual time=57,167.507..57,762.994 rows=265,540 loops=1)

  • Group Key: "timestamp", variant, mode
2. 68.829 57,671.054 ↑ 5.7 302,571 1

Gather Merge (cost=1,953,409.25..2,185,385.28 rows=1,718,341 width=37) (actual time=57,167.494..57,671.054 rows=302,571 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
3. 265.708 57,602.225 ↑ 11.4 151,286 2 / 2

Partial GroupAggregate (cost=1,952,409.24..1,991,071.91 rows=1,718,341 width=37) (actual time=57,163.033..57,602.225 rows=151,286 loops=2)

  • Group Key: "timestamp", variant, mode
4. 1,128.551 57,336.517 ↓ 1.1 1,900,005 2 / 2

Sort (cost=1,952,409.24..1,956,705.09 rows=1,718,341 width=33) (actual time=57,163.025..57,336.517 rows=1,900,005 loops=2)

  • Sort Key: "timestamp", variant, mode
  • Sort Method: external merge Disk: 63,424kB
  • Worker 0: Sort Method: external merge Disk: 63,072kB
5. 56,207.966 56,207.966 ↓ 1.1 1,900,005 2 / 2

Parallel Seq Scan on traffic_data_point (cost=0.00..1,720,752.82 rows=1,718,341 width=33) (actual time=0.384..56,207.966 rows=1,900,005 loops=2)

  • Filter: (((experiment_id)::text = 'd0935d0f-316f-4bc5-90a7-10123b085867'::text) AND (date_part('epoch'::text, "timestamp") >= '1570693998'::double precision) AND (date_part('epoch'::text, "timestamp") <= '1578660253'::double precision))
  • Rows Removed by Filter: 26,282,438