explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0Tuj

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 0.565 ↑ 1.0 50 1

Limit (cost=0.56..86.55 rows=50 width=138) (actual time=0.334..0.565 rows=50 loops=1)

  • Buffers: shared hit=45 read=4
2. 0.560 0.560 ↑ 1,942.8 50 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.332..0.560 rows=50 loops=1)

  • Index Cond: (deployments.project_id = 278964)
  • Buffers: shared hit=45 read=4