explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Q61R

Settings
# exclusive inclusive rows x rows loops node
1. 287.556 868.690 ↓ 1.2 2,775 1

GroupAggregate (cost=0.42..70,403.62 rows=2,253 width=64) (actual time=0.029..868.690 rows=2,775 loops=1)

  • Group Key: tenant_id, asset_id
2. 581.134 581.134 ↑ 1.0 608,581 1

Index Only Scan using security_policy_risk_pkey on security_policy_risk (cost=0.42..65,810.93 rows=608,604 width=48) (actual time=0.020..581.134 rows=608,581 loops=1)

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