explain.depesz.com

PostgreSQL's explain analyze made readable

Result: maqX

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