explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gt7m

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 1.005 ↑ 1.0 1 1

Limit (cost=254.77..254.78 rows=1 width=12) (actual time=1.000..1.005 rows=1 loops=1)

2. 0.013 0.999 ↑ 1.0 1 1

Sort (cost=254.77..254.78 rows=1 width=12) (actual time=0.999..0.999 rows=1 loops=1)

  • Sort Key: tlsos."tlsosDataHora" DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.085 0.986 ↑ 1.0 1 1

Nested Loop (cost=0.84..254.76 rows=1 width=12) (actual time=0.962..0.986 rows=1 loops=1)

  • Join Filter: (tfu."tfuID" = tui_vendedor."tuitfuID")
  • Rows Removed by Join Filter: 264
4. 0.000 0.834 ↑ 1.0 1 1

Nested Loop (cost=0.84..239.80 rows=1 width=16) (actual time=0.812..0.834 rows=1 loops=1)

5. 0.002 0.827 ↑ 1.0 1 1

Nested Loop (cost=0.57..239.49 rows=1 width=12) (actual time=0.807..0.827 rows=1 loops=1)

6. 0.003 0.821 ↑ 1.0 1 1

Nested Loop (cost=0.29..231.18 rows=1 width=12) (actual time=0.802..0.821 rows=1 loops=1)

7. 0.805 0.805 ↑ 1.0 1 1

Seq Scan on "TabOrdemServico" tos (cost=0.00..221.18 rows=1 width=8) (actual time=0.786..0.805 rows=1 loops=1)

  • Filter: (("tostclID" = ANY ('{1544,47}'::integer[])) AND ("tostemID" = 6))
  • Rows Removed by Filter: 4968
8. 0.013 0.013 ↑ 1.0 1 1

Index Scan using idx_tlsos_tosid on "TabLogSituacaoOrdemServico" tlsos (cost=0.29..9.99 rows=1 width=12) (actual time=0.012..0.013 rows=1 loops=1)

  • Index Cond: ("tlsostosID" = tos."tosID")
  • Filter: ("tlsosSituacao" = 3)
  • Rows Removed by Filter: 1
9. 0.004 0.004 ↑ 1.0 1 1

Index Scan using "TabPropostaComercial_tpcID" on "TabPropostaComercial" tpc (cost=0.28..8.30 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=1)

  • Index Cond: ("tpcID" = tos."tostpcID")
10. 0.007 0.007 ↑ 1.0 1 1

Index Scan using "TabFuncionario_tfuID" on "TabFuncionario" tfu (cost=0.27..0.30 rows=1 width=4) (actual time=0.004..0.007 rows=1 loops=1)

  • Index Cond: ("tfuID" = tpc."tpctfuID")
  • Filter: ("tfuAtivo" IS TRUE)
11. 0.067 0.067 ↑ 1.0 265 1

Seq Scan on "TabUsuarioInterno" tui_vendedor (cost=0.00..11.65 rows=265 width=8) (actual time=0.003..0.067 rows=265 loops=1)