explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yQsY

Settings
# exclusive inclusive rows x rows loops node
1. 0.423 147.610 ↑ 1.0 5,000 1

Limit (cost=951.27..1,617.45 rows=5,000 width=73) (actual time=4.364..147.610 rows=5,000 loops=1)

2. 67.035 147.187 ↑ 37.3 5,000 1

Hash Join (cost=951.27..25,792.57 rows=186,447 width=73) (actual time=4.364..147.187 rows=5,000 loops=1)

  • Hash Cond: (r.access_id = aa.access_id)
3. 75.928 75.928 ↑ 1.0 544,498 1

Seq Scan on security_policy_risk r (cost=0.00..23,410.40 rows=544,992 width=89) (actual time=0.010..75.928 rows=544,498 loops=1)

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

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

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

Seq Scan on access_application aa (cost=0.00..863.97 rows=6,984 width=32) (actual time=0.411..3.182 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.414 ms
Execution time : 147.888 ms