explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tSf : Optimization for: plan #edyV

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.399 12.257 ↑ 1.0 100 1

Limit (cost=1.13..605.71 rows=100 width=208) (actual time=0.315..12.257 rows=100 loops=1)

2. 1.829 11.858 ↑ 143.4 100 1

Nested Loop (cost=1.13..86,704.04 rows=14,341 width=208) (actual time=0.307..11.858 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.685 8.629 ↑ 143.4 100 1

Nested Loop (cost=1.13..85,358.51 rows=14,341 width=184) (actual time=0.137..8.629 rows=100 loops=1)

4. 0.889 7.144 ↑ 143.4 100 1

Nested Loop (cost=0.71..32,612.06 rows=14,341 width=36) (actual time=0.089..7.144 rows=100 loops=1)

5. 0.801 0.801 ↑ 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.035..0.801 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.019..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. 0.800 0.800 ↑ 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.008..0.008 rows=1 loops=100)

  • Index Cond: (government_list_body_id = zags_az.az_first_gov_list_body_id)
8. 1.309 1.400 ↑ 1.0 7 100

Materialize (cost=0.00..1.10 rows=7 width=40) (actual time=0.003..0.014 rows=7 loops=100)

9. 0.091 0.091 ↑ 1.0 7 1

Seq Scan on zags_list_azkind (cost=0.00..1.07 rows=7 width=40) (actual time=0.075..0.091 rows=7 loops=1)