explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7pT1

Settings
# exclusive inclusive rows x rows loops node
1. 0.108 196.445 ↑ 1.0 50 1

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

  • Buffers: shared dirtied=172 hit=145 read=391
2. 196.337 196.337 ↑ 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.029..196.337 rows=550 loops=1)

  • Index Cond: (deployments.project_id = 278964)
  • Buffers: shared dirtied=172 hit=145 read=391