#	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)

"Hash Join  (cost=1.58..1101.19 rows=14609 width=38) (actual time=0.196..104.033 rows=14473 loops=1)"
"  Hash Cond: (doc_management_request_az.zags_list_azkind_id = zags_list_azkind.zags_list_azkind_id)"
"  ->  Index Scan using doc_management_request_request_id on doc_management_request_az  (cost=0.42..934.11 rows=14609 width=16) (actual time=0.109..40.966 rows=14473 loops=1)"
"        Index Cond: (doc_management_request_id = 550)"
"        Filter: az_is_found"
"  ->  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"
"        ->  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)"
"Planning time: 0.883 ms"
"Execution time: 131.568 ms"

Per node type stats

node type	count	sum of times	% of query
Hash	1	0.034 ms	0.0 %
Hash Join	1	63.004 ms	60.6 %
Index Scan	1	40.966 ms	39.4 %
Seq Scan	1	0.029 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
doc_management_request_az	1	40.966 ms	39.4 %
Index Scan	1	40.966 ms	100.0 %
zags_list_azkind	1	0.029 ms	0.0 %
Seq Scan	1	0.029 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

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

Color mode:

Visible columns:

Optimization path:

Per node type stats

Per table stats