explain.depesz.com

PostgreSQL's explain analyze made readable

Result: USZY

Settings
# exclusive inclusive rows x rows loops node
1. 0.223 620.009 ↓ 137.0 137 1

Sort (cost=46,738.26..46,738.26 rows=1 width=108) (actual time=620.000..620.009 rows=137 loops=1)

  • Output: orgaojulga2_.id_jurisdicao, orgaojulga1_.id_orgao_julgador_colegiado, orgaojulga2_.id_orgao_julgador, ((SubPlan 1)), jurisdicao6_.ds_jurisdicao, orgaojulga1_.ds_orgao_julgador_colegiado, orgaojulga2_.ds_orgao_julgador, ((COALESCE(orgaojulga2_.ds_codigo_origem, '0'::bpchar))::integer), (count(processotr0_.id_processo_trf))
  • Sort Key: jurisdicao6_.ds_jurisdicao, orgaojulga1_.ds_orgao_julgador_colegiado, ((COALESCE(orgaojulga2_.ds_codigo_origem, '0'::bpchar))::integer), ((SubPlan 1))
  • Sort Method: quicksort Memory: 44kB
  • Buffers: shared hit=19432 read=1533
2. 0.211 619.786 ↓ 137.0 137 1

GroupAggregate (cost=46,723.97..46,738.25 rows=1 width=108) (actual time=619.539..619.786 rows=137 loops=1)

  • Output: orgaojulga2_.id_jurisdicao, orgaojulga1_.id_orgao_julgador_colegiado, orgaojulga2_.id_orgao_julgador, ((SubPlan 1)), jurisdicao6_.ds_jurisdicao, orgaojulga1_.ds_orgao_julgador_colegiado, orgaojulga2_.ds_orgao_julgador, ((COALESCE(orgaojulga2_.ds_codigo_origem, '0'::bpchar))::integer), count(processotr0_.id_processo_trf)
  • Group Key: orgaojulga1_.id_orgao_julgador_colegiado, orgaojulga2_.id_orgao_julgador, ((SubPlan 1)), jurisdicao6_.ds_jurisdicao, ((COALESCE(orgaojulga2_.ds_codigo_origem, '0'::bpchar))::integer)
  • Buffers: shared hit=19432 read=1533
3. 0.581 619.575 ↓ 566.0 566 1

Sort (cost=46,723.97..46,723.97 rows=1 width=104) (actual time=619.534..619.575 rows=566 loops=1)

  • Output: orgaojulga1_.id_orgao_julgador_colegiado, orgaojulga2_.id_orgao_julgador, ((SubPlan 1)), jurisdicao6_.ds_jurisdicao, ((COALESCE(orgaojulga2_.ds_codigo_origem, '0'::bpchar))::integer), orgaojulga2_.id_jurisdicao, orgaojulga1_.ds_orgao_julgador_colegiado, orgaojulga2_.ds_orgao_julgador, processotr0_.id_processo_trf
  • Sort Key: orgaojulga1_.id_orgao_julgador_colegiado, orgaojulga2_.id_orgao_julgador, ((SubPlan 1)), jurisdicao6_.ds_jurisdicao, ((COALESCE(orgaojulga2_.ds_codigo_origem, '0'::bpchar))::integer)
  • Sort Method: quicksort Memory: 104kB
  • Buffers: shared hit=19432 read=1533
4. 0.943 618.994 ↓ 566.0 566 1

Nested Loop Left Join (cost=40,370.45..46,723.96 rows=1 width=104) (actual time=609.723..618.994 rows=566 loops=1)

  • Output: orgaojulga1_.id_orgao_julgador_colegiado, orgaojulga2_.id_orgao_julgador, (SubPlan 1), jurisdicao6_.ds_jurisdicao, (COALESCE(orgaojulga2_.ds_codigo_origem, '0'::bpchar))::integer, orgaojulga2_.id_jurisdicao, orgaojulga1_.ds_orgao_julgador_colegiado, orgaojulga2_.ds_orgao_julgador, processotr0_.id_processo_trf
  • Inner Unique: true
  • Buffers: shared hit=19432 read=1533
5. 1.804 616.353 ↓ 566.0 566 1

Hash Join (cost=40,370.31..46,709.53 rows=1 width=73) (actual time=609.702..616.353 rows=566 loops=1)

  • Output: processotr0_.id_orgao_julgador, processotr0_.id_processo_trf, processotr0_.id_orgao_julgador_colegiado, orgaojulga2_.id_jurisdicao, orgaojulga2_.id_orgao_julgador, orgaojulga2_.ds_orgao_julgador, orgaojulga2_.ds_codigo_origem, jurisdicao6_.ds_jurisdicao
  • Hash Cond: ((ppa.id_processo_trf)::integer = (processotr0_.id_processo_trf)::integer)
  • Buffers: shared hit=18292 read=1533
6. 8.513 21.250 ↑ 21.7 12,288 1

HashAggregate (cost=15,204.24..17,873.38 rows=266,914 width=4) (actual time=16.385..21.250 rows=12,288 loops=1)

  • Output: ppa.id_processo_trf
  • Group Key: ppa.id_processo_trf
  • Buffers: shared hit=3820
7. 1.409 12.737 ↑ 21.6 12,333 1

Append (cost=79.68..14,536.95 rows=266,914 width=4) (actual time=0.992..12.737 rows=12,333 loops=1)

  • Buffers: shared hit=3820
8. 1.746 9.259 ↑ 14.8 12,311 1

Nested Loop (cost=79.68..7,899.69 rows=181,652 width=4) (actual time=0.992..9.259 rows=12,311 loops=1)

  • Output: ppa.id_processo_trf
  • Buffers: shared hit=3663
9. 0.303 1.528 ↓ 1.0 855 1

Hash Join (cost=79.24..398.25 rows=817 width=4) (actual time=0.977..1.528 rows=855 loops=1)

  • Output: ppe.id_pessoa
  • Inner Unique: true
  • Hash Cond: ((ppp.id_pess_procuradoria_entidade)::integer = (ppe.id_pess_procuradoria_entidade)::integer)
  • Buffers: shared hit=94
10. 0.280 0.336 ↓ 1.0 855 1

Bitmap Heap Scan on pje.tb_pess_procrdor_prcrdoria ppp (cost=12.75..329.61 rows=817 width=4) (actual time=0.070..0.336 rows=855 loops=1)

  • Output: ppp.id_pess_prcrdor_procuradoria, ppp.id_pessoa_fisica, ppp.id_pess_procuradoria_entidade
  • Recheck Cond: ((ppp.id_pessoa_fisica)::integer = 267196)
  • Heap Blocks: exact=73
  • Buffers: shared hit=79
11. 0.056 0.056 ↓ 1.0 855 1

Bitmap Index Scan on tb_pess_prcrdor_prcrdoria_in01 (cost=0.00..12.54 rows=817 width=0) (actual time=0.056..0.056 rows=855 loops=1)

  • Index Cond: ((ppp.id_pessoa_fisica)::integer = 267196)
  • Buffers: shared hit=6
12. 0.471 0.889 ↑ 1.0 2,622 1

Hash (cost=33.72..33.72 rows=2,622 width=8) (actual time=0.889..0.889 rows=2,622 loops=1)

  • Output: ppe.id_pess_procuradoria_entidade, ppe.id_pessoa
  • Buckets: 4096 Batches: 1 Memory Usage: 135kB
  • Buffers: shared hit=15
13. 0.418 0.418 ↑ 1.0 2,622 1

Seq Scan on pje.tb_pess_prcrdoria_entidade ppe (cost=0.00..33.72 rows=2,622 width=8) (actual time=0.007..0.418 rows=2,622 loops=1)

  • Output: ppe.id_pess_procuradoria_entidade, ppe.id_pessoa
  • Buffers: shared hit=15
14. 5.985 5.985 ↑ 15.9 14 855

Index Only Scan using tb_processo_parte_in07 on pje.tb_processo_parte ppa (cost=0.43..6.95 rows=223 width=8) (actual time=0.004..0.007 rows=14 loops=855)

  • Output: ppa.id_pessoa, ppa.id_processo_trf, ppa.id_tipo_parte, ppa.in_situacao
  • Index Cond: ((ppa.id_pessoa = (ppe.id_pessoa)::integer) AND (ppa.in_situacao = 'A'::bpchar))
  • Heap Fetches: 41
  • Buffers: shared hit=3569
15. 0.011 2.069 ↑ 3,875.5 22 1

Nested Loop (cost=408.90..3,968.12 rows=85,262 width=4) (actual time=1.585..2.069 rows=22 loops=1)

  • Output: ppa_1.id_processo_trf
  • Buffers: shared hit=157
16. 0.283 1.998 ↑ 25.5 15 1

Hash Join (cost=408.46..446.42 rows=383 width=4) (actual time=1.532..1.998 rows=15 loops=1)

  • Output: pau.id_pessoa_autoridade
  • Hash Cond: ((pau.id_orgao_vinculacao)::integer = (ppe_1.id_pessoa)::integer)
  • Buffers: shared hit=105
17. 0.200 0.200 ↑ 1.0 2,082 1

Seq Scan on pje.tb_pessoa_autoridade pau (cost=0.00..26.32 rows=2,082 width=8) (actual time=0.006..0.200 rows=2,082 loops=1)

  • Output: pau.id_pessoa_autoridade, pau.id_orgao_vinculacao, pau.in_judicial
  • Buffers: shared hit=11
18. 0.150 1.515 ↓ 1.0 855 1

Hash (cost=398.25..398.25 rows=817 width=4) (actual time=1.515..1.515 rows=855 loops=1)

  • Output: ppe_1.id_pessoa
  • Buckets: 1024 Batches: 1 Memory Usage: 39kB
  • Buffers: shared hit=94
19. 0.271 1.365 ↓ 1.0 855 1

Hash Join (cost=79.24..398.25 rows=817 width=4) (actual time=0.939..1.365 rows=855 loops=1)

  • Output: ppe_1.id_pessoa
  • Inner Unique: true
  • Hash Cond: ((ppp_1.id_pess_procuradoria_entidade)::integer = (ppe_1.id_pess_procuradoria_entidade)::integer)
  • Buffers: shared hit=94
20. 0.176 0.227 ↓ 1.0 855 1

Bitmap Heap Scan on pje.tb_pess_procrdor_prcrdoria ppp_1 (cost=12.75..329.61 rows=817 width=4) (actual time=0.063..0.227 rows=855 loops=1)

  • Output: ppp_1.id_pess_prcrdor_procuradoria, ppp_1.id_pessoa_fisica, ppp_1.id_pess_procuradoria_entidade
  • Recheck Cond: ((ppp_1.id_pessoa_fisica)::integer = 267196)
  • Heap Blocks: exact=73
  • Buffers: shared hit=79
21. 0.051 0.051 ↓ 1.0 855 1

Bitmap Index Scan on tb_pess_prcrdor_prcrdoria_in01 (cost=0.00..12.54 rows=817 width=0) (actual time=0.051..0.051 rows=855 loops=1)

  • Index Cond: ((ppp_1.id_pessoa_fisica)::integer = 267196)
  • Buffers: shared hit=6
22. 0.486 0.867 ↑ 1.0 2,622 1

Hash (cost=33.72..33.72 rows=2,622 width=8) (actual time=0.867..0.867 rows=2,622 loops=1)

  • Output: ppe_1.id_pess_procuradoria_entidade, ppe_1.id_pessoa
  • Buckets: 4096 Batches: 1 Memory Usage: 135kB
  • Buffers: shared hit=15
23. 0.381 0.381 ↑ 1.0 2,622 1

Seq Scan on pje.tb_pess_prcrdoria_entidade ppe_1 (cost=0.00..33.72 rows=2,622 width=8) (actual time=0.003..0.381 rows=2,622 loops=1)

  • Output: ppe_1.id_pess_procuradoria_entidade, ppe_1.id_pessoa
  • Buffers: shared hit=15
24. 0.060 0.060 ↑ 223.0 1 15

Index Only Scan using tb_processo_parte_in07 on pje.tb_processo_parte ppa_1 (cost=0.43..6.97 rows=223 width=8) (actual time=0.004..0.004 rows=1 loops=15)

  • Output: ppa_1.id_pessoa, ppa_1.id_processo_trf, ppa_1.id_tipo_parte, ppa_1.in_situacao
  • Index Cond: ((ppa_1.id_pessoa = (pau.id_pessoa_autoridade)::integer) AND (ppa_1.in_situacao = 'A'::bpchar))
  • Heap Fetches: 0
  • Buffers: shared hit=52
25. 0.184 593.299 ↓ 568.0 568 1

Hash (cost=25,166.06..25,166.06 rows=1 width=81) (actual time=593.299..593.299 rows=568 loops=1)

  • Output: processotr0_.id_orgao_julgador, processotr0_.id_processo_trf, processotr0_.id_orgao_julgador_colegiado, processopa7_.id_processo_trf, processopa9_.id_processo_trf, orgaojulga2_.id_jurisdicao, orgaojulga2_.id_orgao_julgador, orgaojulga2_.ds_orgao_julgador, orgaojulga2_.ds_codigo_origem, jurisdicao6_.ds_jurisdicao
  • Buckets: 1024 Batches: 1 Memory Usage: 75kB
  • Buffers: shared hit=14472 read=1533
26. 0.164 593.115 ↓ 568.0 568 1

Hash Join (cost=25,158.46..25,166.06 rows=1 width=81) (actual time=592.853..593.115 rows=568 loops=1)

  • Output: processotr0_.id_orgao_julgador, processotr0_.id_processo_trf, processotr0_.id_orgao_julgador_colegiado, processopa7_.id_processo_trf, processopa9_.id_processo_trf, orgaojulga2_.id_jurisdicao, orgaojulga2_.id_orgao_julgador, orgaojulga2_.ds_orgao_julgador, orgaojulga2_.ds_codigo_origem, jurisdicao6_.ds_jurisdicao
  • Hash Cond: ((orgaojulga2_.id_orgao_julgador)::integer = (processotr0_.id_orgao_julgador)::integer)
  • Buffers: shared hit=14472 read=1533
27. 0.050 0.140 ↑ 1.0 154 1

Hash Join (cost=1.13..8.14 rows=154 width=61) (actual time=0.036..0.140 rows=154 loops=1)

  • Output: orgaojulga2_.id_jurisdicao, orgaojulga2_.id_orgao_julgador, orgaojulga2_.ds_orgao_julgador, orgaojulga2_.ds_codigo_origem, jurisdicao6_.ds_jurisdicao
  • Inner Unique: true
  • Hash Cond: ((orgaojulga2_.id_jurisdicao)::integer = (jurisdicao6_.id_jurisdicao)::integer)
  • Buffers: shared hit=11
28. 0.073 0.073 ↑ 1.0 154 1

Seq Scan on pje.tb_orgao_julgador orgaojulga2_ (cost=0.00..6.54 rows=154 width=50) (actual time=0.015..0.073 rows=154 loops=1)

  • Output: orgaojulga2_.id_jurisdicao, orgaojulga2_.id_orgao_julgador, orgaojulga2_.ds_orgao_julgador, orgaojulga2_.ds_codigo_origem
  • Buffers: shared hit=10
29. 0.008 0.017 ↑ 1.0 28 1

Hash (cost=0.78..0.78 rows=28 width=15) (actual time=0.016..0.017 rows=28 loops=1)

  • Output: jurisdicao6_.ds_jurisdicao, jurisdicao6_.id_jurisdicao
  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=1
30. 0.009 0.009 ↑ 1.0 28 1

Seq Scan on pje.tb_jurisdicao jurisdicao6_ (cost=0.00..0.78 rows=28 width=15) (actual time=0.003..0.009 rows=28 loops=1)

  • Output: jurisdicao6_.ds_jurisdicao, jurisdicao6_.id_jurisdicao
  • Buffers: shared hit=1
31. 0.195 592.811 ↓ 568.0 568 1

Hash (cost=25,157.32..25,157.32 rows=1 width=20) (actual time=592.811..592.811 rows=568 loops=1)

  • Output: processotr0_.id_orgao_julgador, processotr0_.id_processo_trf, processotr0_.id_orgao_julgador_colegiado, processopa7_.id_processo_trf, processopa9_.id_processo_trf
  • Buckets: 1024 Batches: 1 Memory Usage: 35kB
  • Buffers: shared hit=14461 read=1533
32. 0.508 592.616 ↓ 568.0 568 1

Nested Loop (cost=25,153.42..25,157.32 rows=1 width=20) (actual time=585.755..592.616 rows=568 loops=1)

  • Output: processotr0_.id_orgao_julgador, processotr0_.id_processo_trf, processotr0_.id_orgao_julgador_colegiado, processopa7_.id_processo_trf, processopa9_.id_processo_trf
  • Inner Unique: true
  • Buffers: shared hit=14461 read=1533
33. 0.467 585.860 ↓ 568.0 568 1

HashAggregate (cost=25,152.99..25,153.00 rows=1 width=8) (actual time=585.710..585.860 rows=568 loops=1)

  • Output: processopa7_.id_processo_trf, processopa9_.id_processo_trf
  • Group Key: (processopa7_.id_processo_trf)::integer
  • Buffers: shared hit=12687 read=1033
34. 0.000 585.393 ↓ 600.0 600 1

Nested Loop (cost=10,314.08..25,152.99 rows=1 width=8) (actual time=579.355..585.393 rows=600 loops=1)

  • Output: processopa7_.id_processo_trf, processopa9_.id_processo_trf, processopa7_.id_processo_trf
  • Inner Unique: true
  • Buffers: shared hit=12687 read=1033
35. 6.027 583.092 ↓ 602.0 602 1

Gather (cost=10,313.65..25,148.54 rows=1 width=22) (actual time=579.338..583.092 rows=602 loops=1)

  • Output: processopa7_.id_processo_trf, processopa7_.id_processo_expediente, processopa7_.dt_prazo_legal_parte, processopa7_.in_tipo_prazo, processopa9_.id_processo_trf
  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=10308 read=1004
36. 1.087 577.065 ↓ 201.0 201 3

Nested Loop (cost=9,313.65..24,148.44 rows=1 width=22) (actual time=572.594..577.065 rows=201 loops=3)

  • Output: processopa7_.id_processo_trf, processopa7_.id_processo_expediente, processopa7_.dt_prazo_legal_parte, processopa7_.in_tipo_prazo, processopa9_.id_processo_trf
  • Buffers: shared hit=10302 read=1004
  • Worker 0: actual time=570.477..576.153 rows=239 loops=1
  • Buffers: shared hit=1273 read=7
  • Worker 1: actual time=570.439..576.137 rows=241 loops=1
  • Buffers: shared hit=1304 read=5
37. 0.000 575.973 ↑ 1.4 203 3

Parallel Bitmap Heap Scan on pje.tb_proc_parte_expediente processopa7_ (cost=9,313.22..23,455.01 rows=283 width=22) (actual time=572.530..575.973 rows=203 loops=3)

  • Output: processopa7_.id_processo_parte_expediente, processopa7_.id_pessoa_parte, processopa7_.id_processo_expediente, processopa7_.dt_ciencia_parte, processopa7_.qt_prazo_legal_parte, processopa7_.dt_prazo_legal_parte, processopa7_.qt_prazo_processual_parte, processopa7_.dt_prazo_processual_parte, processopa7_.in_ciencia_sistema, processopa7_.id_pessoa_ciencia, processopa7_.nm_pessoa_parte, processopa7_.nm_pessoa_ciencia, processopa7_.in_pendente_manifestacao, processopa7_.id_resposta, processopa7_.ds_pendencia, processopa7_.in_fechado, processopa7_.in_tipo_prazo, processopa7_.id_processo_trf, processopa7_.in_pessoal, processopa7_.id_processo_parte, processopa7_.nr_prazo_expediente_automatico
  • Recheck Cond: (((processopa7_.id_pessoa_parte)::integer = ANY ('{267196,153089,784663,1053949,770905,724128,1339314,1602507,891020,65983,604678,891019,750528,1133004,597735,1014909,1233554,65869,574346,1530429,413268,883482,1224264,616013,1608046,389560,1371595,1503777,513166,580198,47028,466221,1592756,833240,1362831,1620327,1576812,615235,740528,67620,920274,1542322,1562838,966242,1480673,699174,831189,367740,297171,1585438,456327,73667,113181,65714,653273,1403930,453255,1088114,970428,723376,268195,98112,772392,506191,875169,65965,273824,1514305,1161854,220390,867303,326323,1570640,81133,603087,1605861,1098939,514598,501029,1536651,941449,46307,1518095,1059580,918234,766756,1487301,778328,1076802,681514,422168,824537,413057,598635,806331,1565889,394686,21810,238320,907950,653537,485497,30989,378409,813572,899897,1399277,1420243,16740,1126389,1516412,1325742,163822,957584,932155,511742,1516555,1462252,45399,389543,670319,1480678,112703,413250,154096,1307674,443401,393821,591716,1379067,922072,271370,946454,149561,598631,1200615,783984,1233091,1260004,576633,654545,344469,1079104,909466,1600081,329089,1480561,310660,1593394,1576069,963868,764897,32523,613697,875156,429378,804371,461427,627786,1576861,1159209,1016115,197661,1070158,813569,884670,609605,627787,1163757,291872,628708,1248458,1337497,1171726,661720,269451,289039,1206248,125825,665191,1181376,889103,263886,1622149,1311246,913000,1601836,389491,616036,509807,1604391,634829,1047016,931561,376704,994786,1267160,1437379,998422,374894,1452220,1621745,447983,645638,1561590,213661,1143949,195938,991891,604117,428046,1072509,814573,78491,1450882,995733,487958,162900,1138502,598056,1573295,658848,1598185,350624,1278888,84061,65992,1413380,1227778,1286912,299515,1053977,195941,558422,669499,1293402,958236,542990,1016119,694885,1439816,979392,1576865,370565,1576837,1028585,268513,549558,1566069,583531,528776,104562,1395520,65720,716954,87066,1256868,590319,1016082,1583808,908459,998267,193014,332711,995462,1433100,23997,1616422,934397,694456,789583,360248,1227944,350138,389723,1071121,1109276,254162,16392,445257,1524186,1277628,659911,169197,52036,1116359,1378502,862744,653179,1510382,46303,837185,694789,1615838,356414,589370,545485,583103,865766,648493,1621641,389724,158568,859416,1372649,1002435,24505,1592239,1505739,1366646,590287,930321,1272908,1108562,663100,1171385,99997,220242,809321,1380749,429989,648002,681627,667582,920289,584852,1416133,543218,1576807,943522,529915,1576851,449539,682899,1260437,364977,96574,1622307,749323,1227739,44640,1044330,890756,1612997,1136431,467206,1521661,822597,1202630,1576795,865803,311222,1360370,65975,1529672,647995,1622894,1463129,1424008,40885,138039,1171585,784661,1537008,905194,1212059,268061,936485,459229,678131,1581750,1153304,65905,1572251,554571,616364,98082,1499411,1171718,404643,1283882,135628,896381,487460,456323,726891,519750,1115300,112799,585202,1053321,292469,41015,789832,704718,1116586,784718,264430,978446,532519,1412421,1192385,353514,1208222,822586,364987,1115154,115176,1620623,397694,796988,363561,1123666,694742,65908,772787,953523,1268647,1390635,1517111,1372379,1522402,556386,1240326,195426,1115116,16988,1132222,1619978,921947,1016113,856873,396701,1518749,138352,416802,594604,437893,1595537,653748,468219,1035359,1202285,1108696,1221907,1154430,984510,50942,1575815,1298966,377419,517179,237187,465108,1115405,935668,919616,884021,447976,1161867,310661,267320,1231485,90930,519566,505156,1406383,883868,1010852,718724,604865,335142,1121313,1115364,1351218,770628,335844,1439723,508855,552346,450168,1023833,559008,478744,1608207,404100,1126193,45425,1419271,1484214,66144,1364517,1573454,649560,1502312,1397094,316245,111312,35709,1576817,1172282,770625,43872,664731,151957,433730,1412455,192248,726351,528881,1605850,389405,1531057,717797,1221922,466920,382668,980967,785409,242165,1237898,232398,1554897,976309,880224,1525595,1252668,783680,810896,550869,1462330,900704,1535635,1487147,1025809,1576303,979980,112701,649573,1098608,923508,583530,700395,1124662,1510316,167195,1004139,1313101,456325,1374888,445702,413243,499241,1103279,487046,300240,276307,158580,819920,708911,995934,1362419,1562161,981905,613674,35701,527809,1394014,816873,531436,831046,165085,813576,468218,1570713,282095,1052856,1404240,1233115,646661,693966,528874,389428,706725,84132,310655,735082,368370,796990,1062733,641660,1310867,119297,437144,45723,813699,1070401,389420,1521652,935337,64999,625469,1507070,1602515,966035,1605827,73613,413007,1114993,1219780,1310289,16468,1098591,679905,1537942,967308,584853,832977,1084798,1576870,900839,302420,1517105,490777,1292345,1421637,557728,419894,606268,1250113,608537,269270,231877,1231728,241287,533471,879984,542916,705728,754861,1287274,953529,248093,567708,111315,772363,232413,1369046,960222,1161905,1275539,1091033,1077653,1255407,932160,125834,1098557,604859,678124,1085697,842661,658350,1454638,1390624,181048,641508,7590,1275514,1240336,281539,529138,435527,7589,1014908,413048,1044157,89823,1108821,1108765,866757,335318,1337671,1359362,1449177,694764,365192,815622,714276,1194351,959182,391503,490008,1161871,1613017,865831,471235,10372,734273,51485,1131716,65855,292949,1577972,1024426,365162,771588,65677,1540022,1524324,677389,291846,911790,66745,659559,691176,498379,541555,1576845,571103,544434,1159551,121972,389357,857975,534971,1115343,1617390,853127,404642,65686,1298608,104561,1024039,1556225,1466675,556428,399986,1130010,1097417,145268,1385319,580487,922786,245471,281551,639082,871357,1441071,944692,755355,1597626,451289,1307218,1219776,857876,65680,1353631,439708,100292,1108866,892601,1180448,1464117,459231,661419,920311,857750,389622,1562614,1309740,389852,820366,1069600,1621398,1138597,724779,577218,442250,808139,943573,751775,66376,1309847,957162,389647,1044242,772784,943422,239727,540691,363589,307667,241807,1171399,525772,1221917,485545,1097377,389426,1034028,385333,1355265,193425,845592,281559,1442347,66100,1576854,959172,572070,389074,1171742,844787,1195669,404639,604875,1108636,918307,741832,1595330,1449268,1115252,890587,1535826,220370,508209,15633,1219480,1058611,595036,1371262,499023,1525710,84144,206811,1330092,35700,279392,65703,324317,905147,1301351,1453569,1293816,1348708,934685,1085068,1290915,784072,963799,430099,1582995,515219,66122,1123787,376042}'::integer[])) AND (processopa7_.in_fechado = 'N'::bpchar))
  • Filter: ((processopa7_.id_resposta IS NULL) AND (processopa7_.dt_ciencia_parte IS NOT NULL) AND ((((processopa7_.dt_prazo_legal_parte)::timestamp without time zone >= CURRENT_DATE) AND (processopa7_.in_tipo_prazo <> ALL ('{S,C}'::bpchar[]))) OR (processopa7_.dt_prazo_legal_parte IS NULL)))
  • Rows Removed by Filter: 217
  • Heap Blocks: exact=295
  • Buffers: shared hit=8138 read=1004
  • Worker 0: actual time=570.399..574.812 rows=243 loops=1
  • Buffers: shared hit=418 read=7
  • Worker 1: actual time=570.346..574.799 rows=242 loops=1
  • Buffers: shared hit=442 read=5
38. 2.928 576.408 ↓ 0.0 0 1

BitmapAnd (cost=9,313.22..9,313.22 rows=6,475 width=0) (actual time=576.408..576.408 rows=0 loops=1)

  • Buffers: shared hit=6990 read=985
39. 500.582 500.582 ↑ 5.2 43,822 1

Bitmap Index Scan on tb_proc_parte_expediente_in01 (cost=0.00..3,776.08 rows=227,718 width=0) (actual time=500.582..500.582 rows=43,822 loops=1)

  • Index Cond: ((processopa7_.id_pessoa_parte)::integer = ANY ('{267196,153089,784663,1053949,770905,724128,1339314,1602507,891020,65983,604678,891019,750528,1133004,597735,1014909,1233554,65869,574346,1530429,413268,883482,1224264,616013,1608046,389560,1371595,1503777,513166,580198,47028,466221,1592756,833240,1362831,1620327,1576812,615235,740528,67620,920274,1542322,1562838,966242,1480673,699174,831189,367740,297171,1585438,456327,73667,113181,65714,653273,1403930,453255,1088114,970428,723376,268195,98112,772392,506191,875169,65965,273824,1514305,1161854,220390,867303,326323,1570640,81133,603087,1605861,1098939,514598,501029,1536651,941449,46307,1518095,1059580,918234,766756,1487301,778328,1076802,681514,422168,824537,413057,598635,806331,1565889,394686,21810,238320,907950,653537,485497,30989,378409,813572,899897,1399277,1420243,16740,1126389,1516412,1325742,163822,957584,932155,511742,1516555,1462252,45399,389543,670319,1480678,112703,413250,154096,1307674,443401,393821,591716,1379067,922072,271370,946454,149561,598631,1200615,783984,1233091,1260004,576633,654545,344469,1079104,909466,1600081,329089,1480561,310660,1593394,1576069,963868,764897,32523,613697,875156,429378,804371,461427,627786,1576861,1159209,1016115,197661,1070158,813569,884670,609605,627787,1163757,291872,628708,1248458,1337497,1171726,661720,269451,289039,1206248,125825,665191,1181376,889103,263886,1622149,1311246,913000,1601836,389491,616036,509807,1604391,634829,1047016,931561,376704,994786,1267160,1437379,998422,374894,1452220,1621745,447983,645638,1561590,213661,1143949,195938,991891,604117,428046,1072509,814573,78491,1450882,995733,487958,162900,1138502,598056,1573295,658848,1598185,350624,1278888,84061,65992,1413380,1227778,1286912,299515,1053977,195941,558422,669499,1293402,958236,542990,1016119,694885,1439816,979392,1576865,370565,1576837,1028585,268513,549558,1566069,583531,528776,104562,1395520,65720,716954,87066,1256868,590319,1016082,1583808,908459,998267,193014,332711,995462,1433100,23997,1616422,934397,694456,789583,360248,1227944,350138,389723,1071121,1109276,254162,16392,445257,1524186,1277628,659911,169197,52036,1116359,1378502,862744,653179,1510382,46303,837185,694789,1615838,356414,589370,545485,583103,865766,648493,1621641,389724,158568,859416,1372649,1002435,24505,1592239,1505739,1366646,590287,930321,1272908,1108562,663100,1171385,99997,220242,809321,1380749,429989,648002,681627,667582,920289,584852,1416133,543218,1576807,943522,529915,1576851,449539,682899,1260437,364977,96574,1622307,749323,1227739,44640,1044330,890756,1612997,1136431,467206,1521661,822597,1202630,1576795,865803,311222,1360370,65975,1529672,647995,1622894,1463129,1424008,40885,138039,1171585,784661,1537008,905194,1212059,268061,936485,459229,678131,1581750,1153304,65905,1572251,554571,616364,98082,1499411,1171718,404643,1283882,135628,896381,487460,456323,726891,519750,1115300,112799,585202,1053321,292469,41015,789832,704718,1116586,784718,264430,978446,532519,1412421,1192385,353514,1208222,822586,364987,1115154,115176,1620623,397694,796988,363561,1123666,694742,65908,772787,953523,1268647,1390635,1517111,1372379,1522402,556386,1240326,195426,1115116,16988,1132222,1619978,921947,1016113,856873,396701,1518749,138352,416802,594604,437893,1595537,653748,468219,1035359,1202285,1108696,1221907,1154430,984510,50942,1575815,1298966,377419,517179,237187,465108,1115405,935668,919616,884021,447976,1161867,310661,267320,1231485,90930,519566,505156,1406383,883868,1010852,718724,604865,335142,1121313,1115364,1351218,770628,335844,1439723,508855,552346,450168,1023833,559008,478744,1608207,404100,1126193,45425,1419271,1484214,66144,1364517,1573454,649560,1502312,1397094,316245,111312,35709,1576817,1172282,770625,43872,664731,151957,433730,1412455,192248,726351,528881,1605850,389405,1531057,717797,1221922,466920,382668,980967,785409,242165,1237898,232398,1554897,976309,880224,1525595,1252668,783680,810896,550869,1462330,900704,1535635,1487147,1025809,1576303,979980,112701,649573,1098608,923508,583530,700395,1124662,1510316,167195,1004139,1313101,456325,1374888,445702,413243,499241,1103279,487046,300240,276307,158580,819920,708911,995934,1362419,1562161,981905,613674,35701,527809,1394014,816873,531436,831046,165085,813576,468218,1570713,282095,1052856,1404240,1233115,646661,693966,528874,389428,706725,84132,310655,735082,368370,796990,1062733,641660,1310867,119297,437144,45723,813699,1070401,389420,1521652,935337,64999,625469,1507070,1602515,966035,1605827,73613,413007,1114993,1219780,1310289,16468,1098591,679905,1537942,967308,584853,832977,1084798,1576870,900839,302420,1517105,490777,1292345,1421637,557728,419894,606268,1250113,608537,269270,231877,1231728,241287,533471,879984,542916,705728,754861,1287274,953529,248093,567708,111315,772363,232413,1369046,960222,1161905,1275539,1091033,1077653,1255407,932160,125834,1098557,604859,678124,1085697,842661,658350,1454638,1390624,181048,641508,7590,1275514,1240336,281539,529138,435527,7589,1014908,413048,1044157,89823,1108821,1108765,866757,335318,1337671,1359362,1449177,694764,365192,815622,714276,1194351,959182,391503,490008,1161871,1613017,865831,471235,10372,734273,51485,1131716,65855,292949,1577972,1024426,365162,771588,65677,1540022,1524324,677389,291846,911790,66745,659559,691176,498379,541555,1576845,571103,544434,1159551,121972,389357,857975,534971,1115343,1617390,853127,404642,65686,1298608,104561,1024039,1556225,1466675,556428,399986,1130010,1097417,145268,1385319,580487,922786,245471,281551,639082,871357,1441071,944692,755355,1597626,451289,1307218,1219776,857876,65680,1353631,439708,100292,1108866,892601,1180448,1464117,459231,661419,920311,857750,389622,1562614,1309740,389852,820366,1069600,1621398,1138597,724779,577218,442250,808139,943573,751775,66376,1309847,957162,389647,1044242,772784,943422,239727,540691,363589,307667,241807,1171399,525772,1221917,485545,1097377,389426,1034028,385333,1355265,193425,845592,281559,1442347,66100,1576854,959172,572070,389074,1171742,844787,1195669,404639,604875,1108636,918307,741832,1595330,1449268,1115252,890587,1535826,220370,508209,15633,1219480,1058611,595036,1371262,499023,1525710,84144,206811,1330092,35700,279392,65703,324317,905147,1301351,1453569,1293816,1348708,934685,1085068,1290915,784072,963799,430099,1582995,515219,66122,1123787,376042}'::integer[]))
  • Buffers: shared hit=1735 read=985
40. 72.898 72.898 ↓ 1.2 467,158 1

Bitmap Index Scan on tb_proc_parte_expediente_in08 (cost=0.00..5,536.55 rows=403,748 width=0) (actual time=72.898..72.898 rows=467,158 loops=1)

  • Index Cond: (processopa7_.in_fechado = 'N'::bpchar)
  • Buffers: shared hit=5255
41. 0.005 0.005 ↑ 1.0 1 609

Index Only Scan using tb_processo_parte_in07 on pje.tb_processo_parte processopa9_ (cost=0.43..2.44 rows=1 width=8) (actual time=0.004..0.005 rows=1 loops=609)

  • Output: processopa9_.id_pessoa, processopa9_.id_processo_trf, processopa9_.id_tipo_parte, processopa9_.in_situacao
  • Index Cond: ((processopa9_.id_pessoa = (processopa7_.id_pessoa_parte)::integer) AND (processopa9_.id_processo_trf = (processopa7_.id_processo_trf)::integer))
  • Heap Fetches: 2
  • Buffers: shared hit=2164
  • Worker 0: actual time=0.005..0.005 rows=1 loops=243
  • Buffers: shared hit=855
  • Worker 1: actual time=0.005..0.005 rows=1 loops=242
  • Buffers: shared hit=862
42. 3.010 3.010 ↑ 1.0 1 602

Index Scan using tb_processo_expediente_ak on pje.tb_processo_expediente processoex11_ (cost=0.43..4.44 rows=1 width=12) (actual time=0.005..0.005 rows=1 loops=602)

  • Output: processoex11_.id_processo_expediente, processoex11_.dt_criacao_expediente
  • Index Cond: ((processoex11_.id_processo_expediente)::integer = (processopa7_.id_processo_expediente)::integer)
  • Filter: ((((processopa7_.dt_prazo_legal_parte)::timestamp without time zone >= CURRENT_DATE) AND (processopa7_.in_tipo_prazo <> ALL ('{S,C}'::bpchar[]))) OR ((processopa7_.dt_prazo_legal_parte IS NULL) AND ((processoex11_.dt_criacao_expediente)::timestamp without time zone >= '2019-07-02 00:00:00'::timestamp without time zone)))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=2379 read=29
43. 6.248 6.248 ↑ 1.0 1 568

Index Scan using tb_processo_trf_pk on pje.tb_processo_trf processotr0_ (cost=0.43..4.31 rows=1 width=12) (actual time=0.011..0.011 rows=1 loops=568)

  • Output: processotr0_.id_processo_trf, processotr0_.nr_sequencia, processotr0_.nr_digito_verificador, processotr0_.nr_ano, processotr0_.nr_identificacao_orgao_justica, processotr0_.id_jurisdicao, processotr0_.in_inicial, processotr0_.cd_processo_status, processotr0_.vl_causa, processotr0_.dt_autuacao, processotr0_.nr_origem_processo, processotr0_.in_segredo_justica, processotr0_.ds_observacao_segredo, processotr0_.in_justica_gratuita, processotr0_.id_classe_judicial, processotr0_.id_orgao_julgador, processotr0_.dt_transitado_julgado, processotr0_.id_localizacao_inicial, processotr0_.id_estrutura_inicial, processotr0_.in_apreciado_segredo, processotr0_.dt_distribuicao, processotr0_.in_apreciado_sigilo, processotr0_.in_selecionado_pauta, processotr0_.in_revisado, processotr0_.id_orgao_julgador_revisor, processotr0_.id_pessoa_marcou_revisado, processotr0_.id_pessoa_marcou_pauta, processotr0_.id_cargo, processotr0_.in_outra_instancia, processotr0_.id_endereco_wsdl, processotr0_.id_orgao_julgador_colegiado, processotr0_.id_proc_referencia, processotr0_.ds_proc_referencia, processotr0_.in_selecionado_julgamento, processotr0_.id_pessoa_marcou_julgamento, processotr0_.id_cl_judicial_outra_instancia, processotr0_.nr_instancia, processotr0_.id_pessoa_relator_processo, processotr0_.in_apreciado_justica_gratuita, processotr0_.id_pes_apreciou_jus_gratuita, processotr0_.dt_sugestao_sessao, processotr0_.in_pronto_revisao, processotr0_.in_tutela_liminar, processotr0_.in_apreciado_tutela_liminar, processotr0_.id_sessao_sugerida, processotr0_.id_municipio_fato_principal, processotr0_.vl_peso_processual, processotr0_.vl_peso_distribuicao, processotr0_.id_orgao_julgador_cargo, processotr0_.in_violacao_faixa_valores, processotr0_.in_incidente, processotr0_.in_mandado_devolvido, processotr0_.in_deve_marcar_audiencia, processotr0_.in_revisao, processotr0_.acao_revisor
  • Index Cond: ((processotr0_.id_processo_trf)::integer = (processopa7_.id_processo_trf)::integer)
  • Filter: (processotr0_.cd_processo_status = 'D'::bpchar)
  • Buffers: shared hit=1774 read=500
44. 0.000 0.000 ↓ 0.0 0 566

Index Scan using tb_orgao_julgador_colgiado_pk on pje.tb_orgao_julgador_colgiado orgaojulga1_ (cost=0.14..0.16 rows=1 width=36) (actual time=0.000..0.000 rows=0 loops=566)

  • Output: orgaojulga1_.id_orgao_julgador_colegiado, orgaojulga1_.ds_orgao_julgador_colegiado
  • Index Cond: ((processotr0_.id_orgao_julgador_colegiado)::integer = (orgaojulga1_.id_orgao_julgador_colegiado)::integer)
45.          

SubPlan (forNested Loop Left Join)

46. 0.000 1.698 ↑ 1.0 1 566

Aggregate (cost=14.24..14.25 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=566)

  • Output: max((caixaadvog4_.id_caixa_adv_proc)::integer)
  • Buffers: shared hit=1140
47. 0.000 1.698 ↓ 0.0 0 566

Nested Loop (cost=2.73..14.23 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=566)

  • Output: caixaadvog4_.id_caixa_adv_proc
  • Inner Unique: true
  • Join Filter: ((caixaadvog4_.id_jurisdicao IS NULL) OR ((caixaadvog4_.id_jurisdicao)::integer = (orgaojulga5_.id_jurisdicao)::integer))
  • Buffers: shared hit=1140
48. 0.554 1.698 ↓ 0.0 0 566

Nested Loop (cost=2.59..10.06 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=566)

  • Output: caixaadvog4_.id_caixa_adv_proc, caixaadvog4_.id_jurisdicao
  • Inner Unique: true
  • Join Filter: (processoca3_.id_caixa_adv_proc = (caixaadvog4_.id_caixa_adv_proc)::integer)
  • Buffers: shared hit=1140
49. 1.132 1.132 ↓ 0.0 0 566

Index Scan using tb_processo_caixa_adv_prc_in01 on pje.tb_processo_caixa_adv_proc processoca3_ (cost=0.29..4.31 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=566)

  • Output: processoca3_.id_processo_caixa_adv_proc, processoca3_.id_processo_trf, processoca3_.id_caixa_adv_proc
  • Index Cond: (processoca3_.id_processo_trf = (processotr0_.id_processo_trf)::integer)
  • Buffers: shared hit=1136
50. 0.002 0.012 ↓ 0.0 0 2

Bitmap Heap Scan on pje.tb_caixa_adv_proc caixaadvog4_ (cost=2.30..5.73 rows=2 width=8) (actual time=0.006..0.006 rows=0 loops=2)

  • Output: caixaadvog4_.id_caixa_adv_proc, caixaadvog4_.id_jurisdicao, caixaadvog4_.id_orgao_julgador, caixaadvog4_.id_localizacao, caixaadvog4_.nm_caixa, caixaadvog4_.ds_caixa, caixaadvog4_.nr_sequencia, caixaadvog4_.nr_digito_verificador, caixaadvog4_.nr_ano, caixaadvog4_.nr_origem_processo, caixaadvog4_.ds_nome_parte, caixaadvog4_.nr_cpf_cnpj_parte, caixaadvog4_.dt_ano_nasc_parte_inicio, caixaadvog4_.dt_ano_nasc_parte_fim, caixaadvog4_.id_uf_oab_parte, caixaadvog4_.ds_letra_oab_parte, caixaadvog4_.nr_oab_parte, caixaadvog4_.vl_causa, caixaadvog4_.dt_distribuicao_inicio, caixaadvog4_.dt_distribuicao_fim, caixaadvog4_.id_prioridade_processo, caixaadvog4_.id_ojc
  • Recheck Cond: ((caixaadvog4_.id_localizacao)::integer = 22405)
  • Filter: (((caixaadvog4_.id_ojc IS NULL) OR ((caixaadvog4_.id_ojc)::integer = (processotr0_.id_orgao_julgador_colegiado)::integer)) AND ((caixaadvog4_.id_orgao_julgador IS NULL) OR ((caixaadvog4_.id_orgao_julgador)::integer = (processotr0_.id_orgao_julgador)::integer)))
  • Buffers: shared hit=4
51. 0.010 0.010 ↓ 0.0 0 2

Bitmap Index Scan on tb_caixa_adv_proc_in03 (cost=0.00..2.30 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=2)

  • Index Cond: ((caixaadvog4_.id_localizacao)::integer = 22405)
  • Buffers: shared hit=4
52. 0.000 0.000 ↓ 0.0 0

Index Scan using tb_orgao_julgador_pk on pje.tb_orgao_julgador orgaojulga5_ (cost=0.14..4.16 rows=1 width=4) (never executed)

  • Output: orgaojulga5_.id_jurisdicao
  • Index Cond: ((processotr0_.id_orgao_julgador)::integer = (orgaojulga5_.id_orgao_julgador)::integer)
Planning time : 9.730 ms
Execution time : 623.729 ms