explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 126.131 370.827 ↓ 1.0 2,291 1

GroupAggregate (cost=0.42..60,917.14 rows=2,228 width=64) (actual time=0.194..370.827 rows=2,291 loops=1)

  • Group Key: tenant_id, asset_id
  • Execution Time: 371.150 m
2. 244.696 244.696 ↑ 1.0 571,371 1

Index Only Scan using security_policy_risk_pkey on security_policy_risk (cost=0.42..56,603.85 rows=571,392 width=48) (actual time=0.019..244.696 rows=571,371 loops=1)

  • Index Cond: (tenant_id = '7b26e0d9-d493-30c1-ac75-38d68d70538d'::uuid)
  • Heap Fetches: 571371
Planning time : 0.132 ms