explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tfOM : Optimization for: plan #edyV

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.464 14.719 ↑ 1.0 100 1

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

2. 2.453 14.255 ↑ 143.4 100 1

Nested Loop (cost=1.13..86,704.04 rows=14,341 width=208) (actual time=0.223..14.255 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.940 10.102 ↑ 143.4 100 1

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

4. 1.121 8.062 ↑ 143.4 100 1

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

5. 0.780 0.780 ↑ 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.031..0.780 rows=101 loops=1)

6. 6.161 6.161 ↑ 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.061 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.100 1.100 ↑ 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.011..0.011 rows=1 loops=100)

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

Materialize (cost=0.00..1.10 rows=7 width=40) (actual time=0.003..0.017 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.018..0.037 rows=7 loops=1)