explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kMX : Optimization for: Optimization for: plan #JDQi; plan #Gypj

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.206 0.206 ↑ 1.5 299 1

Index Scan using idx_security_policy_risk_all_endpoints on security_policy_risk (cost=0.42..775.81 rows=438 width=56) (actual time=0.029..0.206 rows=299 loops=1)

  • Index Cond: ((tenant_id = '7b26e0d9-d493-30c1-ac75-38d68d70538d'::uuid) AND (all_endpoints = false))
  • Filter: (all_endpoints IS FALSE)
Planning time : 0.158 ms
Execution time : 0.268 ms