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