explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dSef

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Hash Join (cost=61,939.42..216,911.23 rows=739 width=97) (actual rows= loops=)

  • Hash Cond: (a.cd_empresa = a_1.cd_empresa)
2. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=61,732.18..216,324.32 rows=739 width=40) (actual rows= loops=)

  • Hash Cond: ((i.cd_empresa = a.cd_empresa) AND (i.nr_transacao = a.nr_transacao))
3. 0.000 0.000 ↓ 0.0

Seq Scan on tra_transitem i (cost=0.00..136,797.86 rows=2,371,586 width=40) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash (cost=61,729.79..61,729.79 rows=159 width=24) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on tra_transacao a (cost=0.00..61,729.79 rows=159 width=24) (actual rows= loops=)

  • Filter: ((cd_empresa <> ALL ('{1,50}'::bigint[])) AND (tp_situacao = 4) AND ((tp_operacao)::text = 'E'::text) AND ((f_dic_ger_operacao(cd_empresa, nr_transacao, dt_transacao, 'T04'::bpchar))::text = '2'::text))
6. 0.000 0.000 ↓ 0.0

Hash (cost=206.94..206.94 rows=25 width=33) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.70..206.94 rows=25 width=33) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Hash Join (cost=1.41..3.00 rows=25 width=41) (actual rows= loops=)

  • Hash Cond: (a_1.cd_grupoempresa = c.cd_grupoempresa)
9. 0.000 0.000 ↓ 0.0

Seq Scan on ger_empresa a_1 (cost=0.00..1.25 rows=25 width=24) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Hash (cost=1.18..1.18 rows=18 width=25) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Seq Scan on ger_grupoempresa c (cost=0.00..1.18 rows=18 width=25) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Index Only Scan using pes_pessoa_pkey on pes_pessoa b (cost=0.29..8.15 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (cd_pessoa = a_1.cd_pessoa)