explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QO4S

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

Limit (cost=1.98..493,639.18 rows=3 width=446) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.98..493,639.18 rows=3 width=446) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.56..493,633.61 rows=3 width=429) (actual rows= loops=)

  • Join Filter: (tblancamento.usucodigo = tbusuario.usucodigo)
4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.56..492,737.96 rows=3 width=417) (actual rows= loops=)

  • Join Filter: (tbitbi.tbiiditbi = tblancamento.tbiiditbi)
5. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.56..492,188.83 rows=3 width=411) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.14..492,181.48 rows=3 width=401) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.99..492,176.92 rows=3 width=387) (actual rows= loops=)

  • Join Filter: (tblancamento.moecodigo = tbmoeda.moecodigo)
8. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.99..492,175.58 rows=3 width=383) (actual rows= loops=)

  • Join Filter: (tblancamento.siscodigo = tbsistema.siscodigo)
9. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.99..492,165.22 rows=3 width=338) (actual rows= loops=)

  • Join Filter: (tblancamento.rctcodigo = tbreceita.rctcodigo)
10. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.99..492,163.64 rows=3 width=324) (actual rows= loops=)

  • Join Filter: (tblancamento.sbrcodigo = tbsubreceita.sbrcodigo)
11. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.99..492,107.89 rows=3 width=298) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Index Scan Backward using pk_tblancamento on tblancamento (cost=0.56..492,105.41 rows=3 width=273) (actual rows= loops=)

  • Index Cond: (lctnumero = 323164)
  • Filter: (unicodigo = 37600)
13. 0.000 0.000 ↓ 0.0

Materialize (cost=0.42..2.44 rows=1 width=33) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Index Scan using pk_tbunico on tbunico (cost=0.42..2.44 rows=1 width=33) (actual rows= loops=)

  • Index Cond: (unicodigo = 37600)
15. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..27.11 rows=674 width=28) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Seq Scan on tbsubreceita (cost=0.00..23.74 rows=674 width=28) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..1.15 rows=10 width=16) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Seq Scan on tbreceita (cost=0.00..1.10 rows=10 width=16) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..4.92 rows=128 width=47) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Seq Scan on tbsistema (cost=0.00..4.28 rows=128 width=47) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..1.09 rows=6 width=6) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Seq Scan on tbmoeda (cost=0.00..1.06 rows=6 width=6) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

Index Scan using idx_lctanonumero on tblancamentowso (cost=0.15..1.51 rows=1 width=24) (actual rows= loops=)

  • Index Cond: ((lctano = tblancamento.lctano) AND (lctnumero = tblancamento.lctnumero) AND (lctnumero = 323164))
24. 0.000 0.000 ↓ 0.0

Index Scan using pk_tblctorelacdsk on tblctorelacdsk (cost=0.42..2.44 rows=1 width=20) (actual rows= loops=)

  • Index Cond: ((lctano = tblancamento.lctano) AND (lctnumero = tblancamento.lctnumero) AND (lctnumero = 323164))
25. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..230.47 rows=7,498 width=14) (actual rows= loops=)

26. 0.000 0.000 ↓ 0.0

Seq Scan on tbitbi (cost=0.00..192.98 rows=7,498 width=14) (actual rows= loops=)

27. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..414.00 rows=11,333 width=12) (actual rows= loops=)

28. 0.000 0.000 ↓ 0.0

Seq Scan on tbusuario (cost=0.00..357.33 rows=11,333 width=12) (actual rows= loops=)

29. 0.000 0.000 ↓ 0.0

Index Scan using pk_tbunico on tbunico pessoausuario (cost=0.42..1.85 rows=1 width=33) (actual rows= loops=)

  • Index Cond: (tbusuario.unicodigo = unicodigo)