explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kHj5

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 106,585.332 ↑ 1.0 100 1

Limit (cost=5,077,691.54..5,077,702.78 rows=100 width=69) (actual time=106,584.881..106,585.332 rows=100 loops=1)

2. 0.000 106,585.323 ↑ 55,340.8 100 1

Finalize GroupAggregate (cost=5,077,691.54..5,699,684.94 rows=5,534,078 width=69) (actual time=106,584.880..106,585.323 rows=100 loops=1)

  • Group Key: "timestamp", variant, mode
3. 55.937 106,637.949 ↑ 20,833.5 183 1

Gather Merge (cost=5,077,691.54..5,592,383.63 rows=3,812,534 width=37) (actual time=106,584.862..106,637.949 rows=183 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
4. 0.884 106,582.012 ↑ 7,008.3 544 2 / 2

Partial GroupAggregate (cost=5,076,691.53..5,162,473.54 rows=3,812,534 width=37) (actual time=106,580.446..106,582.012 rows=544 loops=2)

  • Group Key: "timestamp", variant, mode
5. 1,658.472 106,581.128 ↑ 577.7 6,600 2 / 2

Sort (cost=5,076,691.53..5,086,222.86 rows=3,812,534 width=33) (actual time=106,580.435..106,581.128 rows=6,600 loops=2)

  • Sort Key: "timestamp", variant, mode
  • Sort Method: external merge Disk: 125,568kB
  • Worker 0: Sort Method: external merge Disk: 124,912kB
6. 104,922.656 104,922.656 ↑ 1.1 3,359,010 2 / 2

Parallel Seq Scan on traffic_data_point (cost=0.00..4,540,793.36 rows=3,812,534 width=33) (actual time=88,895.870..104,922.656 rows=3,359,010 loops=2)

  • Filter: ((experiment_id)::text = '930d47c9-bda8-4985-85b5-b6986c76544c'::text)
  • Rows Removed by Filter: 87,558,076
Planning time : 0.111 ms
Execution time : 106,653.602 ms