explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CrBG : Optimization for: plan #MUAQ

Settings

Optimization path:

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