explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 10s : dfdf

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.004 2,905.913 ↑ 3.5 2 1

Unique (cost=19,381,823.82..19,381,824.03 rows=7 width=66) (actual time=2,905.910..2,905.913 rows=2 loops=1)

2. 0.038 2,905.909 ↑ 3.5 2 1

Sort (cost=19,381,823.82..19,381,823.84 rows=7 width=66) (actual time=2,905.908..2,905.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 2,905.871 ↑ 3.5 2 1

Nested Loop (cost=0.00..19,381,823.72 rows=7 width=66) (actual time=2,049.246..2,905.871 rows=2 loops=1)

4. 129.663 2,905.849 ↑ 3.5 2 1

Index Scan using disbanco_numpre_numpar_in on disbanco (cost=0.00..19,381,765.06 rows=7 width=4) (actual time=2,049.238..2,905.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. 2,776.186 2,776.186 ↓ 0.0 0 118

Seq Scan on processoforopartilhacusta x (cost=0.00..6,084.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)