explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fXdq

Settings
# exclusive inclusive rows x rows loops node
1. 0.344 46.053 ↑ 1.0 100 1

Limit (cost=1.13..605.63 rows=100 width=208) (actual time=0.515..46.053 rows=100 loops=1)

2. 1.865 45.709 ↑ 143.5 100 1

Nested Loop (cost=1.13..86,722.96 rows=14,346 width=208) (actual time=0.505..45.709 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.679 42.544 ↑ 143.5 100 1

Nested Loop (cost=1.13..85,376.90 rows=14,346 width=184) (actual time=0.402..42.544 rows=100 loops=1)

4. 0.971 40.665 ↑ 143.5 100 1

Nested Loop (cost=0.71..32,612.06 rows=14,346 width=36) (actual time=0.322..40.665 rows=100 loops=1)

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

6. 34.239 34.239 ↑ 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.086..0.339 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.200 1.200 ↑ 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.012..0.012 rows=1 loops=100)

  • Index Cond: (government_list_body_id = zags_az.az_first_gov_list_body_id)
8. 1.264 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.036 0.036 ↑ 1.0 7 1

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