explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MIvp

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 5.109 ↑ 1.0 1 1

Limit (cost=2,961.54..2,962.54 rows=1 width=107) (actual time=5.109..5.109 rows=1 loops=1)

2. 5.108 5.108 ↑ 1.0 1 1

Sort (cost=2,961.54..2,962.54 rows=1 width=107) (actual time=5.108..5.108 rows=1 loops=1)

3. 5.098 5.098 ↑ 1.0 1 1

WindowAgg (cost=86.50..2,959.54 rows=1 width=107) (actual time=5.097..5.098 rows=1 loops=1)

4. 5.088 5.088 ↑ 1.0 1 1

Nested Loop (cost=86.50..2,958.54 rows=1 width=99) (actual time=3.334..5.088 rows=1 loops=1)

5. 5.074 5.074 ↑ 1.0 1 1

Index Scan using idx_fibomotivoglosa_mgconv_idx on fibomotivoglosa motivo_glosa (cost=58.00..2,925.04 rows=1 width=107) (actual time=3.322..5.074 rows=1 loops=1)

6. 0.011 0.011 ↑ 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.010..0.011 rows=1 loops=1)