explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HBbn : Optimization for: Optimization for: plan #edyV; plan #tSf

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 63.004 104.033 ↑ 1.0 14,473 1

Hash Join (cost=1.58..1,101.19 rows=14,609 width=38) (actual time=0.196..104.033 rows=14,473 loops=1)

  • Hash Cond: (doc_management_request_az.zags_list_azkind_id = zags_list_azkind.zags_list_azkind_id)
2. 40.966 40.966 ↑ 1.0 14,473 1

Index Scan using doc_management_request_request_id on doc_management_request_az (cost=0.42..934.11 rows=14,609 width=16) (actual time=0.109..40.966 rows=14,473 loops=1)

  • Index Cond: (doc_management_request_id = 550)
  • Filter: az_is_found
3. 0.034 0.063 ↑ 1.0 7 1

Hash (cost=1.07..1.07 rows=7 width=38) (actual time=0.063..0.063 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
4. 0.029 0.029 ↑ 1.0 7 1

Seq Scan on zags_list_azkind (cost=0.00..1.07 rows=7 width=38) (actual time=0.011..0.029 rows=7 loops=1)