#	exclusive	inclusive	rows x	rows	loops	node
1.	0.004	2905.913	↑ 3.5	2	1	→ Unique (cost=19381823.82..19381824.03 rows=7 width=66) (actual time=2905.910..2905.913 rows=2 loops=1)
2.	0.038	2905.909	↑ 3.5	2	1	→ Sort (cost=19381823.82..19381823.84 rows=7 width=66) (actual time=2905.908..2905.909 rows=2 loops=1) Sort Key: disarq.id_usuario, disarq.k15_codbco, disarq.k15_codage, disarq.codret, disarq.arqret, disarq.textoret, disarq.dtretorno, disarq.dtarquivo, disarq.k00_conta, disarq.autent, disar
3.	0.008	2905.871	↑ 3.5	2	1	→ Nested Loop (cost=0.00..19381823.72 rows=7 width=66) (actual time=2049.246..2905.871 rows=2 loops=1)
4.	129.663	2905.849	↑ 3.5	2	1	→ Index Scan using disbanco_numpre_numpar_in on disbanco (cost=0.00..19381765.06 rows=7 width=4) (actual time=2049.238..2905.849 rows=2 loops=1) Index Cond: (k00_numpar = 0) Filter: ((classi IS FALSE) AND (k00_numpre <> 0) AND (subplan))
5.						SubPlan (forIndex Scan)
6.	2776.186	2776.186	↓ 0.0	0	118	→ Seq Scan on processoforopartilhacusta x (cost=0.00..6084.30 rows=35 width=0) (actual time=23.527..23.527 rows=0 loops=118) Filter: (v77_numnov = $0)
7.	0.014	0.014	↑ 1.0	1	2	→ Index Scan using disarq_codr_pk on disarq (cost=0.00..8.37 rows=1 width=66) (actual time=0.006..0.007 rows=1 loops=2) Index Cond: (disarq.codret = disbanco.codret)

                                                                                                  QUERY PLAN                                                                                         
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Unique  (cost=19381823.82..19381824.03 rows=7 width=66) (actual time=2905.910..2905.913 rows=2 loops=1)
   ->  Sort  (cost=19381823.82..19381823.84 rows=7 width=66) (actual time=2905.908..2905.909 rows=2 loops=1)
         Sort Key: disarq.id_usuario, disarq.k15_codbco, disarq.k15_codage, disarq.codret, disarq.arqret, disarq.textoret, disarq.dtretorno, disarq.dtarquivo, disarq.k00_conta, disarq.autent, disar
         ->  Nested Loop  (cost=0.00..19381823.72 rows=7 width=66) (actual time=2049.246..2905.871 rows=2 loops=1)
               ->  Index Scan using disbanco_numpre_numpar_in on disbanco  (cost=0.00..19381765.06 rows=7 width=4) (actual time=2049.238..2905.849 rows=2 loops=1)
                     Index Cond: (k00_numpar = 0)
                     Filter: ((classi IS FALSE) AND (k00_numpre <> 0) AND (subplan))
                     SubPlan
                       ->  Seq Scan on processoforopartilhacusta x  (cost=0.00..6084.30 rows=35 width=0) (actual time=23.527..23.527 rows=0 loops=118)
                             Filter: (v77_numnov = $0)
               ->  Index Scan using disarq_codr_pk on disarq  (cost=0.00..8.37 rows=1 width=66) (actual time=0.006..0.007 rows=1 loops=2)
                     Index Cond: (disarq.codret = disbanco.codret)
 Total runtime: 2905.985 ms

Per node type stats

node type	count	sum of times	% of query
Index Scan	2	129.677 ms	4.5 %
Nested Loop	1	0.008 ms	0.0 %
Seq Scan	1	2776.186 ms	95.5 %
Sort	1	0.038 ms	0.0 %
Unique	1	0.004 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
disarq	1	0.014 ms	0.0 %
Index Scan	1	0.014 ms	100.0 %
disbanco	1	129.663 ms	4.5 %
Index Scan	1	129.663 ms	100.0 %
processoforopartilhacusta	1	2776.186 ms	95.5 %
Seq Scan	1	2776.186 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 10s : dfdf

Colorize:

Columns visibility:

Per node type stats

Per table stats