explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TvEE

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

Nested Loop Semi Join (cost=13.55..177.42 rows=1 width=652) (actual time=8.860..8.860 rows=0 loops=1)

2. 0.000 8.859 ↓ 0.0 0 1

Nested Loop (cost=9.70..95.44 rows=1 width=668) (actual time=8.859..8.859 rows=0 loops=1)

3. 0.001 8.859 ↓ 0.0 0 1

Nested Loop (cost=9.42..94.05 rows=1 width=672) (actual time=8.859..8.859 rows=0 loops=1)

4. 0.000 8.858 ↓ 0.0 0 1

Nested Loop (cost=9.00..92.72 rows=1 width=668) (actual time=8.858..8.858 rows=0 loops=1)

5. 0.001 8.858 ↓ 0.0 0 1

Nested Loop (cost=8.58..91.17 rows=1 width=672) (actual time=8.858..8.858 rows=0 loops=1)

6. 0.000 8.857 ↓ 0.0 0 1

Nested Loop Semi Join (cost=8.15..89.62 rows=1 width=676) (actual time=8.857..8.857 rows=0 loops=1)

  • Join Filter: ((proc.id_processo_trf)::integer = (proctrf.id_processo_trf)::integer)
7. 0.001 8.857 ↓ 0.0 0 1

Nested Loop (cost=4.30..7.64 rows=1 width=668) (actual time=8.857..8.857 rows=0 loops=1)

8. 0.004 8.856 ↓ 0.0 0 1

Bitmap Heap Scan on tb_processo_trf proc (cost=3.88..4.99 rows=1 width=16) (actual time=8.856..8.856 rows=0 loops=1)

  • Recheck Cond: (((id_localizacao_inicial)::integer = 1) AND ((id_estrutura_inicial)::integer = 2))
  • Filter: (in_segredo_justica OR (NOT in_segredo_justica))
9. 0.002 8.852 ↓ 0.0 0 1

BitmapAnd (cost=3.88..3.88 rows=1 width=0) (actual time=8.852..8.852 rows=0 loops=1)

10. 8.850 8.850 ↓ 0.0 0 1

Bitmap Index Scan on idx_tb_processo_trf5 (cost=0.00..1.77 rows=33 width=0) (actual time=8.850..8.850 rows=0 loops=1)

  • Index Cond: ((id_localizacao_inicial)::integer = 1)
11. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_tb_processo_trf6 (cost=0.00..1.86 rows=44 width=0) (never executed)

  • Index Cond: ((id_estrutura_inicial)::integer = 2)
12. 0.000 0.000 ↓ 0.0 0

Index Scan using tb_cabecalho_processo_pkey on tb_cabecalho_processo o (cost=0.42..2.65 rows=1 width=652) (never executed)

  • Index Cond: ((id_processo_trf)::integer = (proc.id_processo_trf)::integer)
  • Filter: (cd_processo_status = 'E'::bpchar)
13. 0.000 0.000 ↓ 0.0 0

Nested Loop Semi Join (cost=3.85..81.97 rows=1 width=8) (never executed)

14. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=2.14..8.23 rows=1 width=24) (never executed)

15. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.71..6.91 rows=1 width=20) (never executed)

16. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.28..5.58 rows=1 width=16) (never executed)

17. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.85..4.25 rows=1 width=12) (never executed)

18. 0.000 0.000 ↓ 0.0 0

Index Only Scan using tb_processo_trf_fk on tb_processo_trf proctrf (cost=0.42..1.32 rows=1 width=4) (never executed)

  • Index Cond: (id_processo_trf = (o.id_processo_trf)::integer)
  • Heap Fetches: 0
19. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_tb_processo_parte_proc on tb_processo_parte pp1 (cost=0.43..2.86 rows=7 width=8) (never executed)

  • Index Cond: ((id_processo_trf)::integer = (proctrf.id_processo_trf)::integer)
20. 0.000 0.000 ↓ 0.0 0

Index Only Scan using tb_usuario_pkey on tb_usuario usuario (cost=0.43..1.33 rows=1 width=4) (never executed)

  • Index Cond: (id_usuario = (pp1.id_pessoa)::integer)
  • Heap Fetches: 0
21. 0.000 0.000 ↓ 0.0 0

Index Only Scan using tb_usuario_pkey on tb_usuario_login login (cost=0.43..1.33 rows=1 width=4) (never executed)

  • Index Cond: (id_usuario = (pp1.id_pessoa)::integer)
  • Heap Fetches: 0
22. 0.000 0.000 ↓ 0.0 0

Index Only Scan using tb_pessoa_pkey on tb_pessoa pessoa (cost=0.43..1.33 rows=1 width=4) (never executed)

  • Index Cond: (id_pessoa = (pp1.id_pessoa)::integer)
  • Heap Fetches: 0
23. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.71..73.73 rows=1 width=12) (never executed)

24. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.28..70.53 rows=1 width=8) (never executed)

25. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.86..69.21 rows=1 width=12) (never executed)

26. 0.000 0.000 ↓ 0.0 0

Index Only Scan using tb_pessoa_pkey on tb_pessoa pe (cost=0.43..1.33 rows=1 width=4) (never executed)

  • Index Cond: (id_pessoa = (pessoa.id_pessoa)::integer)
  • Heap Fetches: 0
27. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_pessoa on tb_processo_parte pp (cost=0.43..67.01 rows=87 width=8) (never executed)

  • Index Cond: ((id_pessoa)::integer = (pe.id_pessoa)::integer)
28. 0.000 0.000 ↓ 0.0 0

Index Only Scan using tb_processo_trf_fk on tb_processo_trf o_1 (cost=0.42..1.32 rows=1 width=4) (never executed)

  • Index Cond: (id_processo_trf = (pp.id_processo_trf)::integer)
  • Heap Fetches: 0
29. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_tb_pessoa_doc_identificacao3 on tb_pess_doc_identificacao di (cost=0.43..3.19 rows=1 width=4) (never executed)

  • Index Cond: ((id_pessoa)::integer = (pe.id_pessoa)::integer)
  • Filter: ((nr_documento_identificacao)::text = '5'::text)
30. 0.000 0.000 ↓ 0.0 0

Index Only Scan using tb_localizacao_pkey on tb_localizacao loc (cost=0.42..1.54 rows=1 width=4) (never executed)

  • Index Cond: (id_localizacao = 1)
  • Heap Fetches: 0
31. 0.000 0.000 ↓ 0.0 0

Index Only Scan using tb_localizacao_pkey on tb_localizacao locestruturainicial (cost=0.42..1.54 rows=1 width=4) (never executed)

  • Index Cond: (id_localizacao = 2)
  • Heap Fetches: 0
32. 0.000 0.000 ↓ 0.0 0

Index Only Scan using sys_c005762 on tb_processo p (cost=0.42..1.32 rows=1 width=4) (never executed)

  • Index Cond: (id_processo = (proctrf.id_processo_trf)::integer)
  • Heap Fetches: 0
33. 0.000 0.000 ↓ 0.0 0

Index Only Scan using tb_classe_judicial_pkey on tb_classe_judicial classe (cost=0.28..1.39 rows=1 width=4) (never executed)

  • Index Cond: (id_classe_judicial = (proc.id_classe_judicial)::integer)
  • Heap Fetches: 0
34. 0.000 0.000 ↓ 0.0 0

Nested Loop Semi Join (cost=3.85..81.97 rows=1 width=8) (never executed)

35. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=2.14..8.23 rows=1 width=24) (never executed)

36. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.71..6.91 rows=1 width=20) (never executed)

37. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.28..5.58 rows=1 width=16) (never executed)

38. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.85..4.25 rows=1 width=12) (never executed)

39. 0.000 0.000 ↓ 0.0 0

Index Only Scan using tb_processo_trf_fk on tb_processo_trf proctrf_1 (cost=0.42..1.32 rows=1 width=4) (never executed)

  • Index Cond: (id_processo_trf = (proctrf.id_processo_trf)::integer)
  • Heap Fetches: 0
40. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_tb_processo_parte_proc on tb_processo_parte pp1_1 (cost=0.43..2.86 rows=7 width=8) (never executed)

  • Index Cond: ((id_processo_trf)::integer = (proctrf_1.id_processo_trf)::integer)
41. 0.000 0.000 ↓ 0.0 0

Index Only Scan using tb_usuario_pkey on tb_usuario usu (cost=0.43..1.33 rows=1 width=4) (never executed)

  • Index Cond: (id_usuario = (pp1_1.id_pessoa)::integer)
  • Heap Fetches: 0
42. 0.000 0.000 ↓ 0.0 0

Index Only Scan using tb_usuario_pkey on tb_usuario_login login_1 (cost=0.43..1.33 rows=1 width=4) (never executed)

  • Index Cond: (id_usuario = (pp1_1.id_pessoa)::integer)
  • Heap Fetches: 0
43. 0.000 0.000 ↓ 0.0 0

Index Only Scan using tb_pessoa_pkey on tb_pessoa pessoa_1 (cost=0.43..1.33 rows=1 width=4) (never executed)

  • Index Cond: (id_pessoa = (pp1_1.id_pessoa)::integer)
  • Heap Fetches: 0
44. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.71..73.73 rows=1 width=12) (never executed)

45. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.28..70.53 rows=1 width=8) (never executed)

46. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.86..69.21 rows=1 width=12) (never executed)

47. 0.000 0.000 ↓ 0.0 0

Index Only Scan using tb_pessoa_pkey on tb_pessoa pe_1 (cost=0.43..1.33 rows=1 width=4) (never executed)

  • Index Cond: (id_pessoa = (pessoa_1.id_pessoa)::integer)
  • Heap Fetches: 0
48. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_pessoa on tb_processo_parte pp_1 (cost=0.43..67.01 rows=87 width=8) (never executed)

  • Index Cond: ((id_pessoa)::integer = (pe_1.id_pessoa)::integer)
49. 0.000 0.000 ↓ 0.0 0

Index Only Scan using tb_processo_trf_fk on tb_processo_trf o_2 (cost=0.42..1.32 rows=1 width=4) (never executed)

  • Index Cond: (id_processo_trf = (pp_1.id_processo_trf)::integer)
  • Heap Fetches: 0
50. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_tb_pessoa_doc_identificacao3 on tb_pess_doc_identificacao di_1 (cost=0.43..3.19 rows=1 width=4) (never executed)

  • Index Cond: ((id_pessoa)::integer = (pe_1.id_pessoa)::integer)
  • Filter: ((nr_documento_identificacao)::text = '6'::text)
Planning time : 191.438 ms
Execution time : 10.110 ms