explain.depesz.com

PostgreSQL's explain analyze made readable

Result: m8Hb

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 17.515 ↑ 1.0 10 1

Limit (cost=506.89..506.91 rows=10 width=172) (actual time=17.511..17.515 rows=10 loops=1)

2. 0.548 17.511 ↑ 4.6 10 1

Sort (cost=506.89..507.00 rows=46 width=172) (actual time=17.510..17.511 rows=10 loops=1)

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

Nested Loop (cost=4.99..505.90 rows=46 width=172) (actual time=0.106..16.963 rows=1,480 loops=1)

4. 0.721 13.097 ↓ 32.2 1,480 1

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

5. 0.641 12.376 ↓ 32.2 1,480 1

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

6. 0.683 11.735 ↓ 32.2 1,480 1

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

7. 0.724 11.052 ↓ 32.2 1,480 1

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

8. 0.649 10.328 ↓ 32.2 1,480 1

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

9. 0.829 6.737 ↓ 47.5 1,471 1

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

10. 0.755 4.437 ↓ 47.5 1,471 1

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

11. 0.740 0.740 ↓ 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.016..0.740 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 Scan using tb_processo_documento_pk on tb_processo_documento documento10_ (cost=0.57..1.20 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=1,480)

  • Index Cond: ((id_processo_documento)::integer = processoex1_.id_processo_documento)
  • Filter: ((in_ativo)::bpchar = 'S'::bpchar)