explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XvIj : Optimization for: Optimization for: Optimization for: plan #EYye; plan #ycd5; plan #kIT8

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 99.366 229.928 ↓ 1.0 2,291 1

GroupAggregate (cost=0.42..48,580.61 rows=2,228 width=64) (actual time=0.160..229.928 rows=2,291 loops=1)

  • Group Key: tenant_id, asset_id
2. 130.562 130.562 ↑ 1.0 571,371 1

Index Scan using idx_security_policy_risk_asset_id on security_policy_risk (cost=0.42..44,267.48 rows=571,371 width=48) (actual time=0.038..130.562 rows=571,371 loops=1)

  • Index Cond: (tenant_id = '7b26e0d9-d493-30c1-ac75-38d68d70538d'::uuid)
Planning time : 0.263 ms
Execution time : 230.194 ms