explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Kls5 : Optimization for: plan #SKHg

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.827 1.069 ↑ 1.0 2,763 1

Bitmap Heap Scan on access_application (cost=316.73..590.18 rows=2,763 width=16) (actual time=0.271..1.069 rows=2,763 loops=1)

  • Recheck Cond: ((tenant_id = '7b26e0d9-d493-30c1-ac75-38d68d70538d'::uuid) AND (application_id = '8a8bb7cd-343a-32ad-99b7-d762030857a2'::uuid))
  • Heap Blocks: exact=148
2. 0.242 0.242 ↑ 1.0 2,763 1

Bitmap Index Scan on idx_access_application_application (cost=0.00..316.04 rows=2,763 width=0) (actual time=0.242..0.242 rows=2,763 loops=1)

  • Index Cond: ((tenant_id = '7b26e0d9-d493-30c1-ac75-38d68d70538d'::uuid) AND (application_id = '8a8bb7cd-343a-32ad-99b7-d762030857a2'::uuid))
Planning time : 0.093 ms
Execution time : 1.247 ms