explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EYye

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 173.064 173.064 ↑ 1.0 537,245 1

Seq Scan on security_policy_risk (cost=0.00..15,031.28 rows=538,946 width=16) (actual time=0.009..173.064 rows=537,245 loops=1)

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