explain.depesz.com

PostgreSQL's explain analyze made readable

Result: y5qa

Settings
# exclusive inclusive rows x rows loops node
1. 0.019 20.334 ↑ 1.0 50 1

Limit (cost=0.56..1,911.30 rows=50 width=138) (actual time=2.839..20.334 rows=50 loops=1)

  • Buffers: shared dirtied=177 hit=3523 read=759
2. 20.315 20.315 ↑ 1,942.8 50 1

Index Scan using deployments_updated_ad on public.deployments (cost=0.56..3,712,144.96 rows=97,139 width=138) (actual time=2.837..20.315 rows=50 loops=1)

  • Filter: (deployments.project_id = 278964)
  • Rows Removed by Filter: 6985
  • Buffers: shared dirtied=177 hit=3523 read=759