explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dLZge

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 186.380 ↑ 1.0 20 1

Limit (cost=128,833.89..128,833.94 rows=20 width=137) (actual time=186.372..186.380 rows=20 loops=1)

2. 34.595 186.375 ↑ 4,602.9 21 1

Sort (cost=128,833.89..129,075.54 rows=96,660 width=137) (actual time=186.370..186.375 rows=21 loops=1)

  • Sort Key: updated_at, id DESC
  • Sort Method: top-N heapsort Memory: 30kB
3. 151.780 151.780 ↓ 1.1 102,430 1

Index Scan using index_deployments_on_project_id_and_status on deployments (cost=0.56..126,227.78 rows=96,660 width=137) (actual time=0.030..151.780 rows=102,430 loops=1)

  • Index Cond: (project_id = 278964)
Planning time : 0.174 ms
Execution time : 186.409 ms