explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JDQi

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 300.325 949.323 ↓ 1.1 2,047 1

GroupAggregate (cost=0.42..55,935.36 rows=1,782 width=48) (actual time=0.430..949.323 rows=2,047 loops=1)

  • Group Key: asset_id
2. 648.998 648.998 ↑ 1.0 537,544 1

Index Only Scan using security_policy_risk_pkey on security_policy_risk (cost=0.42..53,218.17 rows=538,982 width=32) (actual time=0.078..648.998 rows=537,544 loops=1)

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