explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 69xW : local

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 34.601 ↓ 0.0 0 1

Nested Loop (cost=1.00..102,730.02 rows=1 width=434) (actual time=34.601..34.601 rows=0 loops=1)

  • Output: transfere.m80_codigo, transfere.m80_login, transfere.m80_data, transfere.m80_obs, transfere.m80_codtipo, transfere.m80_coddepto, transfere.m80_hora, db_usuarios.id_usuario, db_usuarios.nome, db_usuarios.login, db_usuarios.senha, db_usuarios.usuarioativo, db_usuarios.email, db_usuarios.usuext, db_usuarios.administrador, db_usuarios.datatoken, db_usuarios.dataexpira, matestoquetransf.m83_matestoqueini, matestoquetransf.m83_coddepto, b.coddepto, b.descrdepto, b.nomeresponsavel, b.emailresponsavel, b.limite, b.fonedepto, b.emaildepto, b.faxdepto, b.ramaldepto, b.instit, b.id_usuarioresp, matestoquetipo.m81_codtipo, matestoquetipo.m81_descr, matestoquetipo.m81_entrada, matestoquetipo.m81_tipo, a.coddepto, a.descrdepto, a.nomeresponsavel, a.emailresponsavel, a.limite, a.fonedepto, a.emaildepto, a.faxdepto, a.ramaldepto, a.instit, a.id_usuarioresp, matestoqueinil.m86_codigo, matestoqueinil.m86_matestoqueini, recebe.m80_codigo, recebe.m80_login, recebe.m80_data, recebe.m80_obs, recebe.m80_codtipo, recebe.m80_coddepto, recebe.m80_hora
  • Join Filter: (matestoquetransf.m83_coddepto = a.coddepto)
  • Buffers: shared hit=3 read=3
2. 0.001 34.600 ↓ 0.0 0 1

Nested Loop (cost=1.00..102,707.63 rows=1 width=351) (actual time=34.600..34.600 rows=0 loops=1)

  • Output: transfere.m80_codigo, transfere.m80_login, transfere.m80_data, transfere.m80_obs, transfere.m80_codtipo, transfere.m80_coddepto, transfere.m80_hora, db_usuarios.id_usuario, db_usuarios.nome, db_usuarios.login, db_usuarios.senha, db_usuarios.usuarioativo, db_usuarios.email, db_usuarios.usuext, db_usuarios.administrador, db_usuarios.datatoken, db_usuarios.dataexpira, matestoquetransf.m83_matestoqueini, matestoquetransf.m83_coddepto, b.coddepto, b.descrdepto, b.nomeresponsavel, b.emailresponsavel, b.limite, b.fonedepto, b.emaildepto, b.faxdepto, b.ramaldepto, b.instit, b.id_usuarioresp, matestoquetipo.m81_codtipo, matestoquetipo.m81_descr, matestoquetipo.m81_entrada, matestoquetipo.m81_tipo, matestoqueinil.m86_codigo, matestoqueinil.m86_matestoqueini, recebe.m80_codigo, recebe.m80_login, recebe.m80_data, recebe.m80_obs, recebe.m80_codtipo, recebe.m80_coddepto, recebe.m80_hora
  • Join Filter: (transfere.m80_codtipo = matestoquetipo.m81_codtipo)
  • Buffers: shared hit=3 read=3
3. 0.000 34.599 ↓ 0.0 0 1

Nested Loop (cost=1.00..102,706.04 rows=1 width=318) (actual time=34.599..34.599 rows=0 loops=1)

  • Output: transfere.m80_codigo, transfere.m80_login, transfere.m80_data, transfere.m80_obs, transfere.m80_codtipo, transfere.m80_coddepto, transfere.m80_hora, db_usuarios.id_usuario, db_usuarios.nome, db_usuarios.login, db_usuarios.senha, db_usuarios.usuarioativo, db_usuarios.email, db_usuarios.usuext, db_usuarios.administrador, db_usuarios.datatoken, db_usuarios.dataexpira, matestoquetransf.m83_matestoqueini, matestoquetransf.m83_coddepto, b.coddepto, b.descrdepto, b.nomeresponsavel, b.emailresponsavel, b.limite, b.fonedepto, b.emaildepto, b.faxdepto, b.ramaldepto, b.instit, b.id_usuarioresp, matestoqueinil.m86_codigo, matestoqueinil.m86_matestoqueini, recebe.m80_codigo, recebe.m80_login, recebe.m80_data, recebe.m80_obs, recebe.m80_codtipo, recebe.m80_coddepto, recebe.m80_hora
  • Join Filter: (transfere.m80_coddepto = b.coddepto)
  • Buffers: shared hit=3 read=3
4. 0.000 34.599 ↓ 0.0 0 1

Nested Loop (cost=1.00..102,683.66 rows=1 width=235) (actual time=34.599..34.599 rows=0 loops=1)

  • Output: transfere.m80_codigo, transfere.m80_login, transfere.m80_data, transfere.m80_obs, transfere.m80_codtipo, transfere.m80_coddepto, transfere.m80_hora, db_usuarios.id_usuario, db_usuarios.nome, db_usuarios.login, db_usuarios.senha, db_usuarios.usuarioativo, db_usuarios.email, db_usuarios.usuext, db_usuarios.administrador, db_usuarios.datatoken, db_usuarios.dataexpira, matestoquetransf.m83_matestoqueini, matestoquetransf.m83_coddepto, matestoqueinil.m86_codigo, matestoqueinil.m86_matestoqueini, recebe.m80_codigo, recebe.m80_login, recebe.m80_data, recebe.m80_obs, recebe.m80_codtipo, recebe.m80_coddepto, recebe.m80_hora
  • Buffers: shared hit=3 read=3
5. 0.000 34.599 ↓ 0.0 0 1

Nested Loop (cost=0.72..102,675.35 rows=1 width=223) (actual time=34.599..34.599 rows=0 loops=1)

  • Output: transfere.m80_codigo, transfere.m80_login, transfere.m80_data, transfere.m80_obs, transfere.m80_codtipo, transfere.m80_coddepto, transfere.m80_hora, db_usuarios.id_usuario, db_usuarios.nome, db_usuarios.login, db_usuarios.senha, db_usuarios.usuarioativo, db_usuarios.email, db_usuarios.usuext, db_usuarios.administrador, db_usuarios.datatoken, db_usuarios.dataexpira, matestoqueinil.m86_codigo, matestoqueinil.m86_matestoqueini, recebe.m80_codigo, recebe.m80_login, recebe.m80_data, recebe.m80_obs, recebe.m80_codtipo, recebe.m80_coddepto, recebe.m80_hora
  • Join Filter: (transfere.m80_login = db_usuarios.id_usuario)
  • Buffers: shared hit=3 read=3
6. 0.000 34.599 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.72..102,172.87 rows=1 width=112) (actual time=34.599..34.599 rows=0 loops=1)

  • Output: transfere.m80_codigo, transfere.m80_login, transfere.m80_data, transfere.m80_obs, transfere.m80_codtipo, transfere.m80_coddepto, transfere.m80_hora, matestoqueinil.m86_codigo, matestoqueinil.m86_matestoqueini, recebe.m80_codigo, recebe.m80_login, recebe.m80_data, recebe.m80_obs, recebe.m80_codtipo, recebe.m80_coddepto, recebe.m80_hora
  • Join Filter: (matestoqueinil.m86_matestoqueini = transfere.m80_codigo)
  • Buffers: shared hit=3 read=3
7. 0.002 34.599 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.72..16.77 rows=1 width=64) (actual time=34.599..34.599 rows=0 loops=1)

  • Output: transfere.m80_codigo, transfere.m80_login, transfere.m80_data, transfere.m80_obs, transfere.m80_codtipo, transfere.m80_coddepto, transfere.m80_hora, matestoqueinil.m86_codigo, matestoqueinil.m86_matestoqueini
  • Join Filter: (matestoqueinil.m86_matestoqueini = transfere.m80_codigo)
  • Buffers: shared hit=3 read=3
8. 34.597 34.597 ↓ 0.0 0 1

Index Scan using matestoqueini_codi_pk on material.matestoqueini transfere (cost=0.43..8.45 rows=1 width=48) (actual time=34.597..34.597 rows=0 loops=1)

  • Output: transfere.m80_codigo, transfere.m80_login, transfere.m80_data, transfere.m80_obs, transfere.m80_codtipo, transfere.m80_coddepto, transfere.m80_hora
  • Index Cond: (transfere.m80_codigo = 3176334)
  • Buffers: shared hit=3 read=3
9. 0.000 0.000 ↓ 0.0 0

Index Scan using matestoqueinil_matestoqueini_in on material.matestoqueinil (cost=0.29..8.31 rows=1 width=16) (never executed)

  • Output: matestoqueinil.m86_codigo, matestoqueinil.m86_matestoqueini
  • Index Cond: (matestoqueinil.m86_matestoqueini = 3176334)
10. 0.000 0.000 ↓ 0.0 0

Seq Scan on material.matestoqueini recebe (cost=0.00..64,239.38 rows=3,033,338 width=48) (never executed)

  • Output: recebe.m80_codigo, recebe.m80_login, recebe.m80_data, recebe.m80_obs, recebe.m80_codtipo, recebe.m80_coddepto, recebe.m80_hora
11. 0.000 0.000 ↓ 0.0 0

Seq Scan on configuracoes.db_usuarios (cost=0.00..397.21 rows=8,421 width=111) (never executed)

  • Output: db_usuarios.id_usuario, db_usuarios.nome, db_usuarios.login, db_usuarios.senha, db_usuarios.usuarioativo, db_usuarios.email, db_usuarios.usuext, db_usuarios.administrador, db_usuarios.datatoken, db_usuarios.dataexpira
12. 0.000 0.000 ↓ 0.0 0

Index Scan using matestoquetransf_mate_pk on material.matestoquetransf (cost=0.29..8.30 rows=1 width=12) (never executed)

  • Output: matestoquetransf.m83_matestoqueini, matestoquetransf.m83_coddepto
  • Index Cond: (matestoquetransf.m83_matestoqueini = 3176334)
13. 0.000 0.000 ↓ 0.0 0

Seq Scan on configuracoes.db_depart b (cost=0.00..14.95 rows=595 width=83) (never executed)

  • Output: b.coddepto, b.descrdepto, b.nomeresponsavel, b.emailresponsavel, b.limite, b.fonedepto, b.emaildepto, b.faxdepto, b.ramaldepto, b.instit, b.id_usuarioresp
14. 0.000 0.000 ↓ 0.0 0

Seq Scan on material.matestoquetipo (cost=0.00..1.26 rows=26 width=33) (never executed)

  • Output: matestoquetipo.m81_codtipo, matestoquetipo.m81_descr, matestoquetipo.m81_entrada, matestoquetipo.m81_tipo
15. 0.000 0.000 ↓ 0.0 0

Seq Scan on configuracoes.db_depart a (cost=0.00..14.95 rows=595 width=83) (never executed)

  • Output: a.coddepto, a.descrdepto, a.nomeresponsavel, a.emailresponsavel, a.limite, a.fonedepto, a.emaildepto, a.faxdepto, a.ramaldepto, a.instit, a.id_usuarioresp
Planning time : 975.583 ms
Execution time : 34.972 ms