explain.depesz.com

PostgreSQL's explain analyze made readable

Result: y4gs

Settings
# exclusive inclusive rows x rows loops node
1. 0.052 130.252 ↑ 1.0 50 1

Limit (cost=19,107.95..21,018.69 rows=50 width=138) (actual time=112.027..130.252 rows=50 loops=1)

  • Buffers: shared hit=135160
2. 130.200 130.200 ↑ 176.6 550 1

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

  • Filter: (deployments.project_id = 278964)
  • Rows Removed by Filter: 209864
  • Buffers: shared hit=135160