explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Pn14

Settings
# exclusive inclusive rows x rows loops node
1. 107.179 391.567 ↓ 1.1 2,667 1

GroupAggregate (cost=0.42..74,917.04 rows=2,334 width=48) (actual time=0.039..391.567 rows=2,667 loops=1)

  • Group Key: asset_id
2. 284.388 284.388 ↑ 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=32) (actual time=0.027..284.388 rows=605,045 loops=1)

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