# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.000 | 3.424 | ↑ 1.0 | 200 | 1 |
→
Limit (cost=6,612.33..6,712.33 rows=200 width=107) (actual time=3.401..3.424 rows=200 loops=1) |
2. | 3.409 | 3.409 | ↑ 1.8 | 200 | 1 |
→
Sort (cost=6,612.33..6,794.83 rows=365 width=107) (actual time=3.399..3.409 rows=200 loops=1) |
3. | 1.984 | 1.984 | ↓ 2.6 | 949 | 1 |
→
WindowAgg (cost=86.50..3,505.54 rows=365 width=107) (actual time=1.754..1.984 rows=949 loops=1) |
4. | 1.388 | 1.388 | ↓ 2.6 | 949 | 1 |
→
Nested Loop (cost=86.50..3,140.54 rows=365 width=99) (actual time=0.035..1.388 rows=949 loops=1) |
5. | 0.018 | 0.018 | ↑ 1.0 | 1 | 1 |
→
Index Only Scan using fiboconvenio_pkey on fiboconvenio convenio (cost=28.50..33.00 rows=1 width=8) (actual time=0.017..0.018 rows=1 loops=1) |
6. | 1.237 | 1.237 | ↓ 2.6 | 949 | 1 |
→
Index Scan using idx_fibomotivoglosa_mgconv_idx on fibomotivoglosa motivo_glosa (cost=58.00..2,925.04 rows=365 width=107) (actual time=0.016..1.237 rows=949 loops=1) |