explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0Msc

Settings
# exclusive inclusive rows x rows loops node
1. 0.032 1.143 ↑ 1.0 50 1

Limit (cost=860.46..946.45 rows=50 width=138) (actual time=1.071..1.143 rows=50 loops=1)

  • Buffers: shared hit=536
2. 1.111 1.111 ↑ 176.6 550 1

Index Scan using deployments_updated_ad_project_id on public.deployments (cost=0.56..167,059.82 rows=97,139 width=138) (actual time=0.032..1.111 rows=550 loops=1)

  • Index Cond: (deployments.project_id = 278964)
  • Buffers: shared hit=536