explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GcOE

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 16.388 ↑ 1.0 10 1

Limit (cost=485.52..485.55 rows=10 width=172) (actual time=16.385..16.388 rows=10 loops=1)

2. 0.528 16.385 ↑ 4.6 10 1

Sort (cost=485.52..485.64 rows=46 width=172) (actual time=16.384..16.385 rows=10 loops=1)

  • Sort Key: processopa0_.id_processo_parte_expediente DESC
  • Sort Method: top-N heapsort Memory: 26kB
3. 0.258 15.857 ↓ 32.2 1,480 1

Nested Loop (cost=4.99..484.53 rows=46 width=172) (actual time=0.088..15.857 rows=1,480 loops=1)

4. 0.688 12.639 ↓ 32.2 1,480 1

Nested Loop Left Join (cost=4.42..450.79 rows=46 width=176) (actual time=0.080..12.639 rows=1,480 loops=1)

5. 0.621 11.951 ↓ 32.2 1,480 1

Nested Loop Left Join (cost=3.99..426.97 rows=46 width=148) (actual time=0.072..11.951 rows=1,480 loops=1)

6. 0.638 11.330 ↓ 32.2 1,480 1

Nested Loop Left Join (cost=3.56..406.24 rows=46 width=148) (actual time=0.066..11.330 rows=1,480 loops=1)

7. 0.693 10.692 ↓ 32.2 1,480 1

Nested Loop Left Join (cost=3.13..293.77 rows=46 width=148) (actual time=0.059..10.692 rows=1,480 loops=1)

8. 0.519 9.999 ↓ 32.2 1,480 1

Nested Loop Left Join (cost=2.71..269.07 rows=46 width=120) (actual time=0.051..9.999 rows=1,480 loops=1)

9. 0.729 6.538 ↓ 47.5 1,471 1

Nested Loop Left Join (cost=1.15..178.91 rows=31 width=112) (actual time=0.026..6.538 rows=1,471 loops=1)

10. 0.642 4.338 ↓ 47.5 1,471 1

Nested Loop (cost=0.87..169.84 rows=31 width=87) (actual time=0.021..4.338 rows=1,471 loops=1)

11. 0.754 0.754 ↓ 47.5 1,471 1

Index Scan using tb_proc_parte_expediente_in05 on tb_proc_parte_expediente processopa0_ (cost=0.43..31.82 rows=31 width=69) (actual time=0.014..0.754 rows=1,471 loops=1)

  • Index Cond: ((id_processo_trf)::integer = 530764)
12. 2.942 2.942 ↑ 1.0 1 1,471

Index Scan using tb_processo_expediente_ak on tb_processo_expediente processoex1_ (cost=0.43..4.45 rows=1 width=22) (actual time=0.002..0.002 rows=1 loops=1,471)

  • Index Cond: ((id_processo_expediente)::integer = (processopa0_.id_processo_expediente)::integer)
13. 1.471 1.471 ↑ 1.0 1 1,471

Index Scan using tb_tipo_processo_documento_pk on tb_tipo_processo_documento tipodocume2_ (cost=0.28..0.29 rows=1 width=33) (actual time=0.001..0.001 rows=1 loops=1,471)

  • Index Cond: ((processoex1_.id_tipo_processo_documento)::integer = (id_tipo_processo_documento)::integer)
14. 0.000 2.942 ↓ 0.0 0 1,471

Nested Loop Left Join (cost=1.56..2.90 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1,471)

15. 0.000 2.942 ↓ 0.0 0 1,471

Nested Loop Left Join (cost=1.14..1.27 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1,471)

16. 1.387 2.942 ↓ 0.0 0 1,471

Nested Loop Left Join (cost=0.85..0.97 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1,471)

17. 1.471 1.471 ↓ 0.0 0 1,471

Index Scan using tb_expediente_central_uk on tb_expediente_central expediente5_ (cost=0.42..0.44 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1,471)

  • Index Cond: ((processoex1_.id_processo_expediente)::integer = id_processo_expediente)
18. 0.084 0.084 ↑ 2.0 1 21

Index Scan using tb_posse_expediente_in01 on tb_posse_expediente posseexped6_ (cost=0.43..0.51 rows=2 width=16) (actual time=0.003..0.004 rows=1 loops=21)

  • Index Cond: (expediente5_.id_expediente_central = id_expediente_central)
19. 0.060 0.060 ↑ 1.0 1 30

Index Scan using tb_oficial_area_pk on tb_oficial_area oficialare7_ (cost=0.28..0.30 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=30)

  • Index Cond: (posseexped6_.id_oficial_area = id_oficial_area)
20. 0.060 0.060 ↑ 1.0 1 30

Index Only Scan using tb_pessoa_fisica_pk on tb_pessoa_fisica pessoafisi8_ (cost=0.43..1.63 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=30)

  • Index Cond: (id_pessoa_fisica = oficialare7_.id_pessoa_oficial_justica)
  • Heap Fetches: 0
21. 0.000 0.000 ↓ 0.0 0 1,480

Index Scan using tb_usuario_login_pk on tb_usuario_login usuariolog9_ (cost=0.43..0.54 rows=1 width=36) (actual time=0.000..0.000 rows=0 loops=1,480)

  • Index Cond: ((pessoafisi8_.id_pessoa_fisica)::integer = id_usuario)
22. 0.000 0.000 ↓ 0.0 0 1,480

Index Only Scan using tb_pessoa_pk on tb_pessoa pessoa3_ (cost=0.43..2.45 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=1,480)

  • Index Cond: (id_pessoa = (processopa0_.id_pessoa_ciencia)::integer)
  • Heap Fetches: 0
23. 0.000 0.000 ↓ 0.0 0 1,480

Index Only Scan using tb_usuario_pk on tb_usuario usuario4_ (cost=0.43..0.45 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=1,480)

  • Index Cond: (id_usuario = (pessoa3_.id_pessoa)::integer)
  • Heap Fetches: 0
24. 0.000 0.000 ↓ 0.0 0 1,480

Index Scan using tb_usuario_login_pk on tb_usuario_login usuario4_1_ (cost=0.43..0.52 rows=1 width=36) (actual time=0.000..0.000 rows=0 loops=1,480)

  • Index Cond: ((usuario4_.id_usuario)::integer = id_usuario)
25. 2.960 2.960 ↑ 1.0 1 1,480

Index Only Scan using tb_processo_documento_pk on tb_processo_documento documento10_ (cost=0.57..0.73 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=1,480)

  • Index Cond: (id_processo_documento = processoex1_.id_processo_documento)
  • Heap Fetches: 1
Planning time : 3.332 ms
Execution time : 16.480 ms