explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pS57

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 762.960 ↑ 1.0 15 1

Limit (cost=181,678.19..181,679.94 rows=15 width=116) (actual time=760.792..762.960 rows=15 loops=1)

2. 7.300 762.954 ↑ 120,732.4 15 1

Gather Merge (cost=181,678.19..392,974.64 rows=1,810,986 width=116) (actual time=760.791..762.954 rows=15 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 244.346 755.654 ↑ 60,366.2 15 3 / 3

Sort (cost=180,678.17..182,941.90 rows=905,493 width=116) (actual time=755.653..755.654 rows=15 loops=3)

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

Parallel Append (cost=0.00..158,462.39 rows=905,493 width=116) (actual time=0.031..511.308 rows=724,393 loops=3)

5. 268.632 268.632 ↑ 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=0.031..268.632 rows=430,691 loops=3)

6. 189.296 189.296 ↓ 1.2 440,553 2 / 3

Parallel Seq Scan on _hyper_47_315_chunk p_1 (cost=0.00..62,412.24 rows=367,124 width=116) (actual time=0.037..283.944 rows=440,553 loops=2)

Planning time : 0.198 ms
Execution time : 763.097 ms