explain.depesz.com

PostgreSQL's explain analyze made readable

Result: G6HK

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.119 ↑ 1.0 20 1

Limit (cost=1.87..27.97 rows=20 width=138) (actual time=0.055..0.119 rows=20 loops=1)

2. 0.118 0.118 ↑ 4,821.6 21 1

Index Scan Backward using index_deployments_on_project_id_and_updated_at on deployments (cost=0.56..132,148.51 rows=101,254 width=138) (actual time=0.051..0.118 rows=21 loops=1)

  • Index Cond: (project_id = 278964)
Planning time : 0.147 ms
Execution time : 0.140 ms