explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EJnP

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 30,105.520 ↑ 1.0 30 1

Limit (cost=331,114.30..331,117.51 rows=30 width=1,340) (actual time=30,105.499..30,105.520 rows=30 loops=1)

  • Functions: 2
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 0.227 ms, Inlining 0.000 ms, Optimization 0.122 ms, Emission 1.016 ms, Total 1.365 ms
2. 160.814 30,128.132 ↑ 31,287.7 30 1

Gather Merge (cost=331,114.30..431,547.92 rows=938,632 width=1,340) (actual time=30,104.280..30,128.132 rows=30 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
3. 156.131 29,967.318 ↑ 39,109.7 24 2 / 2

Sort (cost=330,114.29..330,583.61 rows=938,632 width=1,340) (actual time=29,967.315..29,967.318 rows=24 loops=2)

  • Sort Key: created_at DESC
  • Sort Method: top-N heapsort Memory: 135kB
  • Worker 0: Sort Method: top-N heapsort Memory: 137kB
4. 29,811.187 29,811.187 ↑ 1.2 802,410 2 / 2

Parallel Seq Scan on webhooks (cost=0.00..324,569.90 rows=938,632 width=1,340) (actual time=1.056..29,811.187 rows=802,410 loops=2)

Planning time : 0.095 ms
Execution time : 30,129.659 ms