explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TLD9

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

Finalize GroupAggregate (cost=1,953,424.91..2,231,657.36 rows=2,325,678 width=69) (actual time=56,794.468..57,387.311 rows=265,540 loops=1)

  • Group Key: "timestamp", variant, mode
2. 81.091 57,296.939 ↑ 5.6 304,681 1

Gather Merge (cost=1,953,424.91..2,185,402.84 rows=1,718,355 width=37) (actual time=56,794.457..57,296.939 rows=304,681 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
3. 260.723 57,215.848 ↑ 11.3 152,340 2 / 2

Partial GroupAggregate (cost=1,952,424.90..1,991,087.89 rows=1,718,355 width=37) (actual time=56,786.498..57,215.848 rows=152,340 loops=2)

  • Group Key: "timestamp", variant, mode
4. 1,104.767 56,955.125 ↓ 1.1 1,900,005 2 / 2

Sort (cost=1,952,424.90..1,956,720.79 rows=1,718,355 width=33) (actual time=56,786.491..56,955.125 rows=1,900,005 loops=2)

  • Sort Key: "timestamp", variant, mode
  • Sort Method: external merge Disk: 63944kB
  • Worker 0: Sort Method: external merge Disk: 62560kB
5. 55,850.358 55,850.358 ↓ 1.1 1,900,005 2 / 2

Parallel Seq Scan on traffic_data_point (cost=0.00..1,720,766.93 rows=1,718,355 width=33) (actual time=0.184..55,850.358 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: 26282692