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

Limit  (cost=2961.54..2962.54 rows=1 width=107) (actual time=5.109..5.109 rows=1 loops=1)
->  Sort  (cost=2961.54..2962.54 rows=1 width=107) (actual time=5.108..5.108 rows=1 loops=1)
Sort Key: motivo_glosa.mgcodigo
Sort Method: quicksort  Memory: 25kB
->  WindowAgg  (cost=86.50..2959.54 rows=1 width=107) (actual time=5.097..5.098 rows=1 loops=1)
->  Nested Loop  (cost=86.50..2958.54 rows=1 width=99) (actual time=3.334..5.088 rows=1 loops=1)
->  Index Scan using idx_fibomotivoglosa_mgconv_idx on fibomotivoglosa motivo_glosa  (cost=58.00..2925.04 rows=1 width=107) (actual time=3.322..5.074 rows=1 loops=1)
Index Cond: (mgconv = 1179652)
Filter: ((NOT devolucao) AND ((mgcodigo ~~* '%reapresenta%'::text) OR (mgdescricao ~~* '%reapresenta%'::text) OR (complemento ~~* '%reapresenta%'::text)))
Rows Removed by Filter: 956
->  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)
Index Cond: (id = 1179652)
Heap Fetches: 1
Planning time: 7.432 ms
Execution time: 5.172 ms

Per node type stats

node type	count	sum of times	% of query
Index Only Scan	1	0.011 ms	0.2 %
Index Scan	1	5.074 ms	99.3 %
Limit	1	0.000 ms	0.0 %
Nested Loop	1	5.088 ms	99.6 %
Sort	1	5.108 ms	100.0 %
WindowAgg	1	5.098 ms	99.8 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
fiboconvenio	1	0.011 ms	0.2 %
Index Only Scan	1	0.011 ms	100.0 %
fibomotivoglosa	1	5.074 ms	99.3 %
Index Scan	1	5.074 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MIvp

Color mode:

Visible columns:

Per node type stats

Per table stats