explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ffWf

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 167,148.860 ↑ 1.0 15 1

Limit (cost=181,678.47..181,680.22 rows=15 width=116) (actual time=167,146.767..167,148.860 rows=15 loops=1)

2. 7.839 167,148.853 ↑ 120,733.3 15 1

Gather Merge (cost=181,678.47..392,976.56 rows=1,811,000 width=116) (actual time=167,146.765..167,148.853 rows=15 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 280.736 167,141.014 ↑ 60,366.7 15 3 / 3

Sort (cost=180,678.45..182,942.20 rows=905,500 width=116) (actual time=167,141.013..167,141.014 rows=15 loops=3)

  • Sort Key: p.process_name
  • Sort Method: top-N heapsort Memory: 31kB
  • Worker 0: Sort Method: top-N heapsort Memory: 32kB
  • Worker 1: Sort Method: top-N heapsort Memory: 31kB
4. 58.372 166,860.278 ↑ 1.3 724,393 3 / 3

Parallel Append (cost=0.00..158,462.50 rows=905,500 width=116) (actual time=2.855..166,860.278 rows=724,393 loops=3)

5. 94,402.609 94,402.609 ↑ 1.3 430,691 3 / 3

Parallel Seq Scan on _hyper_47_300_chunk p (cost=0.00..91,522.69 rows=538,369 width=116) (actual time=16.058..94,402.609 rows=430,691 loops=3)

6. 72,399.297 72,399.297 ↓ 1.2 440,553 2 / 3

Parallel Seq Scan on _hyper_47_315_chunk p_1 (cost=0.00..62,412.31 rows=367,131 width=116) (actual time=0.045..108,598.946 rows=440,553 loops=2)

Planning time : 0.197 ms
Execution time : 167,148.984 ms