explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ax2

Settings
# exclusive inclusive rows x rows loops node
1. 110.384 390.412 ↓ 1.1 2,667 1

GroupAggregate (cost=0.42..76,437.74 rows=2,334 width=64) (actual time=0.036..390.412 rows=2,667 loops=1)

  • Group Key: tenant_id, asset_id
2. 280.028 280.028 ↑ 1.0 605,045 1

Index Only Scan using security_policy_risk_pkey on security_policy_risk (cost=0.42..71,846.48 rows=608,278 width=48) (actual time=0.024..280.028 rows=605,045 loops=1)

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