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

Limit  (cost=6612.33..6712.33 rows=200 width=107) (actual time=3.401..3.424 rows=200 loops=1)
->  Sort  (cost=6612.33..6794.83 rows=365 width=107) (actual time=3.399..3.409 rows=200 loops=1)
Sort Key: motivo_glosa.mgcodigo
Sort Method: top-N heapsort  Memory: 91kB
->  WindowAgg  (cost=86.50..3505.54 rows=365 width=107) (actual time=1.754..1.984 rows=949 loops=1)
->  Nested Loop  (cost=86.50..3140.54 rows=365 width=99) (actual time=0.035..1.388 rows=949 loops=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)
Index Cond: (id = 1179652)
Heap Fetches: 1
->  Index Scan using idx_fibomotivoglosa_mgconv_idx on fibomotivoglosa motivo_glosa  (cost=58.00..2925.04 rows=365 width=107) (actual time=0.016..1.237 rows=949 loops=1)
Index Cond: (mgconv = 1179652)
Filter: ((NOT devolucao) AND ((mgcodigo ~~* '%%'::text) OR (mgdescricao ~~* '%%'::text) OR (complemento ~~* '%%'::text)))
Rows Removed by Filter: 8
Planning time: 3.363 ms
Execution time: 3.490 ms

Per node type stats

node type	count	sum of times	% of query
Index Only Scan	1	0.018 ms	0.5 %
Index Scan	1	1.237 ms	36.1 %
Limit	1	0.000 ms	0.0 %
Nested Loop	1	1.388 ms	40.5 %
Sort	1	3.409 ms	99.6 %
WindowAgg	1	1.984 ms	57.9 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
fiboconvenio	1	0.018 ms	0.5 %
Index Only Scan	1	0.018 ms	100.0 %
fibomotivoglosa	1	1.237 ms	36.1 %
Index Scan	1	1.237 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: maqX

Color mode:

Visible columns:

Per node type stats

Per table stats