explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gMwd

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.062 22,164.406 ↓ 10.0 10 1

Limit (cost=119.01..119.01 rows=1 width=93) (actual time=22,164.400..22,164.406 rows=10 loops=1)

2. 473.670 22,164.344 ↓ 82.9 580 1

Sort (cost=118.99..119.01 rows=7 width=93) (actual time=22,164.110..22,164.344 rows=580 loops=1)

  • Sort Key: "time" DESC
  • Sort Method: top-N heapsort Memory: 828kB
3. 21,690.674 21,690.674 ↓ 134,541.6 941,791 1

Foreign Scan on commits (cost=100.00..118.89 rows=7 width=93) (actual time=5.398..21,690.674 rows=941,791 loops=1)

Planning time : 0.162 ms
Execution time : 22,166.731 ms