explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 99.694 99.694 ↓ 1.0 571,072 1

Seq Scan on security_policy_risk (cost=0.00..15,956.40 rows=570,954 width=16) (actual time=0.014..99.694 rows=571,072 loops=1)

  • Filter: ((all_endpoints IS TRUE) AND (tenant_id = '7b26e0d9-d493-30c1-ac75-38d68d70538d'::uuid))
  • Rows Removed by Filter: 299
Planning time : 0.092 ms
Execution time : 131.846 ms