explain.depesz.com

PostgreSQL's explain analyze made readable

Result: edyV

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.354 13.889 ↑ 1.0 100 1

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

2. 1.888 13.535 ↑ 143.4 100 1

Nested Loop (cost=1.13..86,704.04 rows=14,341 width=208) (actual time=0.328..13.535 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.803 10.347 ↑ 143.4 100 1

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

4. 0.856 8.744 ↑ 143.4 100 1

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

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

6. 6.969 6.969 ↑ 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.020..0.069 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.252 1.300 ↑ 1.0 7 100

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

9. 0.048 0.048 ↑ 1.0 7 1

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