explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mLVq

Settings
# exclusive inclusive rows x rows loops node
1. 0.494 16.823 ↑ 1.0 100 1

Limit (cost=1.13..1,368.91 rows=100 width=84) (actual time=0.337..16.823 rows=100 loops=1)

2. 2.871 16.329 ↑ 118.1 100 1

Nested Loop (cost=1.13..161,508.91 rows=11,808 width=84) (actual time=0.276..16.329 rows=100 loops=1)

3. 0.949 4.958 ↑ 138.1 100 1

Nested Loop Semi Join (cost=0.71..32,285.84 rows=13,814 width=44) (actual time=0.112..4.958 rows=100 loops=1)

4. 1.383 1.383 ↑ 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=36) (actual time=0.045..1.383 rows=101 loops=1)

5. 2.626 2.626 ↑ 1.0 1 101

Index Scan using pgpro__doc_management_request_az___zags_az_id on doc_management_request_az doc_management_request_az_1 (cost=0.42..1.20 rows=1 width=8) (actual time=0.026..0.026 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: 0
6. 6.100 6.100 ↑ 1.0 1 100

Index Scan using pgpro__doc_management_request_az___zags_az_id on doc_management_request_az (cost=0.42..1.20 rows=1 width=16) (actual time=0.011..0.061 rows=1 loops=100)

  • Index Cond: (zags_az_id = zags_az.zags_az_id)
  • Filter: (doc_management_request_id = 550)
  • Rows Removed by Filter: 9
7.          

SubPlan (forNested Loop)

8. 0.900 0.900 ↑ 1.0 1 100

Seq Scan on zags_list_azkind (cost=0.00..1.09 rows=1 width=30) (actual time=0.006..0.009 rows=1 loops=100)

  • Filter: (zags_list_azkind_id = zags_az.zags_list_azkind_id)
  • Rows Removed by Filter: 6
9. 1.500 1.500 ↑ 1.0 1 100

Index Scan using government_list_body_pkey on government_list_body (cost=0.42..8.44 rows=1 width=156) (actual time=0.012..0.015 rows=1 loops=100)

  • Index Cond: (government_list_body_id = zags_az.az_first_gov_list_body_id)