explain.depesz.com

PostgreSQL's explain analyze made readable

Result: j9vk : Optimization for: plan #JFwK4

Settings

Optimization path:

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

Delete on security_policy_risk (cost=0.00..1.12 rows=2 width=6) (actual time=0.021..0.021 rows=0 loops=1)

2. 0.020 0.020 ↓ 0.0 0 1

Seq Scan on security_policy_risk (cost=0.00..1.12 rows=2 width=6) (actual time=0.020..0.020 rows=0 loops=1)

  • Filter: ((asset_id = ANY ('{7b26e0d9-d493-30c1-ac75-38d68d70538d,92ddb38c-a47b-30e6-ac50-d618fed7b895}'::uuid[])) AND (tenant_id = '7b26e0d9-d493-30c1-ac75-38d68d70538d'::uuid))
  • Rows Removed by Filter: 8
Planning time : 0.526 ms
Execution time : 0.046 ms