explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6sG3

Settings
# exclusive inclusive rows x rows loops node
1. 0.096 2,198.065 ↓ 12.0 12 1

Sort (cost=23,701.83..23,701.83 rows=1 width=404) (actual time=2,198.060..2,198.065 rows=12 loops=1)

  • Sort Key: (CASE WHEN ((wdp.vl_saldo_parcelamento IS NOT NULL) AND (wdp.vl_saldo_parcelamento <= '0'::numeric)) THEN 1 WHEN (wdde.json_doc_eletronico IS NULL) THEN '-1'::integer ELSE 0 END), wdp.dt_liberacao, wdp.nm_pessoa_posto
  • Sort Method: quicksort Memory: 46kB
2.          

CTE with_dados_parcelamento

3. 0.080 1,601.586 ↓ 17.0 17 1

Sort (cost=10,778.59..10,778.59 rows=1 width=252) (actual time=1,601.576..1,601.586 rows=17 loops=1)

  • Sort Key: cfpar.dt_liberacao, cfpar.nr_parcela
  • Sort Method: quicksort Memory: 31kB
4. 0.106 1,601.506 ↓ 17.0 17 1

Nested Loop Left Join (cost=1,612.44..10,778.58 rows=1 width=252) (actual time=1,503.109..1,601.506 rows=17 loops=1)

5. 0.057 1,589.466 ↓ 17.0 17 1

Nested Loop Left Join (cost=1,612.15..10,774.58 rows=1 width=156) (actual time=1,501.822..1,589.466 rows=17 loops=1)

6. 0.052 1,587.930 ↓ 17.0 17 1

Nested Loop (cost=1,611.85..10,773.81 rows=1 width=152) (actual time=1,501.775..1,587.930 rows=17 loops=1)

7. 0.061 1,587.827 ↓ 17.0 17 1

Nested Loop (cost=1,611.71..10,773.65 rows=1 width=153) (actual time=1,501.764..1,587.827 rows=17 loops=1)

8. 0.142 1,587.647 ↓ 17.0 17 1

Nested Loop (cost=1,611.43..10,773.35 rows=1 width=141) (actual time=1,501.725..1,587.647 rows=17 loops=1)

  • Join Filter: (ct.cd_pessoa_filial = p.cd_pessoa)
  • Rows Removed by Join Filter: 170
9. 0.069 1,585.397 ↓ 17.0 17 1

Nested Loop (cost=1,200.14..10,361.59 rows=1 width=134) (actual time=1,499.985..1,585.397 rows=17 loops=1)

10. 0.059 1,585.141 ↓ 17.0 17 1

Nested Loop (cost=1,199.85..10,361.11 rows=1 width=94) (actual time=1,499.935..1,585.141 rows=17 loops=1)

11. 0.391 1,584.657 ↓ 17.0 17 1

Nested Loop (cost=1,199.42..10,359.85 rows=1 width=94) (actual time=1,499.803..1,584.657 rows=17 loops=1)

12. 11.646 1,483.340 ↑ 1.9 126 1

Hash Join (cost=1,199.00..9,734.15 rows=243 width=54) (actual time=1,444.583..1,483.340 rows=126 loops=1)

  • Hash Cond: (cfpag.cd_ctrc = ct.cd_ctrc)
13. 1,419.563 1,419.563 ↓ 1.0 11,876 1

Index Scan using pk_carta_frete_pagamento on carta_frete_pagamento cfpag (cost=0.42..8,387.27 rows=11,747 width=24) (actual time=27.120..1,419.563 rows=11,876 loops=1)

  • Index Cond: (id_tipo = 2)
  • Filter: (cd_pessoa IS NOT NULL)
14. 5.845 52.131 ↑ 1.0 6,714 1

Hash (cost=1,114.35..1,114.35 rows=6,738 width=34) (actual time=52.131..52.131 rows=6,714 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 510kB
15. 46.286 46.286 ↑ 1.0 6,714 1

Index Scan using idx_ctrc_dt_emissao on ctrc ct (cost=0.42..1,114.35 rows=6,738 width=34) (actual time=0.059..46.286 rows=6,714 loops=1)

  • Index Cond: (dt_emissao >= '2019-02-05'::date)
16. 85.554 100.926 ↓ 0.0 0 126

Index Scan using pk_carta_frete_parcelamento on carta_frete_parcelamento cfpar (cost=0.42..2.57 rows=1 width=44) (actual time=0.801..0.801 rows=0 loops=126)

  • Index Cond: ((cd_ctrc = cfpag.cd_ctrc) AND (id_tipo = 2) AND (nr_parcela = cfpag.nr_parcela))
  • Filter: ((vl_saldo_parcelamento IS NOT NULL) AND ((NOT (alternatives: SubPlan 2 or hashed SubPlan 3)) OR (vl_saldo_parcelamento > '3'::numeric)))
  • Rows Removed by Filter: 1
17.          

SubPlan (forIndex Scan)

18. 15.372 15.372 ↑ 1.0 1 126

Index Only Scan using pk_carta_frete_parcelamento_documento_eletronico on carta_frete_parcelamento_documento_eletronico cfpde_ (cost=0.28..1.41 rows=1 width=0) (actual time=0.122..0.122 rows=1 loops=126)

  • Index Cond: ((cd_ctrc = cfpar.cd_ctrc) AND (id_tipo = cfpar.id_tipo) AND (nr_parcela = cfpar.nr_parcela))
  • Heap Fetches: 137
19. 0.000 0.000 ↓ 0.0 0

Seq Scan on carta_frete_parcelamento_documento_eletronico cfpde__1 (cost=0.00..118.29 rows=7,129 width=8) (never executed)

20. 0.425 0.425 ↑ 1.0 1 17

Index Scan using pk_carta_frete on carta_frete cf (cost=0.42..1.26 rows=1 width=12) (actual time=0.025..0.025 rows=1 loops=17)

  • Index Cond: (cd_ctrc = cfpag.cd_ctrc)
21. 0.187 0.187 ↑ 1.0 1 17

Index Scan using pk_pessoa on pessoa pe (cost=0.29..0.48 rows=1 width=44) (actual time=0.011..0.011 rows=1 loops=17)

  • Index Cond: (cd_pessoa = cfpag.cd_pessoa)
22. 0.289 2.108 ↑ 1.0 11 17

Unique (cost=411.29..411.51 rows=11 width=102) (actual time=0.103..0.124 rows=11 loops=17)

23. 0.209 1.819 ↑ 1.0 11 17

Sort (cost=411.29..411.32 rows=11 width=102) (actual time=0.102..0.107 rows=11 loops=17)

  • Sort Key: p.nm_fantasia, p.cd_pessoa, p.cd_cidade, (((ci.nm_cidade || ' / '::text) || (uf.ds_sigla)::text)), pj.nr_cnpj, (substr((pj.nr_cnpj)::text, 1, 8)), (COALESCE((SubPlan 4), f.cd_pessoa_matriz))
  • Sort Method: quicksort Memory: 26kB
24. 0.058 1.610 ↑ 1.0 11 1

Nested Loop (cost=1.00..411.10 rows=11 width=102) (actual time=0.542..1.610 rows=11 loops=1)

25. 0.021 0.694 ↑ 1.0 11 1

Nested Loop (cost=0.86..67.29 rows=11 width=54) (actual time=0.337..0.694 rows=11 loops=1)

26. 0.026 0.541 ↑ 1.0 11 1

Nested Loop (cost=0.58..63.98 rows=11 width=38) (actual time=0.314..0.541 rows=11 loops=1)

  • Join Filter: (f.cd_pessoa_matriz = eg.cd_pessoa)
  • Rows Removed by Join Filter: 1
27. 0.026 0.504 ↑ 1.0 11 1

Nested Loop (cost=0.58..62.66 rows=11 width=38) (actual time=0.301..0.504 rows=11 loops=1)

28. 0.025 0.357 ↑ 1.0 11 1

Nested Loop Left Join (cost=0.29..35.05 rows=11 width=23) (actual time=0.271..0.357 rows=11 loops=1)

  • Join Filter: (pg.cd_empresa = f.cd_pessoa_matriz)
  • Rows Removed by Join Filter: 1
29. 0.028 0.277 ↑ 1.0 11 1

Nested Loop Left Join (cost=0.29..28.69 rows=11 width=23) (actual time=0.228..0.277 rows=11 loops=1)

30. 0.205 0.205 ↑ 1.0 11 1

Seq Scan on filial f (cost=0.00..1.14 rows=11 width=8) (actual time=0.198..0.205 rows=11 loops=1)

  • Filter: (id_ativo = 1)
31. 0.044 0.044 ↑ 1.0 1 11

Index Scan using pk_pessoa_juridica on pessoa_juridica pj (cost=0.29..2.51 rows=1 width=19) (actual time=0.004..0.004 rows=1 loops=11)

  • Index Cond: (cd_pessoa = f.cd_pessoa_filial)
32. 0.022 0.055 ↑ 2.0 1 11

Materialize (cost=0.00..6.03 rows=2 width=4) (actual time=0.004..0.005 rows=1 loops=11)

33. 0.033 0.033 ↑ 2.0 1 1

Seq Scan on parametro_geral pg (cost=0.00..6.02 rows=2 width=4) (actual time=0.032..0.033 rows=1 loops=1)

34. 0.121 0.121 ↑ 1.0 1 11

Index Scan using pk_pessoa on pessoa p (cost=0.29..2.51 rows=1 width=19) (actual time=0.011..0.011 rows=1 loops=11)

  • Index Cond: (cd_pessoa = f.cd_pessoa_filial)
35. 0.005 0.011 ↑ 2.0 1 11

Materialize (cost=0.00..1.03 rows=2 width=4) (actual time=0.001..0.001 rows=1 loops=11)

36. 0.006 0.006 ↑ 1.0 2 1

Seq Scan on empresa_grupo eg (cost=0.00..1.02 rows=2 width=4) (actual time=0.005..0.006 rows=2 loops=1)

  • Filter: (id_ativo = 1)
37. 0.132 0.132 ↑ 1.0 1 11

Index Scan using pk_cidade on cidade ci (cost=0.28..0.30 rows=1 width=20) (actual time=0.012..0.012 rows=1 loops=11)

  • Index Cond: (cd_cidade = p.cd_cidade)
38. 0.033 0.033 ↑ 1.0 1 11

Index Scan using pk_uf on uf (cost=0.14..0.16 rows=1 width=7) (actual time=0.003..0.003 rows=1 loops=11)

  • Index Cond: (cd_uf = ci.cd_uf)
39.          

SubPlan (forNested Loop)

40. 0.022 0.825 ↑ 1.0 1 11

Limit (cost=31.08..31.08 rows=1 width=4) (actual time=0.075..0.075 rows=1 loops=11)

41. 0.011 0.803 ↑ 1.0 1 11

Unique (cost=31.08..31.08 rows=1 width=4) (actual time=0.073..0.073 rows=1 loops=11)

42. 0.055 0.792 ↑ 1.0 1 11

Sort (cost=31.08..31.08 rows=1 width=4) (actual time=0.072..0.072 rows=1 loops=11)

  • Sort Key: p_1.cd_pessoa
  • Sort Method: quicksort Memory: 25kB
43. 0.045 0.737 ↑ 1.0 1 11

Nested Loop (cost=0.58..31.07 rows=1 width=4) (actual time=0.026..0.067 rows=1 loops=11)

  • Join Filter: (f_1.cd_pessoa_filial = p_1.cd_pessoa)
44. 0.198 0.638 ↑ 1.0 1 11

Nested Loop (cost=0.29..28.86 rows=1 width=8) (actual time=0.018..0.058 rows=1 loops=11)

45. 0.077 0.077 ↑ 1.0 11 11

Seq Scan on filial f_1 (cost=0.00..1.11 rows=11 width=4) (actual time=0.001..0.007 rows=11 loops=11)

46. 0.363 0.363 ↓ 0.0 0 121

Index Scan using pk_pessoa_juridica on pessoa_juridica pjm (cost=0.29..2.52 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=121)

  • Index Cond: (cd_pessoa = f_1.cd_pessoa_filial)
  • Filter: (substr((nr_cnpj)::text, 1, 12) = (substr((pj.nr_cnpj)::text, 1, 8) || '0001'::text))
  • Rows Removed by Filter: 1
47. 0.054 0.054 ↑ 1.0 1 9

Index Only Scan using pk_pessoa on pessoa p_1 (cost=0.29..2.19 rows=1 width=4) (actual time=0.006..0.006 rows=1 loops=9)

  • Index Cond: (cd_pessoa = pjm.cd_pessoa)
  • Heap Fetches: 9
48. 0.119 0.119 ↑ 1.0 1 17

Index Scan using pk_cidade on cidade cp (cost=0.28..0.30 rows=1 width=20) (actual time=0.007..0.007 rows=1 loops=17)

  • Index Cond: (cd_cidade = pe.cd_cidade)
49. 0.051 0.051 ↑ 1.0 1 17

Index Scan using pk_uf on uf up (cost=0.14..0.16 rows=1 width=7) (actual time=0.003..0.003 rows=1 loops=17)

  • Index Cond: (cd_uf = cp.cd_uf)
50. 1.479 1.479 ↑ 1.0 1 17

Index Scan using pk_veiculo on veiculo ve (cost=0.29..0.77 rows=1 width=12) (actual time=0.087..0.087 rows=1 loops=17)

  • Index Cond: (cd_veiculo = ct.cd_veiculo)
51. 0.340 0.340 ↑ 1.0 1 17

Index Scan using pk_pessoa on pessoa pm (cost=0.29..0.60 rows=1 width=28) (actual time=0.020..0.020 rows=1 loops=17)

  • Index Cond: (cd_pessoa = ct.cd_pessoa_motorista)
52.          

SubPlan (forNested Loop Left Join)

53. 0.051 11.594 ↑ 1.0 1 17

Limit (cost=3.39..3.39 rows=1 width=36) (actual time=0.681..0.682 rows=1 loops=17)

54. 0.170 11.543 ↑ 2.0 1 17

Sort (cost=3.39..3.39 rows=2 width=36) (actual time=0.679..0.679 rows=1 loops=17)

  • Sort Key: em_.id_principal, em_.cd_email DESC
  • Sort Method: quicksort Memory: 25kB
55. 11.373 11.373 ↓ 1.5 3 17

Index Scan using idx_email_cd_pessoa on email em_ (cost=0.29..3.38 rows=2 width=36) (actual time=0.455..0.669 rows=3 loops=17)

  • Index Cond: (cd_pessoa = pe.cd_pessoa)
56.          

CTE with_dados_documento_eletronico_saldo

57. 0.344 146.869 ↓ 14.0 28 1

GroupAggregate (cost=10,108.09..10,108.15 rows=2 width=44) (actual time=146.438..146.869 rows=28 loops=1)

  • Group Key: wdp_1.cd_ctrc, wdp_1.id_tipo, wdp_1.nr_parcela, de.cd_documento_eletronico
58. 0.421 146.525 ↓ 125.0 250 1

Sort (cost=10,108.09..10,108.09 rows=2 width=21) (actual time=146.405..146.525 rows=250 loops=1)

  • Sort Key: wdp_1.cd_ctrc, wdp_1.id_tipo, wdp_1.nr_parcela, de.cd_documento_eletronico
  • Sort Method: quicksort Memory: 44kB
59. 8.726 146.104 ↓ 125.0 250 1

Nested Loop Anti Join (cost=1.03..10,108.08 rows=2 width=21) (actual time=106.800..146.104 rows=250 loops=1)

  • Join Filter: (vp.cd_veiculo = ve_1.cd_veiculo)
  • Rows Removed by Join Filter: 17750
60. 0.286 129.128 ↓ 125.0 250 1

Nested Loop Left Join (cost=1.03..10,104.36 rows=2 width=25) (actual time=106.640..129.128 rows=250 loops=1)

61. 0.067 117.446 ↓ 14.0 28 1

Nested Loop Left Join (cost=0.75..9,996.75 rows=2 width=20) (actual time=100.524..117.446 rows=28 loops=1)

  • Filter: CASE WHEN (de.ds_placa_abastecimento IS NOT NULL) THEN (ct_1.cd_veiculo = ve_1.cd_veiculo) ELSE true END
62. 0.068 117.155 ↓ 7.0 28 1

Nested Loop Left Join (cost=0.32..9,986.14 rows=4 width=28) (actual time=100.482..117.155 rows=28 loops=1)

63. 6.399 115.883 ↓ 7.0 28 1

Hash Join (cost=0.03..9,983.12 rows=4 width=24) (actual time=100.456..115.883 rows=28 loops=1)

  • Hash Cond: (substr((COALESCE(de.nr_cnpj_cpf_emitente, de.nr_cnpj_cpf_remetente))::text, 1, 8) = substr((wdp_1.nr_cnpj_posto)::text, 1, 8))
  • Join Filter: ((de.dt_emissao >= wdp_1.dt_liberacao) AND (de.dt_emissao <= (wdp_1.dt_liberacao + '45 days'::interval)))
  • Rows Removed by Join Filter: 3749
64. 109.411 109.411 ↑ 1.0 6,798 1

Seq Scan on documento_eletronico de (cost=0.00..9,938.71 rows=7,003 width=52) (actual time=16.118..109.411 rows=6,798 loops=1)

  • Filter: (vl_saldo_combustivel IS NOT NULL)
  • Rows Removed by Filter: 206476
65. 0.028 0.073 ↓ 17.0 17 1

Hash (cost=0.02..0.02 rows=1 width=31) (actual time=0.073..0.073 rows=17 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
66. 0.045 0.045 ↓ 17.0 17 1

CTE Scan on with_dados_parcelamento wdp_1 (cost=0.00..0.02 rows=1 width=31) (actual time=0.004..0.045 rows=17 loops=1)

67. 1.204 1.204 ↓ 0.0 0 28

Index Scan using un_veiculo_ds_placa on veiculo ve_1 (cost=0.29..0.75 rows=1 width=12) (actual time=0.043..0.043 rows=0 loops=28)

  • Index Cond: ((ds_placa)::text = (de.ds_placa_abastecimento)::text)
68. 0.224 0.224 ↑ 1.0 1 28

Index Scan using pk_ctrc on ctrc ct_1 (cost=0.42..2.64 rows=1 width=8) (actual time=0.008..0.008 rows=1 loops=28)

  • Index Cond: (cd_ctrc = wdp_1.cd_ctrc)
69. 11.396 11.396 ↓ 4.5 9 28

Index Scan using pk_carta_frete_parcelamento_documento_eletronico on carta_frete_parcelamento_documento_eletronico cfpde (cost=0.28..53.78 rows=2 width=9) (actual time=0.395..0.407 rows=9 loops=28)

  • Index Cond: (cd_documento_eletronico = de.cd_documento_eletronico)
70. 8.202 8.250 ↓ 1.1 71 250

Materialize (cost=0.00..1.96 rows=64 width=4) (actual time=0.001..0.033 rows=71 loops=250)

71. 0.048 0.048 ↓ 1.1 71 1

Seq Scan on veiculo_proprio vp (cost=0.00..1.64 rows=64 width=4) (actual time=0.012..0.048 rows=71 loops=1)

72.          

CTE with_dados_documentos_eletronicos

73. 117.069 596.046 ↓ 6.0 12 1

GroupAggregate (cost=2,812.11..2,814.99 rows=2 width=40) (actual time=569.570..596.046 rows=12 loops=1)

  • Group Key: wddes.cd_ctrc, wddes.id_tipo, wddes.nr_parcela
74. 0.108 478.837 ↓ 14.0 28 1

Sort (cost=2,812.11..2,812.11 rows=2 width=208) (actual time=478.815..478.837 rows=28 loops=1)

  • Sort Key: wddes.cd_ctrc, wddes.id_tipo, wddes.nr_parcela
  • Sort Method: quicksort Memory: 32kB
75. 0.455 478.729 ↓ 14.0 28 1

Nested Loop Left Join (cost=6.04..2,812.10 rows=2 width=208) (actual time=223.408..478.729 rows=28 loops=1)

  • Join Filter: (es.cd_uf = ci_1.cd_uf)
  • Rows Removed by Join Filter: 728
76. 0.098 477.882 ↓ 14.0 28 1

Nested Loop Left Join (cost=6.04..2,808.08 rows=2 width=209) (actual time=223.335..477.882 rows=28 loops=1)

77. 0.099 477.672 ↓ 14.0 28 1

Nested Loop (cost=5.76..2,807.48 rows=2 width=197) (actual time=223.306..477.672 rows=28 loops=1)

78. 62.983 361.709 ↓ 14.0 28 1

Hash Right Join (cost=5.34..2,806.52 rows=2 width=177) (actual time=205.404..361.709 rows=28 loops=1)

  • Hash Cond: ((pe_1.nr_cnpj_cpf)::text = (COALESCE(de_1.nr_cnpj_cpf_emitente, de_1.nr_cnpj_cpf_remetente))::text)
79. 148.753 148.753 ↓ 1.0 91,872 1

Seq Scan on pessoa pe_1 (cost=0.00..2,457.21 rows=91,721 width=16) (actual time=0.020..148.753 rows=91,872 loops=1)

80. 0.057 149.973 ↓ 14.0 28 1

Hash (cost=5.32..5.32 rows=2 width=173) (actual time=149.973..149.973 rows=28 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
81. 0.084 149.916 ↓ 14.0 28 1

Nested Loop (cost=0.42..5.32 rows=2 width=173) (actual time=147.629..149.916 rows=28 loops=1)

82. 146.920 146.920 ↓ 14.0 28 1

CTE Scan on with_dados_documento_eletronico_saldo wddes (cost=0.00..0.04 rows=2 width=44) (actual time=146.445..146.920 rows=28 loops=1)

83. 2.912 2.912 ↑ 1.0 1 28

Index Scan using pk_documento_eletronico on documento_eletronico de_1 (cost=0.42..2.64 rows=1 width=129) (actual time=0.104..0.104 rows=1 loops=28)

  • Index Cond: (cd_documento_eletronico = wddes.cd_documento_eletronico)
84. 115.864 115.864 ↑ 1.0 1 28

Index Scan using pk_documento_eletronico_xml on documento_eletronico_xml dex (cost=0.42..0.48 rows=1 width=24) (actual time=4.138..4.138 rows=1 loops=28)

  • Index Cond: (cd_documento_eletronico = de_1.cd_documento_eletronico)
85. 0.112 0.112 ↑ 1.0 1 28

Index Scan using pk_cidade on cidade ci_1 (cost=0.28..0.30 rows=1 width=20) (actual time=0.004..0.004 rows=1 loops=28)

  • Index Cond: (cd_cidade = pe_1.cd_cidade)
86. 0.366 0.392 ↑ 2.6 27 28

Materialize (cost=0.00..2.06 rows=71 width=7) (actual time=0.001..0.014 rows=27 loops=28)

87. 0.026 0.026 ↑ 2.6 27 1

Seq Scan on uf es (cost=0.00..1.71 rows=71 width=7) (actual time=0.012..0.026 rows=27 loops=1)

88.          

SubPlan (forGroupAggregate)

89. 0.140 0.140 ↓ 0.0 0 28

Index Only Scan using pk_carta_frete_parcelamento_documento_eletronico on carta_frete_parcelamento_documento_eletronico cfpde__2 (cost=0.28..1.41 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=28)

  • Index Cond: ((cd_ctrc = wddes.cd_ctrc) AND (id_tipo = wddes.id_tipo) AND (nr_parcela = wddes.nr_parcela) AND (cd_documento_eletronico = wddes.cd_documento_eletronico))
  • Heap Fetches: 7
90. 0.000 0.000 ↓ 0.0 0

Seq Scan on carta_frete_parcelamento_documento_eletronico cfpde__3 (cost=0.00..118.29 rows=7,129 width=12) (never executed)

91. 0.136 2,197.969 ↓ 12.0 12 1

Nested Loop (cost=0.00..0.10 rows=1 width=404) (actual time=2,197.730..2,197.969 rows=12 loops=1)

  • Join Filter: ((wdp.cd_ctrc = wdde.cd_ctrc) AND (wdp.id_tipo = wdde.id_tipo) AND (wdp.nr_parcela = wdde.nr_parcela))
  • Rows Removed by Join Filter: 192
92. 1,601.592 1,601.592 ↓ 17.0 17 1

CTE Scan on with_dados_parcelamento wdp (cost=0.00..0.02 rows=1 width=368) (actual time=1,601.580..1,601.592 rows=17 loops=1)

93. 596.241 596.241 ↓ 6.0 12 17

CTE Scan on with_dados_documentos_eletronicos wdde (cost=0.00..0.04 rows=2 width=40) (actual time=33.505..35.073 rows=12 loops=17)

  • Filter: (json_doc_eletronico IS NOT NULL)