explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ttdf

Settings
# exclusive inclusive rows x rows loops node
1. 0.135 12.386 ↑ 1.4 109 1

Sort (cost=2,065.15..2,065.54 rows=157 width=182) (actual time=12.378..12.386 rows=109 loops=1)

  • Sort Key: cartaoreceber.valor, cartaoreceber.dataemissao DESC
  • Sort Method: quicksort Memory: 48kB
2. 0.058 12.251 ↑ 1.4 109 1

GroupAggregate (cost=2,050.78..2,059.42 rows=157 width=182) (actual time=12.181..12.251 rows=109 loops=1)

  • Group Key: cartaoreceber.id, unidadenegocio.codigo, ((((cartaoreceber.numeroparcela)::text || '/'::text) || (cartaoreceber.totalparcela)::text)), modalidadecartao.nome, ((((usuario.login)::text || '-'::text) || (usuario.apelido)::text)), ((((usuarioconferencia.login)::text || '-'::text) || (usuarioconferencia.apelido)::text))
3. 0.094 12.193 ↑ 1.4 109 1

Sort (cost=2,050.78..2,051.18 rows=157 width=182) (actual time=12.178..12.193 rows=109 loops=1)

  • Sort Key: cartaoreceber.id, unidadenegocio.codigo, ((((cartaoreceber.numeroparcela)::text || '/'::text) || (cartaoreceber.totalparcela)::text)), modalidadecartao.nome, ((((usuario.login)::text || '-'::text) || (usuario.apelido)::text)), ((((usuarioconferencia.login)::text || '-'::text) || (usuarioconferencia.apelido)::text))
  • Sort Method: quicksort Memory: 43kB
4. 0.228 12.099 ↑ 1.4 109 1

Nested Loop Left Join (cost=131.05..2,045.06 rows=157 width=182) (actual time=2.052..12.099 rows=109 loops=1)

5. 0.048 11.871 ↓ 5.5 109 1

Hash Left Join (cost=130.90..2,014.96 rows=20 width=136) (actual time=2.039..11.871 rows=109 loops=1)

  • Hash Cond: (cartaoreceber.usuarioconferenciaid = usuarioconferencia.id)
6. 0.072 10.903 ↓ 5.5 109 1

Nested Loop Left Join (cost=66.02..1,949.87 rows=20 width=127) (actual time=1.112..10.903 rows=109 loops=1)

7. 0.086 10.722 ↓ 5.5 109 1

Nested Loop Left Join (cost=65.72..1,787.52 rows=20 width=119) (actual time=1.109..10.722 rows=109 loops=1)

8. 0.124 10.527 ↓ 5.5 109 1

Nested Loop (cost=65.58..1,772.17 rows=20 width=101) (actual time=1.105..10.527 rows=109 loops=1)

9. 0.079 10.294 ↓ 5.5 109 1

Hash Join (cost=65.44..1,752.77 rows=20 width=106) (actual time=1.098..10.294 rows=109 loops=1)

  • Hash Cond: (cartaoreceber.usuarioid = usuario.id)
10. 9.279 9.279 ↓ 5.5 109 1

Index Scan using idx_cartaoreceber_conciliacaomanual on cartaoreceber (cost=0.56..1,687.61 rows=20 width=97) (actual time=0.151..9.279 rows=109 loops=1)

  • Index Cond: ((valor >= 2.92) AND (valor <= 3.92) AND (dataemissao >= '2019-08-05 16:09:55'::timestamp without time zone) AND (dataemissao <= '2019-08-11 16:09:55'::timestamp without time zone))
11. 0.491 0.936 ↓ 1.0 1,520 1

Hash (cost=46.06..46.06 rows=1,506 width=25) (actual time=0.936..0.936 rows=1,520 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 109kB
12. 0.445 0.445 ↓ 1.0 1,520 1

Seq Scan on usuario (cost=0.00..46.06 rows=1,506 width=25) (actual time=0.008..0.445 rows=1,520 loops=1)

13. 0.109 0.109 ↑ 1.0 1 109

Index Scan using pk_unidadenegocio on unidadenegocio (cost=0.14..0.96 rows=1 width=11) (actual time=0.001..0.001 rows=1 loops=109)

  • Index Cond: (id = cartaoreceber.unidadenegocioid)
14. 0.109 0.109 ↑ 1.0 1 109

Index Scan using pk_modalidadecartao on modalidadecartao (cost=0.14..0.76 rows=1 width=26) (actual time=0.001..0.001 rows=1 loops=109)

  • Index Cond: (cartaoreceber.modalidadecartaoid = id)
15. 0.109 0.109 ↓ 0.0 0 109

Index Scan using xidx_ocorrenciacartaoreceber_cartaoreceberid on ocorrenciacartaoreceber (cost=0.29..8.11 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=109)

  • Index Cond: (cartaoreceber.id = cartaoreceberid)
16. 0.477 0.920 ↓ 1.0 1,520 1

Hash (cost=46.06..46.06 rows=1,506 width=25) (actual time=0.920..0.920 rows=1,520 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 109kB
17. 0.443 0.443 ↓ 1.0 1,520 1

Seq Scan on usuario usuarioconferencia (cost=0.00..46.06 rows=1,506 width=25) (actual time=0.005..0.443 rows=1,520 loops=1)

18. 0.000 0.000 ↓ 0.0 0 109

Index Only Scan using uidx_modalidadecartaooperadora_modalidadecartaoid_operadora on modalidadecartaooperadora (cost=0.15..1.23 rows=8 width=8) (actual time=0.000..0.000 rows=0 loops=109)

  • Index Cond: (modalidadecartaoid = modalidadecartao.id)
  • Heap Fetches: 0
Planning time : 2.481 ms
Execution time : 12.540 ms