explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lLwU

Settings
# exclusive inclusive rows x rows loops node
1. 172.517 6,001.436 ↓ 14.3 262,764 1

Finalize GroupAggregate (cost=1,833,847.30..1,836,180.93 rows=18,438 width=69) (actual time=5,187.084..6,001.436 rows=262,764 loops=1)

  • Group Key: "timestamp", variant, mode
2. 195.237 5,828.919 ↓ 37.1 571,619 1

Gather Merge (cost=1,833,847.30..1,835,796.57 rows=15,388 width=37) (actual time=5,187.065..5,828.919 rows=571,619 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 287.454 5,633.682 ↓ 24.8 190,540 3 / 3

Partial GroupAggregate (cost=1,832,847.28..1,833,020.39 rows=7,694 width=37) (actual time=5,174.174..5,633.682 rows=190,540 loops=3)

  • Group Key: "timestamp", variant, mode
4. 910.681 5,346.228 ↓ 161.8 1,244,567 3 / 3

Sort (cost=1,832,847.28..1,832,866.51 rows=7,694 width=33) (actual time=5,174.165..5,346.228 rows=1,244,567 loops=3)

  • Sort Key: "timestamp", variant, mode
  • Sort Method: external merge Disk: 49,656kB
  • Worker 0: Sort Method: external merge Disk: 33,864kB
  • Worker 1: Sort Method: external merge Disk: 40,784kB
5. 4,435.547 4,435.547 ↓ 161.8 1,244,567 3 / 3

Parallel Seq Scan on traffic_data_point (cost=0.00..1,832,350.65 rows=7,694 width=33) (actual time=0.048..4,435.547 rows=1,244,567 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,237,772