explain.depesz.com

PostgreSQL's explain analyze made readable

Result: f497

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.027 ↓ 0.0 0 1

Limit (cost=0.43..6.17 rows=1 width=152) (actual time=0.027..0.027 rows=0 loops=1)

  • Buffers: shared hit=3
2. 0.025 0.025 ↓ 0.0 0 1

Index Scan using index_services_on_project_id on public.services (cost=0.43..6.17 rows=1 width=152) (actual time=0.025..0.025 rows=0 loops=1)

  • Index Cond: (services.project_id = 1)
  • Filter: ((services.type)::text = 'PrometheusService'::text)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=3