explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FXsy

Settings
# exclusive inclusive rows x rows loops node
1. 589.582 55,322.418 ↑ 1.5 2 1

Nested Loop (cost=525,835.44..2,614,760.75 rows=3 width=367) (actual time=31,978.680..55,322.418 rows=2 loops=1)

  • Join Filter: ((pre.id_processo)::integer = (tpa.id_processo_trf)::integer)
  • Rows Removed by Join Filter: 590532
  • Buffers: shared hit=1035956 dirtied=1
2. 596.742 49,747.784 ↑ 1.0 2 1

Nested Loop (cost=454,216.64..2,526,113.28 rows=2 width=397) (actual time=28,174.072..49,747.784 rows=2 loops=1)

  • Join Filter: ((pre.id_processo)::integer = (prt_1.id_processo_trf)::integer)
  • Rows Removed by Join Filter: 590532
  • Buffers: shared hit=1024886 dirtied=1
3. 227.663 32,339.724 ↓ 2.0 2 1

Nested Loop Left Join (cost=359,561.95..1,187,701.56 rows=1 width=361) (actual time=20,426.862..32,339.724 rows=2 loops=1)

  • Join Filter: ((trf.id_processo_trf)::integer = (pp_4.id_processo_trf)::integer)
  • Rows Removed by Join Filter: 215574
  • Buffers: shared hit=416956 dirtied=1
4. 582.161 27,421.033 ↓ 2.0 2 1

Nested Loop Left Join (cost=262,664.32..1,089,509.48 rows=1 width=329) (actual time=16,853.964..27,421.033 rows=2 loops=1)

  • Join Filter: ((trf.id_processo_trf)::integer = (pp_2.id_processo_trf)::integer)
  • Rows Removed by Join Filter: 533026
  • Buffers: shared hit=153116 dirtied=1
5. 544.893 17,166.804 ↓ 2.0 2 1

Nested Loop Left Join (cost=152,263.30..977,182.69 rows=1 width=297) (actual time=10,011.942..17,166.804 rows=2 loops=1)

  • Join Filter: ((trf.id_processo_trf)::integer = (pp_1.id_processo_trf)::integer)
  • Rows Removed by Join Filter: 553848
  • Buffers: shared hit=42695 dirtied=1
6. 552.740 12,265.427 ↓ 2.0 2 1

Nested Loop Left Join (cost=96,884.94..912,278.24 rows=1 width=265) (actual time=7,350.732..12,265.427 rows=2 loops=1)

  • Join Filter: ((prt.id_processo_trf)::integer = (trf.id_processo_trf)::integer)
  • Rows Removed by Join Filter: 553848
  • Buffers: shared hit=31625 dirtied=1
7. 0.022 1.685 ↓ 2.0 2 1

Nested Loop (cost=2.40..29.36 rows=1 width=233) (actual time=0.306..1.685 rows=2 loops=1)

  • Buffers: shared hit=217 dirtied=1
8. 0.055 1.581 ↓ 2.0 2 1

Nested Loop (cost=2.13..29.06 rows=1 width=209) (actual time=0.274..1.581 rows=2 loops=1)

  • Buffers: shared hit=211 dirtied=1
9. 0.023 1.410 ↓ 2.0 2 1

Nested Loop (cost=1.84..26.17 rows=1 width=200) (actual time=0.182..1.410 rows=2 loops=1)

  • Buffers: shared hit=205 dirtied=1
10. 0.033 1.353 ↓ 2.0 2 1

Nested Loop (cost=1.70..25.91 rows=1 width=200) (actual time=0.176..1.353 rows=2 loops=1)

  • Buffers: shared hit=201 dirtied=1
11. 0.054 1.282 ↓ 2.0 2 1

Nested Loop (cost=1.55..25.74 rows=1 width=164) (actual time=0.168..1.282 rows=2 loops=1)

  • Buffers: shared hit=197 dirtied=1
12. 0.122 1.084 ↓ 16.0 16 1

Nested Loop (cost=1.28..17.43 rows=1 width=92) (actual time=0.155..1.084 rows=16 loops=1)

  • Join Filter: ((pre.id_processo)::integer = (pro.id_processo)::integer)
  • Buffers: shared hit=149 dirtied=1
13. 0.086 0.658 ↓ 16.0 16 1

Nested Loop (cost=0.86..16.91 rows=1 width=62) (actual time=0.129..0.658 rows=16 loops=1)

  • Buffers: shared hit=79 dirtied=1
14. 0.252 0.252 ↓ 16.0 16 1

Index Scan using tb_processo_evento_dt_atualizacao_idx on tb_processo_evento pre (cost=0.44..8.46 rows=1 width=50) (actual time=0.106..0.252 rows=16 loops=1)

  • Index Cond: (((dt_atualizacao)::timestamp without time zone > (now() - '00:01:00'::interval)) AND ((dt_atualizacao)::timestamp without time zone <= now()))
  • Filter: in_visibilidade_externa
  • Buffers: shared hit=14 dirtied=1
15. 0.320 0.320 ↑ 1.0 1 16

Index Scan using idx_tb_processo_trf32 on tb_processo_trf trf (cost=0.42..8.44 rows=1 width=12) (actual time=0.016..0.020 rows=1 loops=16)

  • Index Cond: ((id_processo_trf)::integer = (pre.id_processo)::integer)
  • Buffers: shared hit=65
16. 0.304 0.304 ↑ 1.0 1 16

Index Scan using sys_c005762 on tb_processo pro (cost=0.42..0.51 rows=1 width=30) (actual time=0.015..0.019 rows=1 loops=16)

  • Index Cond: ((id_processo)::integer = (trf.id_processo_trf)::integer)
  • Buffers: shared hit=70
17. 0.144 0.144 ↓ 0.0 0 16

Index Scan using tb_evento_pkey on tb_evento eve (cost=0.27..8.29 rows=1 width=80) (actual time=0.008..0.009 rows=0 loops=16)

  • Index Cond: ((id_evento)::integer = (pre.id_evento)::integer)
  • Filter: (ds_caminho_completo ~~* 'Magistrado|%'::text)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=48
18. 0.038 0.038 ↑ 1.0 1 2

Index Scan using tb_orgao_julgador_pkey on tb_orgao_julgador org (cost=0.14..0.16 rows=1 width=44) (actual time=0.009..0.019 rows=1 loops=2)

  • Index Cond: ((id_orgao_julgador)::integer = (trf.id_orgao_julgador)::integer)
  • Buffers: shared hit=4
19. 0.034 0.034 ↑ 1.0 1 2

Index Scan using idx_tb_jurisdicao_municipio_id_jurisdicao on tb_jurisdicao_municipio juris (cost=0.14..0.25 rows=1 width=8) (actual time=0.009..0.017 rows=1 loops=2)

  • Index Cond: ((id_jurisdicao)::integer = (org.id_jurisdicao)::integer)
  • Filter: in_sede
  • Buffers: shared hit=4
20. 0.116 0.116 ↑ 1.0 1 2

Index Scan using tb_municipio_pkey on tb_municipio muni (cost=0.28..2.88 rows=1 width=17) (actual time=0.040..0.058 rows=1 loops=2)

  • Index Cond: ((id_municipio)::integer = (juris.id_municipio)::integer)
  • Buffers: shared hit=6
21. 0.082 0.082 ↑ 1.0 1 2

Index Scan using tb_classe_judicial_pkey on tb_classe_judicial clj (cost=0.28..0.29 rows=1 width=32) (actual time=0.022..0.041 rows=1 loops=2)

  • Index Cond: ((id_classe_judicial)::integer = (trf.id_classe_judicial)::integer)
  • Buffers: shared hit=6
22. 2,272.516 11,711.002 ↑ 1.1 276,925 2

GroupAggregate (cost=96,882.53..905,673.34 rows=292,246 width=36) (actual time=2,453.936..5,855.501 rows=276,925 loops=2)

  • Group Key: prt.id_processo_trf
  • Buffers: shared hit=31408
23. 1,295.931 5,715.246 ↓ 1.1 335,965 2

Sort (cost=96,882.53..97,613.15 rows=292,246 width=33) (actual time=2,453.881..2,857.623 rows=335,965 loops=2)

  • Sort Key: prt.id_processo_trf
  • Sort Method: quicksort Memory: 41099kB
  • Buffers: shared hit=31408
24. 899.720 4,419.315 ↓ 1.1 335,965 1

Hash Join (cost=37,488.86..70,351.24 rows=292,246 width=33) (actual time=1,992.632..4,419.315 rows=335,965 loops=1)

  • Hash Cond: ((pp.id_processo_trf)::integer = (prt.id_processo_trf)::integer)
  • Buffers: shared hit=31408
25. 925.161 2,725.290 ↓ 1.1 335,965 1

Hash Join (cost=23,038.46..51,882.46 rows=292,246 width=32) (actual time=1,194.733..2,725.290 rows=335,965 loops=1)

  • Hash Cond: ((pp.id_pessoa)::integer = ul.id_usuario)
  • Buffers: shared hit=23758
26. 608.873 608.873 ↓ 1.1 335,965 1

Seq Scan on tb_processo_parte pp (cost=0.00..24,825.61 rows=292,246 width=8) (actual time=0.028..608.873 rows=335,965 loops=1)

  • Filter: (in_parte_principal AND (in_participacao = 'P'::bpchar))
  • Rows Removed by Filter: 761622
  • Buffers: shared hit=11069
27. 616.969 1,191.256 ↑ 1.0 450,279 1

Hash (cost=17,288.76..17,288.76 rows=459,976 width=32) (actual time=1,191.255..1,191.256 rows=450,279 loops=1)

  • Buckets: 524288 Batches: 1 Memory Usage: 33142kB
  • Buffers: shared hit=12689
28. 574.287 574.287 ↑ 1.0 450,279 1

Seq Scan on tb_usuario_login ul (cost=0.00..17,288.76 rows=459,976 width=32) (actual time=0.017..574.287 rows=450,279 loops=1)

  • Buffers: shared hit=12689
29. 384.393 794.305 ↓ 1.0 304,209 1

Hash (cost=10,672.40..10,672.40 rows=302,240 width=5) (actual time=794.304..794.305 rows=304,209 loops=1)

  • Buckets: 524288 Batches: 1 Memory Usage: 15088kB
  • Buffers: shared hit=7650
30. 409.912 409.912 ↓ 1.0 304,209 1

Seq Scan on tb_processo_trf prt (cost=0.00..10,672.40 rows=302,240 width=5) (actual time=0.045..409.912 rows=304,209 loops=1)

  • Buffers: shared hit=7650
31.          

SubPlan (for GroupAggregate)

32. 1,241.080 3,723.240 ↑ 1.0 1 124,108

Aggregate (cost=2.73..2.75 rows=1 width=32) (actual time=0.029..0.030 rows=1 loops=124,108)

33. 1,365.188 2,482.160 ↑ 23.5 4 124,108

Subquery Scan on a_1 (cost=0.00..2.26 rows=94 width=32) (actual time=0.006..0.020 rows=4 loops=124,108)

  • Filter: (a_1.nome <> ALL ('{DE,DA,DO,E,DAS,DOS}'::text[]))
  • Rows Removed by Filter: 1
34. 1,116.972 1,116.972 ↑ 20.0 5 124,108

Result (cost=0.00..0.51 rows=100 width=32) (actual time=0.004..0.009 rows=5 loops=124,108)

35. 1,879.854 4,356.484 ↓ 1.4 276,925 2

GroupAggregate (cost=55,378.36..60,503.91 rows=195,580 width=36) (actual time=866.640..2,178.242 rows=276,925 loops=2)

  • Group Key: pp_1.id_processo_trf
  • Buffers: shared hit=11070
36. 1,193.493 2,476.630 ↓ 1.1 335,965 2

Sort (cost=55,378.36..56,108.98 rows=292,246 width=14) (actual time=866.597..1,238.315 rows=335,965 loops=2)

  • Sort Key: pp_1.id_processo_trf
  • Sort Method: quicksort Memory: 28222kB
  • Buffers: shared hit=11070
37. 697.761 1,283.137 ↓ 1.1 335,965 1

Hash Join (cost=3.07..28,847.07 rows=292,246 width=14) (actual time=0.289..1,283.137 rows=335,965 loops=1)

  • Hash Cond: ((pp_1.id_tipo_parte)::integer = (tp.id_tipo_parte)::integer)
  • Buffers: shared hit=11070
38. 585.152 585.152 ↓ 1.1 335,965 1

Seq Scan on tb_processo_parte pp_1 (cost=0.00..24,825.61 rows=292,246 width=8) (actual time=0.044..585.152 rows=335,965 loops=1)

  • Filter: (in_parte_principal AND (in_participacao = 'P'::bpchar))
  • Rows Removed by Filter: 761622
  • Buffers: shared hit=11069
39. 0.106 0.224 ↑ 1.0 92 1

Hash (cost=1.92..1.92 rows=92 width=14) (actual time=0.223..0.224 rows=92 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
  • Buffers: shared hit=1
40. 0.118 0.118 ↑ 1.0 92 1

Seq Scan on tb_tipo_parte tp (cost=0.00..1.92 rows=92 width=14) (actual time=0.027..0.118 rows=92 loops=1)

  • Buffers: shared hit=1
41. 3,362.234 9,672.068 ↓ 1,332.6 266,514 2

GroupAggregate (cost=110,401.02..112,322.29 rows=200 width=36) (actual time=2,727.327..4,836.034 rows=266,514 loops=2)

  • Group Key: pp_2.id_processo_trf
  • Buffers: shared hit=110421
42. 1,358.915 6,309.834 ↓ 1.3 345,005 2

Sort (cost=110,401.02..111,040.45 rows=255,769 width=36) (actual time=2,727.263..3,154.917 rows=345,005 loops=2)

  • Sort Key: pp_2.id_processo_trf
  • Sort Method: quicksort Memory: 39662kB
  • Buffers: shared hit=110421
43. 651.529 4,950.919 ↓ 1.3 345,005 1

Append (cost=32,975.65..84,869.55 rows=255,769 width=36) (actual time=1,203.700..4,950.919 rows=345,005 loops=1)

  • Buffers: shared hit=110421
44. 673.665 2,292.677 ↓ 1.3 256,833 1

Hash Join (cost=32,975.65..49,285.67 rows=199,658 width=32) (actual time=1,203.695..2,292.677 rows=256,833 loops=1)

  • Hash Cond: ((pp_2.id_pessoa)::integer = ul_1.id_usuario)
  • Buffers: shared hit=25150
45. 418.261 462.301 ↓ 1.3 256,833 1

Bitmap Heap Scan on tb_processo_parte pp_2 (cost=9,937.19..23,501.92 rows=199,658 width=8) (actual time=45.935..462.301 rows=256,833 loops=1)

  • Recheck Cond: (in_participacao = 'A'::bpchar)
  • Filter: (NOT in_parte_principal)
  • Heap Blocks: exact=10567
  • Buffers: shared hit=12461
46. 44.040 44.040 ↓ 1.3 258,512 1

Bitmap Index Scan on idx_tb_processo_parte_painel (cost=0.00..9,887.28 rows=199,658 width=0) (actual time=44.040..44.040 rows=258,512 loops=1)

  • Index Cond: ((in_parte_principal = false) AND (in_participacao = 'A'::bpchar))
  • Buffers: shared hit=1894
47. 589.292 1,156.711 ↑ 1.0 450,279 1

Hash (cost=17,288.76..17,288.76 rows=459,976 width=32) (actual time=1,156.710..1,156.711 rows=450,279 loops=1)

  • Buckets: 524288 Batches: 1 Memory Usage: 33142kB
  • Buffers: shared hit=12689
48. 567.419 567.419 ↑ 1.0 450,279 1

Seq Scan on tb_usuario_login ul_1 (cost=0.00..17,288.76 rows=459,976 width=32) (actual time=0.032..567.419 rows=450,279 loops=1)

  • Buffers: shared hit=12689
49. 167.244 2,006.713 ↓ 1.6 88,172 1

Subquery Scan on *SELECT* 2 (cost=23,039.03..33,587.29 rows=56,111 width=36) (actual time=1,126.589..2,006.713 rows=88,172 loops=1)

  • Buffers: shared hit=85271
50. 237.744 1,839.469 ↓ 1.6 88,172 1

Hash Join (cost=23,039.03..33,026.18 rows=56,111 width=51) (actual time=1,126.584..1,839.469 rows=88,172 loops=1)

  • Hash Cond: ((pp_3.id_pessoa)::integer = ul_2.id_usuario)
  • Buffers: shared hit=85271
51. 178.262 478.735 ↓ 1.6 88,172 1

Merge Join (cost=0.57..9,216.19 rows=56,111 width=55) (actual time=0.192..478.735 rows=88,172 loops=1)

  • Merge Cond: ((pr.id_procuradoria)::integer = pp_3.id_procuradoria)
  • Buffers: shared hit=72582
52. 0.363 0.363 ↓ 1.0 165 1

Index Scan using tb_procuradoria_pkey on tb_procuradoria pr (cost=0.14..18.74 rows=159 width=51) (actual time=0.035..0.363 rows=165 loops=1)

  • Buffers: shared hit=48
53. 300.110 300.110 ↑ 4.9 88,173 1

Index Scan using tb_processo_parte_idx_proc on tb_processo_parte pp_3 (cost=0.43..67,736.43 rows=435,608 width=12) (actual time=0.142..300.110 rows=88,173 loops=1)

  • Filter: (in_parte_principal AND (in_participacao = 'A'::bpchar))
  • Rows Removed by Filter: 52905
  • Buffers: shared hit=72534
54. 567.675 1,122.990 ↑ 1.0 450,279 1

Hash (cost=17,288.76..17,288.76 rows=459,976 width=4) (actual time=1,122.989..1,122.990 rows=450,279 loops=1)

  • Buckets: 524288 Batches: 1 Memory Usage: 19927kB
  • Buffers: shared hit=12689
55. 555.315 555.315 ↑ 1.0 450,279 1

Seq Scan on tb_usuario_login ul_2 (cost=0.00..17,288.76 rows=459,976 width=4) (actual time=0.022..555.315 rows=450,279 loops=1)

  • Buffers: shared hit=12689
56. 1,341.018 4,691.028 ↓ 538.9 107,788 2

GroupAggregate (cost=96,897.63..98,187.58 rows=200 width=36) (actual time=1,501.854..2,345.514 rows=107,788 loops=2)

  • Group Key: pp_4.id_processo_trf
  • Buffers: shared hit=263840
57. 539.904 3,350.010 ↑ 1.3 135,749 2

Sort (cost=96,897.63..97,326.61 rows=171,593 width=36) (actual time=1,501.769..1,675.005 rows=135,749 loops=2)

  • Sort Key: pp_4.id_processo_trf
  • Sort Method: quicksort Memory: 17310kB
  • Buffers: shared hit=263840
58. 244.247 2,810.106 ↑ 1.3 135,749 1

Append (cost=32,959.22..80,262.86 rows=171,593 width=36) (actual time=1,227.907..2,810.106 rows=135,749 loops=1)

  • Buffers: shared hit=263840
59. 218.570 1,596.174 ↑ 1.5 88,149 1

Hash Join (cost=32,959.22..47,544.39 rows=133,949 width=32) (actual time=1,227.899..1,596.174 rows=88,149 loops=1)

  • Hash Cond: ((pp_4.id_pessoa)::integer = ul_3.id_usuario)
  • Buffers: shared hit=24349
60. 153.866 186.302 ↑ 1.5 88,149 1

Bitmap Heap Scan on tb_processo_parte pp_4 (cost=9,920.76..22,664.13 rows=133,949 width=8) (actual time=34.145..186.302 rows=88,149 loops=1)

  • Recheck Cond: (in_participacao = 'P'::bpchar)
  • Filter: (NOT in_parte_principal)
  • Heap Blocks: exact=9766
  • Buffers: shared hit=11660
61. 32.436 32.436 ↑ 1.5 88,543 1

Bitmap Index Scan on idx_tb_processo_parte_painel (cost=0.00..9,887.28 rows=133,949 width=0) (actual time=32.435..32.436 rows=88,543 loops=1)

  • Index Cond: ((in_parte_principal = false) AND (in_participacao = 'P'::bpchar))
  • Buffers: shared hit=1894
62. 608.414 1,191.302 ↑ 1.0 450,279 1

Hash (cost=17,288.76..17,288.76 rows=459,976 width=32) (actual time=1,191.301..1,191.302 rows=450,279 loops=1)

  • Buckets: 524288 Batches: 1 Memory Usage: 33142kB
  • Buffers: shared hit=12689
63. 582.888 582.888 ↑ 1.0 450,279 1

Seq Scan on tb_usuario_login ul_3 (cost=0.00..17,288.76 rows=459,976 width=32) (actual time=0.033..582.888 rows=450,279 loops=1)

  • Buffers: shared hit=12689
64. 89.775 969.685 ↓ 1.3 47,600 1

Subquery Scan on *SELECT* 2_1 (cost=0.99..31,378.99 rows=37,644 width=36) (actual time=0.164..969.685 rows=47,600 loops=1)

  • Buffers: shared hit=239491
65. 145.120 879.910 ↓ 1.3 47,600 1

Merge Join (cost=0.99..31,002.55 rows=37,644 width=51) (actual time=0.156..879.910 rows=47,600 loops=1)

  • Merge Cond: (pp_5.id_procuradoria = (pr_1.id_procuradoria)::integer)
  • Buffers: shared hit=239491
66. 200.743 688.670 ↑ 6.1 47,601 1

Nested Loop (cost=0.85..241,699.13 rows=292,246 width=8) (actual time=0.110..688.670 rows=47,601 loops=1)

  • Buffers: shared hit=239443
67. 249.922 249.922 ↑ 6.1 47,601 1

Index Scan using tb_processo_parte_idx_proc on tb_processo_parte pp_5 (cost=0.43..67,736.43 rows=292,246 width=12) (actual time=0.053..249.922 rows=47,601 loops=1)

  • Filter: (in_parte_principal AND (in_participacao = 'P'::bpchar))
  • Rows Removed by Filter: 93476
  • Buffers: shared hit=72533
68. 238.005 238.005 ↑ 1.0 1 47,601

Index Only Scan using tb_usuario_pkey on tb_usuario_login ul_4 (cost=0.42..0.59 rows=1 width=4) (actual time=0.004..0.005 rows=1 loops=47,601)

  • Index Cond: (id_usuario = (pp_5.id_pessoa)::integer)
  • Heap Fetches: 23748
  • Buffers: shared hit=166910
69. 45.713 46.120 ↓ 277.8 44,165 1

Materialize (cost=0.14..19.14 rows=159 width=51) (actual time=0.034..46.120 rows=44,165 loops=1)

  • Buffers: shared hit=48
70. 0.407 0.407 ↓ 1.0 165 1

Index Scan using tb_procuradoria_pkey on tb_procuradoria pr_1 (cost=0.14..18.74 rows=159 width=51) (actual time=0.023..0.407 rows=165 loops=1)

  • Buffers: shared hit=48
71. 2,974.280 16,811.318 ↑ 1.0 295,267 2

GroupAggregate (cost=94,654.69..1,331,611.32 rows=302,240 width=36) (actual time=1,632.083..8,405.659 rows=295,267 loops=2)

  • Group Key: prt_1.id_processo_trf
  • Buffers: shared hit=607930
72. 2,490.652 8,788.398 ↑ 1.2 377,001 2

Merge Join (cost=94,654.69..129,155.72 rows=435,608 width=33) (actual time=1,632.016..4,394.199 rows=377,001 loops=2)

  • Merge Cond: ((prt_1.id_processo_trf)::integer = (pp_6.id_processo_trf)::integer)
  • Buffers: shared hit=607930
73. 2,096.274 2,096.274 ↓ 1.0 304,207 2

Index Scan using tb_processo_trf_fk on tb_processo_trf prt_1 (cost=0.42..27,222.63 rows=302,240 width=5) (actual time=0.043..1,048.137 rows=304,207 loops=2)

  • Buffers: shared hit=584172
74. 1,441.897 4,201.472 ↑ 1.2 377,001 2

Sort (cost=94,654.19..95,743.21 rows=435,608 width=32) (actual time=1,631.958..2,100.736 rows=377,001 loops=2)

  • Sort Key: pp_6.id_processo_trf
  • Sort Method: quicksort Memory: 44040kB
  • Buffers: shared hit=23758
75. 1,022.988 2,759.575 ↑ 1.2 377,001 1

Hash Join (cost=23,038.46..53,853.68 rows=435,608 width=32) (actual time=1,121.302..2,759.575 rows=377,001 loops=1)

  • Hash Cond: ((pp_6.id_pessoa)::integer = ul_5.id_usuario)
  • Buffers: shared hit=23758
76. 618.357 618.357 ↑ 1.2 377,001 1

Seq Scan on tb_processo_parte pp_6 (cost=0.00..24,825.61 rows=435,608 width=8) (actual time=0.033..618.357 rows=377,001 loops=1)

  • Filter: (in_parte_principal AND (in_participacao = 'A'::bpchar))
  • Rows Removed by Filter: 720586
  • Buffers: shared hit=11069
77. 574.627 1,118.230 ↑ 1.0 450,279 1

Hash (cost=17,288.76..17,288.76 rows=459,976 width=32) (actual time=1,118.229..1,118.230 rows=450,279 loops=1)

  • Buckets: 524288 Batches: 1 Memory Usage: 33142kB
  • Buffers: shared hit=12689
78. 543.603 543.603 ↑ 1.0 450,279 1

Seq Scan on tb_usuario_login ul_5 (cost=0.00..17,288.76 rows=459,976 width=32) (actual time=0.029..543.603 rows=450,279 loops=1)

  • Buffers: shared hit=12689
79.          

SubPlan (for GroupAggregate)

80. 1,735.470 5,048.640 ↑ 1.0 1 157,770

Aggregate (cost=2.73..2.75 rows=1 width=32) (actual time=0.031..0.032 rows=1 loops=157,770)

81. 1,735.470 3,313.170 ↑ 23.5 4 157,770

Subquery Scan on a (cost=0.00..2.26 rows=94 width=32) (actual time=0.007..0.021 rows=4 loops=157,770)

  • Filter: (a.nome <> ALL ('{DE,DA,DO,E,DAS,DOS}'::text[]))
  • Rows Removed by Filter: 1
82. 1,577.700 1,577.700 ↑ 20.0 5 157,770

Result (cost=0.00..0.51 rows=100 width=32) (actual time=0.004..0.010 rows=5 loops=157,770)

83. 870.498 4,985.052 ↓ 1.2 295,267 2

Materialize (cost=71,618.80..82,065.79 rows=239,331 width=36) (actual time=1,003.271..2,492.526 rows=295,267 loops=2)

  • Buffers: shared hit=11070
84. 566.610 4,114.554 ↓ 1.2 295,267 1

Subquery Scan on tpa (cost=71,618.80..80,869.13 rows=239,331 width=36) (actual time=2,006.520..4,114.554 rows=295,267 loops=1)

  • Buffers: shared hit=11070
85. 1,102.996 3,547.944 ↓ 1.2 295,267 1

GroupAggregate (cost=71,618.80..78,475.82 rows=239,331 width=36) (actual time=2,006.514..3,547.944 rows=295,267 loops=1)

  • Group Key: pp_7.id_processo_trf
  • Buffers: shared hit=11070
86. 957.347 2,444.948 ↑ 1.2 377,001 1

Sort (cost=71,618.80..72,707.82 rows=435,608 width=14) (actual time=2,006.379..2,444.948 rows=377,001 loops=1)

  • Sort Key: pp_7.id_processo_trf
  • Sort Method: quicksort Memory: 29964kB
  • Buffers: shared hit=11070
87. 823.464 1,487.601 ↑ 1.2 377,001 1

Hash Join (cost=3.07..30,818.29 rows=435,608 width=14) (actual time=0.314..1,487.601 rows=377,001 loops=1)

  • Hash Cond: ((pp_7.id_tipo_parte)::integer = (tp_1.id_tipo_parte)::integer)
  • Buffers: shared hit=11070
88. 663.908 663.908 ↑ 1.2 377,001 1

Seq Scan on tb_processo_parte pp_7 (cost=0.00..24,825.61 rows=435,608 width=8) (actual time=0.043..663.908 rows=377,001 loops=1)

  • Filter: (in_parte_principal AND (in_participacao = 'A'::bpchar))
  • Rows Removed by Filter: 720586
  • Buffers: shared hit=11069
89. 0.120 0.229 ↑ 1.0 92 1

Hash (cost=1.92..1.92 rows=92 width=14) (actual time=0.228..0.229 rows=92 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
  • Buffers: shared hit=1
90. 0.109 0.109 ↑ 1.0 92 1

Seq Scan on tb_tipo_parte tp_1 (cost=0.00..1.92 rows=92 width=14) (actual time=0.017..0.109 rows=92 loops=1)

  • Buffers: shared hit=1