#	exclusive	inclusive	rows x	rows	loops	node
1.	0.447	14.062	↑ 1.0	100	1	→ Limit (cost=1.13..605.71 rows=100 width=208) (actual time=0.261..14.062 rows=100 loops=1)
2.	2.544	13.615	↑ 143.4	100	1	→ Nested Loop (cost=1.13..86,704.04 rows=14,341 width=208) (actual time=0.253..13.615 rows=100 loops=1) Join Filter: (doc_management_request_az.zags_list_azkind_id = zags_list_azkind.zags_list_azkind_id) Rows Removed by Join Filter: 574
3.	0.920	9.271	↑ 143.4	100	1	→ Nested Loop (cost=1.13..85,358.51 rows=14,341 width=184) (actual time=0.138..9.271 rows=100 loops=1)
4.	1.139	7.351	↑ 143.4	100	1	→ Nested Loop (cost=0.71..32,612.06 rows=14,341 width=36) (actual time=0.107..7.351 rows=100 loops=1)
5.	0.758	0.758	↑ 169.6	101	1	→ Index Scan Backward using zags_az_az_date_idx on zags_az (cost=0.29..11,876.79 rows=17,129 width=28) (actual time=0.027..0.758 rows=101 loops=1)
6.	5.454	5.454	↑ 1.0	1	101	→ Index Scan using pgpro__doc_management_request_az___zags_az_id on doc_management_request_az (cost=0.42..1.20 rows=1 width=24) (actual time=0.018..0.054 rows=1 loops=101) Index Cond: (zags_az_id = zags_az.zags_az_id) Filter: (az_is_found AND (doc_management_request_id = 550)) Rows Removed by Filter: 9
7.	1.000	1.000	↑ 1.0	1	100	→ Index Scan using government_list_body_pkey on government_list_body (cost=0.42..3.68 rows=1 width=164) (actual time=0.010..0.010 rows=1 loops=100) Index Cond: (government_list_body_id = zags_az.az_first_gov_list_body_id)
8.	1.763	1.800	↑ 1.0	7	100	→ Materialize (cost=0.00..1.10 rows=7 width=40) (actual time=0.004..0.018 rows=7 loops=100)
9.	0.037	0.037	↑ 1.0	7	1	→ Seq Scan on zags_list_azkind (cost=0.00..1.07 rows=7 width=40) (actual time=0.019..0.037 rows=7 loops=1)

"Limit  (cost=1.13..605.71 rows=100 width=208) (actual time=0.261..14.062 rows=100 loops=1)"
"  ->  Nested Loop  (cost=1.13..86704.04 rows=14341 width=208) (actual time=0.253..13.615 rows=100 loops=1)"
"        Join Filter: (doc_management_request_az.zags_list_azkind_id = zags_list_azkind.zags_list_azkind_id)"
"        Rows Removed by Join Filter: 574"
"        ->  Nested Loop  (cost=1.13..85358.51 rows=14341 width=184) (actual time=0.138..9.271 rows=100 loops=1)"
"              ->  Nested Loop  (cost=0.71..32612.06 rows=14341 width=36) (actual time=0.107..7.351 rows=100 loops=1)"
"                    ->  Index Scan Backward using zags_az_az_date_idx on zags_az  (cost=0.29..11876.79 rows=17129 width=28) (actual time=0.027..0.758 rows=101 loops=1)"
"                    ->  Index Scan using pgpro__doc_management_request_az___zags_az_id on doc_management_request_az  (cost=0.42..1.20 rows=1 width=24) (actual time=0.018..0.054 rows=1 loops=101)"
"                          Index Cond: (zags_az_id = zags_az.zags_az_id)"
"                          Filter: (az_is_found AND (doc_management_request_id = 550))"
"                          Rows Removed by Filter: 9"
"              ->  Index Scan using government_list_body_pkey on government_list_body  (cost=0.42..3.68 rows=1 width=164) (actual time=0.010..0.010 rows=1 loops=100)"
"                    Index Cond: (government_list_body_id = zags_az.az_first_gov_list_body_id)"
"        ->  Materialize  (cost=0.00..1.10 rows=7 width=40) (actual time=0.004..0.018 rows=7 loops=100)"
"              ->  Seq Scan on zags_list_azkind  (cost=0.00..1.07 rows=7 width=40) (actual time=0.019..0.037 rows=7 loops=1)"
"Planning time: 3.445 ms"
"Execution time: 14.402 ms"

Per node type stats

node type	count	sum of times	% of query
Index Scan	2	6.454 ms	45.9 %
Index Scan Backward	1	0.758 ms	5.4 %
Limit	1	0.447 ms	3.2 %
Materialize	1	1.763 ms	12.5 %
Nested Loop	3	4.603 ms	32.7 %
Seq Scan	1	0.037 ms	0.3 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
doc_management_request_az	1	5.454 ms	38.8 %
Index Scan	1	5.454 ms	100.0 %
government_list_body	1	1.000 ms	7.1 %
Index Scan	1	1.000 ms	100.0 %
zags_az	1	0.758 ms	5.4 %
Index Scan Backward	1	0.758 ms	100.0 %
zags_list_azkind	1	0.037 ms	0.3 %
Seq Scan	1	0.037 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CrBG : Optimization for: plan #MUAQ

Color mode:

Visible columns:

Optimization path:

Per node type stats

Per table stats