explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eXWm

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 22,068.753 ↓ 0.0 0 1

Unique (cost=17,613.15..17,613.16 rows=1 width=4) (actual time=22,068.753..22,068.753 rows=0 loops=1)

2. 0.134 22,068.751 ↓ 0.0 0 1

Sort (cost=17,613.15..17,613.15 rows=1 width=4) (actual time=22,068.751..22,068.751 rows=0 loops=1)

  • Sort Key: processo1_.id_processo
  • Sort Method: quicksort Memory: 25kB
3. 0.001 22,068.617 ↓ 0.0 0 1

Nested Loop (cost=4,675.07..17,613.14 rows=1 width=4) (actual time=22,068.617..22,068.617 rows=0 loops=1)

4. 190.294 22,068.616 ↓ 0.0 0 1

Hash Join (cost=4,674.65..17,607.74 rows=1 width=8) (actual time=22,068.616..22,068.616 rows=0 loops=1)

  • Hash Cond: ((processope0_.id_processo_trf)::integer = (processo1_.id_processo)::integer)
  • Join Filter: ((SubPlan 1) = (expediente2_.id_processo_expediente)::integer)
  • Rows Removed by Join Filter: 39579
5. 43.737 6,949.675 ↓ 1.1 39,579 1

Nested Loop (cost=0.42..12,842.24 rows=34,770 width=20) (actual time=7.220..6,949.675 rows=39,579 loops=1)

6. 24.840 24.840 ↑ 1.0 4,298 1

Seq Scan on tb_processo_pericia processope0_ (cost=0.00..192.88 rows=4,298 width=12) (actual time=0.023..24.840 rows=4,298 loops=1)

  • Filter: (cd_status_pericia <> ALL ('{R,C}'::bpchar[]))
  • Rows Removed by Filter: 252
7. 6,881.098 6,881.098 ↓ 1.1 9 4,298

Index Scan using tb_processo_expediente_in01 on tb_processo_expediente expediente2_ (cost=0.42..2.86 rows=8 width=8) (actual time=0.340..1.601 rows=9 loops=4,298)

  • Index Cond: ((id_processo_trf)::integer = (processope0_.id_processo_trf)::integer)
8. 92.779 284.417 ↑ 1.0 134,899 1

Hash (cost=2,987.99..2,987.99 rows=134,899 width=4) (actual time=284.417..284.417 rows=134,899 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 6791kB
9. 191.638 191.638 ↑ 1.0 134,899 1

Seq Scan on tb_processo processo1_ (cost=0.00..2,987.99 rows=134,899 width=4) (actual time=38.376..191.638 rows=134,899 loops=1)

10.          

SubPlan (for Hash Join)

11. 237.474 14,644.230 ↑ 1.0 1 39,579

Aggregate (cost=7.38..7.39 rows=1 width=4) (actual time=0.370..0.370 rows=1 loops=39,579)

12. 9,261.486 14,406.756 ↓ 0.0 0 39,579

Bitmap Heap Scan on tb_proc_parte_expediente processopa4_ (cost=5.36..7.38 rows=1 width=4) (actual time=0.364..0.364 rows=0 loops=39,579)

  • Recheck Cond: (((id_processo_trf)::integer = (processo1_.id_processo)::integer) AND ((id_pessoa_parte)::integer = (processope0_.id_pessoa_perito)::integer))
  • Filter: ((dt_ciencia_parte IS NULL) AND (in_fechado = 'N'::bpchar))
  • Rows Removed by Filter: 1
  • Heap Blocks: exact=26808
13. 197.895 5,145.270 ↓ 0.0 0 39,579

BitmapAnd (cost=5.36..5.36 rows=1 width=0) (actual time=0.130..0.130 rows=0 loops=39,579)

14. 2,651.793 2,651.793 ↓ 2.0 22 39,579

Bitmap Index Scan on tb_proc_parte_expediente_in05 (cost=0.00..2.51 rows=11 width=0) (actual time=0.067..0.067 rows=22 loops=39,579)

  • Index Cond: ((id_processo_trf)::integer = (processo1_.id_processo)::integer)
15. 2,295.582 2,295.582 ↓ 4.0 95 39,579

Bitmap Index Scan on tb_proc_parte_expediente_in01 (cost=0.00..2.60 rows=24 width=0) (actual time=0.058..0.058 rows=95 loops=39,579)

  • Index Cond: ((id_pessoa_parte)::integer = (processope0_.id_pessoa_perito)::integer)
16. 0.000 0.000 ↓ 0.0 0

Index Scan using tb_proc_parte_expediente_pk on tb_proc_parte_expediente processopa3_ (cost=0.42..2.91 rows=1 width=4) (never executed)

  • Index Cond: ((id_processo_parte_expediente)::integer = processope0_.id_proc_parte_exp_laudo)
  • Filter: ((dt_prazo_legal_parte)::timestamp without time zone < '2019-06-11 12:02:37.04'::timestamp without time zone)
Planning time : 2,411.897 ms