explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lCiY

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.011 ↓ 0.0 0 1

Limit (cost=0.43..4.76 rows=1 width=152) (actual time=0.011..0.011 rows=0 loops=1)

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

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

  • Index Cond: (project_id = 1)
  • Filter: ((type)::text = 'PrometheusService'::text)
  • Buffers: shared hit=3
Planning time : 0.423 ms
Execution time : 0.037 ms