explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hwCy

Settings
# exclusive inclusive rows x rows loops node
1. 77.891 190.524 ↑ 5.3 35,036 1

Hash Join (cost=951.27..25,792.57 rows=186,447 width=73) (actual time=5.753..190.524 rows=35,036 loops=1)

  • Hash Cond: (r.access_id = aa.access_id)
2. 107.058 107.058 ↓ 1.1 575,369 1

Seq Scan on security_policy_risk r (cost=0.00..23,410.40 rows=544,992 width=89) (actual time=0.023..107.058 rows=575,369 loops=1)

  • Filter: (tenant_id = '7b26e0d9-d493-30c1-ac75-38d68d70538d'::uuid)
3. 1.324 5.575 ↑ 1.0 6,984 1

Hash (cost=863.97..863.97 rows=6,984 width=32) (actual time=5.575..5.575 rows=6,984 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 501kB
4. 4.251 4.251 ↑ 1.0 6,984 1

Seq Scan on access_application aa (cost=0.00..863.97 rows=6,984 width=32) (actual time=1.070..4.251 rows=6,984 loops=1)

  • Filter: ((tenant_id = '7b26e0d9-d493-30c1-ac75-38d68d70538d'::uuid) AND (application_id = '9d607a66-3f3e-3b0a-90c3-c8d4426640dc'::uuid))
  • Rows Removed by Filter: 16014
Planning time : 0.596 ms
Execution time : 192.204 ms