explain.depesz.com

PostgreSQL's explain analyze made readable

Result: s1YL

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.005 3,401.019 ↑ 1.0 10 1

Limit (cost=1,049,533.21..1,049,534.37 rows=10 width=20) (actual time=3,397.457..3,401.019 rows=10 loops=1)

  • Buffers: shared hit=1122 read=341445
2. 0.000 3,401.014 ↑ 4,467,132.0 10 1

Gather Merge (cost=1,049,533.21..6,261,551.09 rows=44,671,320 width=20) (actual time=3,397.454..3,401.014 rows=10 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=1122 read=341445
3. 4,719.693 10,161.792 ↑ 2,233,566.0 10 3

Sort (cost=1,048,533.18..1,104,372.33 rows=22,335,660 width=20) (actual time=3,387.263..3,387.264 rows=10 loops=3)

  • Sort Key: clock DESC
  • Sort Method: top-N heapsort Memory: 25kB
  • Worker 0: Sort Method: top-N heapsort Memory: 25kB
  • Worker 1: Sort Method: top-N heapsort Memory: 25kB
  • Buffers: shared hit=1122 read=341445
4. 5,442.099 5,442.099 ↑ 1.2 17,868,669 3

Parallel Seq Scan on _hyper_2_1093_chunk (cost=0.00..565,867.60 rows=22,335,660 width=20) (actual time=0.073..1,814.033 rows=17,868,669 loops=3)

  • Buffers: shared hit=1066 read=341445
Planning time : 0.185 ms
Execution time : 3,401.084 ms