explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5nMI

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 0.021 ↓ 0.0 0 1

Sort (cost=8.93..8.93 rows=1 width=107) (actual time=0.021..0.021 rows=0 loops=1)

  • Sort Key: historicod0_.id_hist_processo_documento
  • Sort Method: quicksort Memory: 25kB
2. 0.001 0.016 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.83..8.92 rows=1 width=107) (actual time=0.016..0.016 rows=0 loops=1)

3. 0.015 0.015 ↓ 0.0 0 1

Index Scan using tb_hist_processo_documento_in03 on tb_hist_processo_documento historicod0_ (cost=0.28..4.29 rows=1 width=26) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (id_processo_documento = 11,246,663)
4. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.55..4.61 rows=1 width=81) (never executed)

5. 0.000 0.000 ↓ 0.0 0

Index Scan using tb_tipo_processo_documento_pk on tb_tipo_processo_documento tipodocume1_ (cost=0.28..4.29 rows=1 width=77) (never executed)

  • Index Cond: (historicod0_.id_tipo_processo_documento = (id_tipo_processo_documento)::integer)
6. 0.000 0.000 ↓ 0.0 0

Index Scan using tb_tipo_proc_documento_trf_pk on tb_tipo_proc_documento_trf tipodocume1_1_ (cost=0.28..0.32 rows=1 width=8) (never executed)

  • Index Cond: ((tipodocume1_.id_tipo_processo_documento)::integer = (id_tipo_processo_documento_trf)::integer)