explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IC7b

Settings
# exclusive inclusive rows x rows loops node
1. 185.349 3,339.651 ↓ 6,993.0 6,993 1

Nested Loop Left Join (cost=2.67..11,019.84 rows=1 width=299) (actual time=754.550..3,339.651 rows=6,993 loops=1)

2. 17.622 1,883.529 ↓ 6,993.0 6,993 1

Nested Loop Left Join (cost=2.25..9,953.41 rows=1 width=278) (actual time=753.642..1,883.529 rows=6,993 loops=1)

3. 6.829 1,670.103 ↓ 6,993.0 6,993 1

Nested Loop (cost=1.83..9,952.92 rows=1 width=232) (actual time=753.602..1,670.103 rows=6,993 loops=1)

4. 8.027 1,628.309 ↓ 6,993.0 6,993 1

Nested Loop (cost=1.55..9,944.61 rows=1 width=232) (actual time=753.584..1,628.309 rows=6,993 loops=1)

5. 19.431 1,592.310 ↓ 6,993.0 6,993 1

Nested Loop (cost=1.26..9,936.29 rows=1 width=214) (actual time=753.569..1,592.310 rows=6,993 loops=1)

6. 39.608 1,187.518 ↓ 12,431.0 12,431 1

Nested Loop (cost=0.84..9,935.67 rows=1 width=247) (actual time=0.632..1,187.518 rows=12,431 loops=1)

  • Join Filter: (((ni.cnpj_emitente)::text = (n.cnpj_emitente)::text) AND (ni.numero = n.numero) AND (ni.serie = n.serie) AND (ni.tpamb = n.tpamb) AND ((ni.mod)::text = (n.mod)::text))
7. 19.913 762.425 ↓ 2,072.5 12,435 1

Nested Loop (cost=0.42..9,927.07 rows=6 width=144) (actual time=0.555..762.425 rows=12,435 loops=1)

8. 344.592 344.592 ↓ 22.6 12,435 1

Seq Scan on nfe_ident ni (cost=0.00..5,881.48 rows=551 width=83) (actual time=0.448..344.592 rows=12,435 loops=1)

  • Filter: ((to_date(to_char(dhemi, 'YYYY-MM-DD'::text), 'YYYY-MM-DD'::text) >= '2018-05-01'::date) AND (to_date(to_char(dhemi, 'YYYY-MM-DD'::text), 'YYYY-MM-DD'::text) <= '2019-12-01'::date))
  • Rows Removed by Filter: 98,777
9. 397.920 397.920 ↑ 1.0 1 12,435

Index Scan using pk_nfe_emitente on nfe_emitente ne (cost=0.42..7.33 rows=1 width=61) (actual time=0.031..0.032 rows=1 loops=12,435)

  • Index Cond: (((cnpj_emitente)::text = (ni.cnpj_emitente)::text) AND (numero = ni.numero) AND (serie = ni.serie) AND (tpamb = ni.tpamb) AND ((mod)::text = (ni.mod)::text))
10. 385.485 385.485 ↑ 1.0 1 12,435

Index Scan using pk_nfe on nfe n (cost=0.42..1.41 rows=1 width=103) (actual time=0.031..0.031 rows=1 loops=12,435)

  • Index Cond: (((cnpj_emitente)::text = (ne.cnpj_emitente)::text) AND (numero = ne.numero) AND (serie = ne.serie) AND (tpamb = ne.tpamb) AND ((mod)::text = (ne.mod)::text))
11. 385.361 385.361 ↑ 1.0 1 12,431

Index Scan using idx_nfe_empresa_doc on nfe_empresa ng (cost=0.42..0.61 rows=1 width=41) (actual time=0.031..0.031 rows=1 loops=12,431)

  • Index Cond: (((cnpj_emitente)::text = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND ((mod)::text = (n.mod)::text))
  • Filter: (emp_codigo = 758)
  • Rows Removed by Filter: 0
12. 27.972 27.972 ↑ 1.0 1 6,993

Index Scan using empresa_pkey on empresa e (cost=0.29..8.30 rows=1 width=22) (actual time=0.003..0.004 rows=1 loops=6,993)

  • Index Cond: (emp_codigo = 758)
13. 34.965 34.965 ↑ 1.0 1 6,993

Index Scan using configuracao_pkey on configuracao c (cost=0.29..8.30 rows=1 width=8) (actual time=0.004..0.005 rows=1 loops=6,993)

  • Index Cond: (conf_codigo = e.conf_codigo)
14. 195.804 195.804 ↑ 1.0 1 6,993

Index Scan using pk_nfe_destinatario on nfe_destinatario nd (cost=0.42..0.48 rows=1 width=76) (actual time=0.028..0.028 rows=1 loops=6,993)

  • Index Cond: (((cnpj_emitente)::text = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND ((mod)::text = (n.mod)::text))
15. 188.811 188.811 ↑ 1.0 1 6,993

Index Scan using pk_nfe_transp on nfe_transp nt (cost=0.42..0.47 rows=1 width=51) (actual time=0.027..0.027 rows=1 loops=6,993)

  • Index Cond: (((cnpj_emitente)::text = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND ((mod)::text = (n.mod)::text))
16.          

SubPlan (for Nested Loop Left Join)

17. 0.354 4.956 ↑ 1.0 1 177

Aggregate (cost=16.91..16.92 rows=1 width=0) (actual time=0.028..0.028 rows=1 loops=177)

18. 0.372 4.602 ↓ 0.0 0 177

Nested Loop (cost=0.83..16.91 rows=1 width=0) (actual time=0.026..0.026 rows=0 loops=177)

  • Join Filter: (((nev.eve_tipo_evento)::text = (nevd.eve_tipo_evento)::text) AND (nev.eve_nseq_evento = nevd.eve_nseq_evento))
19. 3.894 3.894 ↓ 0.0 0 177

Index Only Scan using pk_nfe_evento on nfe_evento nev (cost=0.42..8.45 rows=1 width=41) (actual time=0.022..0.022 rows=0 loops=177)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
20. 0.336 0.336 ↑ 1.0 1 14

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd (cost=0.42..8.45 rows=1 width=41) (actual time=0.023..0.024 rows=1 loops=14)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 8
21. 0.014 0.658 ↑ 1.0 1 14

Limit (cost=0.83..16.91 rows=1 width=7) (actual time=0.047..0.047 rows=1 loops=14)

22. 0.042 0.644 ↑ 1.0 1 14

Nested Loop (cost=0.83..16.91 rows=1 width=7) (actual time=0.046..0.046 rows=1 loops=14)

  • Join Filter: (((nev_1.eve_tipo_evento)::text = (nevd_1.eve_tipo_evento)::text) AND (nev_1.eve_nseq_evento = nevd_1.eve_nseq_evento))
23. 0.308 0.308 ↑ 1.0 1 14

Index Only Scan using pk_nfe_evento on nfe_evento nev_1 (cost=0.42..8.45 rows=1 width=41) (actual time=0.022..0.022 rows=1 loops=14)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
24. 0.294 0.294 ↑ 1.0 1 14

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_1 (cost=0.42..8.45 rows=1 width=41) (actual time=0.021..0.021 rows=1 loops=14)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 8
25. 0.326 4.564 ↓ 0.0 0 163

Limit (cost=16.92..16.92 rows=1 width=15) (actual time=0.028..0.028 rows=0 loops=163)

26. 0.815 4.238 ↓ 0.0 0 163

Sort (cost=16.92..16.92 rows=1 width=15) (actual time=0.026..0.026 rows=0 loops=163)

  • Sort Key: nev_2.eve_dh_nfe_evento
  • Sort Method: quicksort Memory: 25kB
27. 0.326 3.423 ↓ 0.0 0 163

Nested Loop (cost=0.83..16.91 rows=1 width=15) (actual time=0.021..0.021 rows=0 loops=163)

  • Join Filter: (((nev_2.eve_tipo_evento)::text = (nevd_2.eve_tipo_evento)::text) AND (nev_2.eve_nseq_evento = nevd_2.eve_nseq_evento))
28. 3.097 3.097 ↓ 0.0 0 163

Index Scan using pk_nfe_evento on nfe_evento nev_2 (cost=0.42..8.45 rows=1 width=49) (actual time=0.019..0.019 rows=0 loops=163)

  • Index Cond: (((cnpj_emitente)::text = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND ((mod)::text = (n.mod)::text))
  • Filter: ((eve_tipo_evento)::text <> '210210'::text)
29. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_2 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
30. 0.163 3.423 ↑ 1.0 1 163

Aggregate (cost=16.91..16.92 rows=1 width=0) (actual time=0.021..0.021 rows=1 loops=163)

31. 0.326 3.260 ↓ 0.0 0 163

Nested Loop (cost=0.83..16.91 rows=1 width=0) (actual time=0.020..0.020 rows=0 loops=163)

  • Join Filter: (((nev_3.eve_tipo_evento)::text = (nevd_3.eve_tipo_evento)::text) AND (nev_3.eve_nseq_evento = nevd_3.eve_nseq_evento))
32. 2.934 2.934 ↓ 0.0 0 163

Index Only Scan using pk_nfe_evento on nfe_evento nev_3 (cost=0.42..8.45 rows=1 width=41) (actual time=0.018..0.018 rows=0 loops=163)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
33. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_3 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
34. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.83..16.91 rows=1 width=7) (never executed)

35. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..16.91 rows=1 width=7) (never executed)

  • Join Filter: (((nev_4.eve_tipo_evento)::text = (nevd_4.eve_tipo_evento)::text) AND (nev_4.eve_nseq_evento = nevd_4.eve_nseq_evento))
36. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento on nfe_evento nev_4 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
37. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_4 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
38. 0.163 3.912 ↓ 0.0 0 163

Limit (cost=16.92..16.92 rows=1 width=15) (actual time=0.024..0.024 rows=0 loops=163)

39. 0.489 3.749 ↓ 0.0 0 163

Sort (cost=16.92..16.92 rows=1 width=15) (actual time=0.023..0.023 rows=0 loops=163)

  • Sort Key: nev_5.eve_dh_nfe_evento
  • Sort Method: quicksort Memory: 25kB
40. 0.163 3.260 ↓ 0.0 0 163

Nested Loop (cost=0.83..16.91 rows=1 width=15) (actual time=0.020..0.020 rows=0 loops=163)

  • Join Filter: (((nev_5.eve_tipo_evento)::text = (nevd_5.eve_tipo_evento)::text) AND (nev_5.eve_nseq_evento = nevd_5.eve_nseq_evento))
41. 3.097 3.097 ↓ 0.0 0 163

Index Scan using pk_nfe_evento on nfe_evento nev_5 (cost=0.42..8.45 rows=1 width=49) (actual time=0.019..0.019 rows=0 loops=163)

  • Index Cond: (((cnpj_emitente)::text = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND ((mod)::text = (n.mod)::text))
  • Filter: ((eve_tipo_evento)::text <> '210210'::text)
42. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_5 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
43. 0.163 3.423 ↑ 1.0 1 163

Aggregate (cost=16.91..16.92 rows=1 width=0) (actual time=0.021..0.021 rows=1 loops=163)

44. 0.163 3.260 ↓ 0.0 0 163

Nested Loop (cost=0.83..16.91 rows=1 width=0) (actual time=0.020..0.020 rows=0 loops=163)

  • Join Filter: (((nev_6.eve_tipo_evento)::text = (nevd_6.eve_tipo_evento)::text) AND (nev_6.eve_nseq_evento = nevd_6.eve_nseq_evento))
45. 3.097 3.097 ↓ 0.0 0 163

Index Only Scan using pk_nfe_evento on nfe_evento nev_6 (cost=0.42..8.45 rows=1 width=41) (actual time=0.019..0.019 rows=0 loops=163)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
46. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_6 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
47. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.83..16.91 rows=1 width=7) (never executed)

48. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..16.91 rows=1 width=7) (never executed)

  • Join Filter: (((nev_7.eve_tipo_evento)::text = (nevd_7.eve_tipo_evento)::text) AND (nev_7.eve_nseq_evento = nevd_7.eve_nseq_evento))
49. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento on nfe_evento nev_7 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
50. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_7 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
51. 0.163 3.912 ↓ 0.0 0 163

Limit (cost=16.92..16.92 rows=1 width=15) (actual time=0.024..0.024 rows=0 loops=163)

52. 0.489 3.749 ↓ 0.0 0 163

Sort (cost=16.92..16.92 rows=1 width=15) (actual time=0.023..0.023 rows=0 loops=163)

  • Sort Key: nev_8.eve_dh_nfe_evento
  • Sort Method: quicksort Memory: 25kB
53. 0.163 3.260 ↓ 0.0 0 163

Nested Loop (cost=0.83..16.91 rows=1 width=15) (actual time=0.020..0.020 rows=0 loops=163)

  • Join Filter: (((nev_8.eve_tipo_evento)::text = (nevd_8.eve_tipo_evento)::text) AND (nev_8.eve_nseq_evento = nevd_8.eve_nseq_evento))
54. 3.097 3.097 ↓ 0.0 0 163

Index Scan using pk_nfe_evento on nfe_evento nev_8 (cost=0.42..8.45 rows=1 width=49) (actual time=0.019..0.019 rows=0 loops=163)

  • Index Cond: (((cnpj_emitente)::text = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND ((mod)::text = (n.mod)::text))
  • Filter: ((eve_tipo_evento)::text <> '210210'::text)
55. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_8 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
56. 0.326 3.423 ↑ 1.0 1 163

Aggregate (cost=16.91..16.92 rows=1 width=0) (actual time=0.021..0.021 rows=1 loops=163)

57. 0.163 3.097 ↓ 0.0 0 163

Nested Loop (cost=0.83..16.91 rows=1 width=0) (actual time=0.019..0.019 rows=0 loops=163)

  • Join Filter: (((nev_9.eve_tipo_evento)::text = (nevd_9.eve_tipo_evento)::text) AND (nev_9.eve_nseq_evento = nevd_9.eve_nseq_evento))
58. 2.934 2.934 ↓ 0.0 0 163

Index Only Scan using pk_nfe_evento on nfe_evento nev_9 (cost=0.42..8.45 rows=1 width=41) (actual time=0.018..0.018 rows=0 loops=163)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
59. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_9 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
60. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.83..16.91 rows=1 width=7) (never executed)

61. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..16.91 rows=1 width=7) (never executed)

  • Join Filter: (((nev_10.eve_tipo_evento)::text = (nevd_10.eve_tipo_evento)::text) AND (nev_10.eve_nseq_evento = nevd_10.eve_nseq_evento))
62. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento on nfe_evento nev_10 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
63. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_10 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
64. 0.163 3.912 ↓ 0.0 0 163

Limit (cost=16.92..16.92 rows=1 width=15) (actual time=0.024..0.024 rows=0 loops=163)

65. 0.489 3.749 ↓ 0.0 0 163

Sort (cost=16.92..16.92 rows=1 width=15) (actual time=0.023..0.023 rows=0 loops=163)

  • Sort Key: nev_11.eve_dh_nfe_evento
  • Sort Method: quicksort Memory: 25kB
66. 0.163 3.260 ↓ 0.0 0 163

Nested Loop (cost=0.83..16.91 rows=1 width=15) (actual time=0.020..0.020 rows=0 loops=163)

  • Join Filter: (((nev_11.eve_tipo_evento)::text = (nevd_11.eve_tipo_evento)::text) AND (nev_11.eve_nseq_evento = nevd_11.eve_nseq_evento))
67. 3.097 3.097 ↓ 0.0 0 163

Index Scan using pk_nfe_evento on nfe_evento nev_11 (cost=0.42..8.45 rows=1 width=49) (actual time=0.019..0.019 rows=0 loops=163)

  • Index Cond: (((cnpj_emitente)::text = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND ((mod)::text = (n.mod)::text))
  • Filter: ((eve_tipo_evento)::text <> '210210'::text)
68. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_11 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
69. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=16.91..16.92 rows=1 width=0) (never executed)

70. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..16.91 rows=1 width=0) (never executed)

  • Join Filter: (((nev_12.eve_tipo_evento)::text = (nevd_12.eve_tipo_evento)::text) AND (nev_12.eve_nseq_evento = nevd_12.eve_nseq_evento))
71. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento on nfe_evento nev_12 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
72. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_12 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
73. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.83..16.91 rows=1 width=7) (never executed)

74. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..16.91 rows=1 width=7) (never executed)

  • Join Filter: (((nev_13.eve_tipo_evento)::text = (nevd_13.eve_tipo_evento)::text) AND (nev_13.eve_nseq_evento = nevd_13.eve_nseq_evento))
75. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento on nfe_evento nev_13 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
76. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_13 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
77. 0.000 0.000 ↓ 0.0 0

Limit (cost=16.92..16.92 rows=1 width=15) (never executed)

78. 0.000 0.000 ↓ 0.0 0

Sort (cost=16.92..16.92 rows=1 width=15) (never executed)

  • Sort Key: nev_14.eve_dh_nfe_evento
79. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..16.91 rows=1 width=15) (never executed)

  • Join Filter: (((nev_14.eve_tipo_evento)::text = (nevd_14.eve_tipo_evento)::text) AND (nev_14.eve_nseq_evento = nevd_14.eve_nseq_evento))
80. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_nfe_evento on nfe_evento nev_14 (cost=0.42..8.45 rows=1 width=49) (never executed)

  • Index Cond: (((cnpj_emitente)::text = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND ((mod)::text = (n.mod)::text))
  • Filter: ((eve_tipo_evento)::text <> '210210'::text)
81. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_14 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
82. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=16.91..16.92 rows=1 width=0) (never executed)

83. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..16.91 rows=1 width=0) (never executed)

  • Join Filter: (((nev_15.eve_tipo_evento)::text = (nevd_15.eve_tipo_evento)::text) AND (nev_15.eve_nseq_evento = nevd_15.eve_nseq_evento))
84. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento on nfe_evento nev_15 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
85. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_15 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
86. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.83..16.91 rows=1 width=7) (never executed)

87. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..16.91 rows=1 width=7) (never executed)

  • Join Filter: (((nev_16.eve_tipo_evento)::text = (nevd_16.eve_tipo_evento)::text) AND (nev_16.eve_nseq_evento = nevd_16.eve_nseq_evento))
88. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento on nfe_evento nev_16 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
89. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_16 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
90. 0.000 0.000 ↓ 0.0 0

Limit (cost=16.92..16.92 rows=1 width=15) (never executed)

91. 0.000 0.000 ↓ 0.0 0

Sort (cost=16.92..16.92 rows=1 width=15) (never executed)

  • Sort Key: nev_17.eve_dh_nfe_evento
92. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..16.91 rows=1 width=15) (never executed)

  • Join Filter: (((nev_17.eve_tipo_evento)::text = (nevd_17.eve_tipo_evento)::text) AND (nev_17.eve_nseq_evento = nevd_17.eve_nseq_evento))
93. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_nfe_evento on nfe_evento nev_17 (cost=0.42..8.45 rows=1 width=49) (never executed)

  • Index Cond: (((cnpj_emitente)::text = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND ((mod)::text = (n.mod)::text))
  • Filter: ((eve_tipo_evento)::text <> '210210'::text)
94. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_17 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
95. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=16.91..16.92 rows=1 width=0) (never executed)

96. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..16.91 rows=1 width=0) (never executed)

  • Join Filter: (((nev_18.eve_tipo_evento)::text = (nevd_18.eve_tipo_evento)::text) AND (nev_18.eve_nseq_evento = nevd_18.eve_nseq_evento))
97. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento on nfe_evento nev_18 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
98. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_18 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
99. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.83..16.91 rows=1 width=7) (never executed)

100. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..16.91 rows=1 width=7) (never executed)

  • Join Filter: (((nev_19.eve_tipo_evento)::text = (nevd_19.eve_tipo_evento)::text) AND (nev_19.eve_nseq_evento = nevd_19.eve_nseq_evento))
101. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento on nfe_evento nev_19 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
102. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_19 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
103. 0.000 0.000 ↓ 0.0 0

Limit (cost=16.92..16.92 rows=1 width=15) (never executed)

104. 0.000 0.000 ↓ 0.0 0

Sort (cost=16.92..16.92 rows=1 width=15) (never executed)

  • Sort Key: nev_20.eve_dh_nfe_evento
105. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..16.91 rows=1 width=15) (never executed)

  • Join Filter: (((nev_20.eve_tipo_evento)::text = (nevd_20.eve_tipo_evento)::text) AND (nev_20.eve_nseq_evento = nevd_20.eve_nseq_evento))
106. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_nfe_evento on nfe_evento nev_20 (cost=0.42..8.45 rows=1 width=49) (never executed)

  • Index Cond: (((cnpj_emitente)::text = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND ((mod)::text = (n.mod)::text))
  • Filter: ((eve_tipo_evento)::text <> '210210'::text)
107. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_20 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
108. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=16.91..16.92 rows=1 width=0) (never executed)

109. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..16.91 rows=1 width=0) (never executed)

  • Join Filter: (((nev_21.eve_tipo_evento)::text = (nevd_21.eve_tipo_evento)::text) AND (nev_21.eve_nseq_evento = nevd_21.eve_nseq_evento))
110. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento on nfe_evento nev_21 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
111. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_21 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
112. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.83..16.91 rows=1 width=7) (never executed)

113. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..16.91 rows=1 width=7) (never executed)

  • Join Filter: (((nev_22.eve_tipo_evento)::text = (nevd_22.eve_tipo_evento)::text) AND (nev_22.eve_nseq_evento = nevd_22.eve_nseq_evento))
114. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento on nfe_evento nev_22 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
115. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_22 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
116. 0.000 0.000 ↓ 0.0 0

Limit (cost=16.92..16.92 rows=1 width=15) (never executed)

117. 0.000 0.000 ↓ 0.0 0

Sort (cost=16.92..16.92 rows=1 width=15) (never executed)

  • Sort Key: nev_23.eve_dh_nfe_evento
118. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..16.91 rows=1 width=15) (never executed)

  • Join Filter: (((nev_23.eve_tipo_evento)::text = (nevd_23.eve_tipo_evento)::text) AND (nev_23.eve_nseq_evento = nevd_23.eve_nseq_evento))
119. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_nfe_evento on nfe_evento nev_23 (cost=0.42..8.45 rows=1 width=49) (never executed)

  • Index Cond: (((cnpj_emitente)::text = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND ((mod)::text = (n.mod)::text))
  • Filter: ((eve_tipo_evento)::text <> '210210'::text)
120. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_23 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
121. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=16.91..16.92 rows=1 width=0) (never executed)

122. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..16.91 rows=1 width=0) (never executed)

  • Join Filter: (((nev_24.eve_tipo_evento)::text = (nevd_24.eve_tipo_evento)::text) AND (nev_24.eve_nseq_evento = nevd_24.eve_nseq_evento))
123. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento on nfe_evento nev_24 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
124. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_24 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
125. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.83..16.91 rows=1 width=7) (never executed)

126. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..16.91 rows=1 width=7) (never executed)

  • Join Filter: (((nev_25.eve_tipo_evento)::text = (nevd_25.eve_tipo_evento)::text) AND (nev_25.eve_nseq_evento = nevd_25.eve_nseq_evento))
127. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento on nfe_evento nev_25 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
128. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_25 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
129. 0.000 0.000 ↓ 0.0 0

Limit (cost=16.92..16.92 rows=1 width=15) (never executed)

130. 0.000 0.000 ↓ 0.0 0

Sort (cost=16.92..16.92 rows=1 width=15) (never executed)

  • Sort Key: nev_26.eve_dh_nfe_evento
131. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..16.91 rows=1 width=15) (never executed)

  • Join Filter: (((nev_26.eve_tipo_evento)::text = (nevd_26.eve_tipo_evento)::text) AND (nev_26.eve_nseq_evento = nevd_26.eve_nseq_evento))
132. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_nfe_evento on nfe_evento nev_26 (cost=0.42..8.45 rows=1 width=49) (never executed)

  • Index Cond: (((cnpj_emitente)::text = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND ((mod)::text = (n.mod)::text))
  • Filter: ((eve_tipo_evento)::text <> '210210'::text)
133. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_26 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
134. 0.354 4.248 ↑ 1.0 1 177

Aggregate (cost=16.91..16.92 rows=1 width=0) (actual time=0.023..0.024 rows=1 loops=177)

135. 0.223 3.894 ↓ 0.0 0 177

Nested Loop (cost=0.83..16.91 rows=1 width=0) (actual time=0.022..0.022 rows=0 loops=177)

  • Join Filter: (((nev_27.eve_tipo_evento)::text = (nevd_27.eve_tipo_evento)::text) AND (nev_27.eve_nseq_evento = nevd_27.eve_nseq_evento))
136. 3.363 3.363 ↓ 0.0 0 177

Index Only Scan using pk_nfe_evento on nfe_evento nev_27 (cost=0.42..8.45 rows=1 width=41) (actual time=0.019..0.019 rows=0 loops=177)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
137. 0.308 0.308 ↑ 1.0 1 14

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_27 (cost=0.42..8.45 rows=1 width=41) (actual time=0.021..0.022 rows=1 loops=14)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 8
138. 0.014 0.658 ↑ 1.0 1 14

Limit (cost=0.83..16.91 rows=1 width=7) (actual time=0.047..0.047 rows=1 loops=14)

139. 0.056 0.644 ↑ 1.0 1 14

Nested Loop (cost=0.83..16.91 rows=1 width=7) (actual time=0.046..0.046 rows=1 loops=14)

  • Join Filter: (((nev_28.eve_tipo_evento)::text = (nevd_28.eve_tipo_evento)::text) AND (nev_28.eve_nseq_evento = nevd_28.eve_nseq_evento))
140. 0.294 0.294 ↑ 1.0 1 14

Index Only Scan using pk_nfe_evento on nfe_evento nev_28 (cost=0.42..8.45 rows=1 width=41) (actual time=0.021..0.021 rows=1 loops=14)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
141. 0.294 0.294 ↑ 1.0 1 14

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_28 (cost=0.42..8.45 rows=1 width=41) (actual time=0.021..0.021 rows=1 loops=14)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 8
142. 0.163 3.912 ↓ 0.0 0 163

Limit (cost=16.92..16.92 rows=1 width=15) (actual time=0.024..0.024 rows=0 loops=163)

143. 0.489 3.749 ↓ 0.0 0 163

Sort (cost=16.92..16.92 rows=1 width=15) (actual time=0.023..0.023 rows=0 loops=163)

  • Sort Key: nev_29.eve_dh_nfe_evento
  • Sort Method: quicksort Memory: 25kB
144. 0.163 3.260 ↓ 0.0 0 163

Nested Loop (cost=0.83..16.91 rows=1 width=15) (actual time=0.020..0.020 rows=0 loops=163)

  • Join Filter: (((nev_29.eve_tipo_evento)::text = (nevd_29.eve_tipo_evento)::text) AND (nev_29.eve_nseq_evento = nevd_29.eve_nseq_evento))
145. 3.097 3.097 ↓ 0.0 0 163

Index Scan using pk_nfe_evento on nfe_evento nev_29 (cost=0.42..8.45 rows=1 width=49) (actual time=0.019..0.019 rows=0 loops=163)

  • Index Cond: (((cnpj_emitente)::text = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND ((mod)::text = (n.mod)::text))
  • Filter: ((eve_tipo_evento)::text <> '210210'::text)
146. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_29 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
147. 0.163 3.260 ↑ 1.0 1 163

Aggregate (cost=16.91..16.92 rows=1 width=0) (actual time=0.020..0.020 rows=1 loops=163)

148. 0.163 3.097 ↓ 0.0 0 163

Nested Loop (cost=0.83..16.91 rows=1 width=0) (actual time=0.019..0.019 rows=0 loops=163)

  • Join Filter: (((nev_30.eve_tipo_evento)::text = (nevd_30.eve_tipo_evento)::text) AND (nev_30.eve_nseq_evento = nevd_30.eve_nseq_evento))
149. 2.934 2.934 ↓ 0.0 0 163

Index Only Scan using pk_nfe_evento on nfe_evento nev_30 (cost=0.42..8.45 rows=1 width=41) (actual time=0.018..0.018 rows=0 loops=163)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
150. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_30 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
151. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.83..16.91 rows=1 width=7) (never executed)

152. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..16.91 rows=1 width=7) (never executed)

  • Join Filter: (((nev_31.eve_tipo_evento)::text = (nevd_31.eve_tipo_evento)::text) AND (nev_31.eve_nseq_evento = nevd_31.eve_nseq_evento))
153. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento on nfe_evento nev_31 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
154. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_31 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
155. 0.163 3.912 ↓ 0.0 0 163

Limit (cost=16.92..16.92 rows=1 width=15) (actual time=0.024..0.024 rows=0 loops=163)

156. 0.489 3.749 ↓ 0.0 0 163

Sort (cost=16.92..16.92 rows=1 width=15) (actual time=0.023..0.023 rows=0 loops=163)

  • Sort Key: nev_32.eve_dh_nfe_evento
  • Sort Method: quicksort Memory: 25kB
157. 0.163 3.260 ↓ 0.0 0 163

Nested Loop (cost=0.83..16.91 rows=1 width=15) (actual time=0.020..0.020 rows=0 loops=163)

  • Join Filter: (((nev_32.eve_tipo_evento)::text = (nevd_32.eve_tipo_evento)::text) AND (nev_32.eve_nseq_evento = nevd_32.eve_nseq_evento))
158. 3.097 3.097 ↓ 0.0 0 163

Index Scan using pk_nfe_evento on nfe_evento nev_32 (cost=0.42..8.45 rows=1 width=49) (actual time=0.019..0.019 rows=0 loops=163)

  • Index Cond: (((cnpj_emitente)::text = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND ((mod)::text = (n.mod)::text))
  • Filter: ((eve_tipo_evento)::text <> '210210'::text)
159. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_32 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
160. 0.326 3.423 ↑ 1.0 1 163

Aggregate (cost=16.91..16.92 rows=1 width=0) (actual time=0.021..0.021 rows=1 loops=163)

161. 0.163 3.097 ↓ 0.0 0 163

Nested Loop (cost=0.83..16.91 rows=1 width=0) (actual time=0.019..0.019 rows=0 loops=163)

  • Join Filter: (((nev_33.eve_tipo_evento)::text = (nevd_33.eve_tipo_evento)::text) AND (nev_33.eve_nseq_evento = nevd_33.eve_nseq_evento))
162. 2.934 2.934 ↓ 0.0 0 163

Index Only Scan using pk_nfe_evento on nfe_evento nev_33 (cost=0.42..8.45 rows=1 width=41) (actual time=0.018..0.018 rows=0 loops=163)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
163. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_33 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
164. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.83..16.91 rows=1 width=7) (never executed)

165. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..16.91 rows=1 width=7) (never executed)

  • Join Filter: (((nev_34.eve_tipo_evento)::text = (nevd_34.eve_tipo_evento)::text) AND (nev_34.eve_nseq_evento = nevd_34.eve_nseq_evento))
166. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento on nfe_evento nev_34 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
167. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_34 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
168. 0.163 3.912 ↓ 0.0 0 163

Limit (cost=16.92..16.92 rows=1 width=15) (actual time=0.024..0.024 rows=0 loops=163)

169. 0.489 3.749 ↓ 0.0 0 163

Sort (cost=16.92..16.92 rows=1 width=15) (actual time=0.023..0.023 rows=0 loops=163)

  • Sort Key: nev_35.eve_dh_nfe_evento
  • Sort Method: quicksort Memory: 25kB
170. 0.163 3.260 ↓ 0.0 0 163

Nested Loop (cost=0.83..16.91 rows=1 width=15) (actual time=0.020..0.020 rows=0 loops=163)

  • Join Filter: (((nev_35.eve_tipo_evento)::text = (nevd_35.eve_tipo_evento)::text) AND (nev_35.eve_nseq_evento = nevd_35.eve_nseq_evento))
171. 3.097 3.097 ↓ 0.0 0 163

Index Scan using pk_nfe_evento on nfe_evento nev_35 (cost=0.42..8.45 rows=1 width=49) (actual time=0.019..0.019 rows=0 loops=163)

  • Index Cond: (((cnpj_emitente)::text = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND ((mod)::text = (n.mod)::text))
  • Filter: ((eve_tipo_evento)::text <> '210210'::text)
172. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_35 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
173. 0.326 3.423 ↑ 1.0 1 163

Aggregate (cost=16.91..16.92 rows=1 width=0) (actual time=0.020..0.021 rows=1 loops=163)

174. 0.163 3.097 ↓ 0.0 0 163

Nested Loop (cost=0.83..16.91 rows=1 width=0) (actual time=0.019..0.019 rows=0 loops=163)

  • Join Filter: (((nev_36.eve_tipo_evento)::text = (nevd_36.eve_tipo_evento)::text) AND (nev_36.eve_nseq_evento = nevd_36.eve_nseq_evento))
175. 2.934 2.934 ↓ 0.0 0 163

Index Only Scan using pk_nfe_evento on nfe_evento nev_36 (cost=0.42..8.45 rows=1 width=41) (actual time=0.018..0.018 rows=0 loops=163)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
176. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_36 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
177. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.83..16.91 rows=1 width=7) (never executed)

178. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..16.91 rows=1 width=7) (never executed)

  • Join Filter: (((nev_37.eve_tipo_evento)::text = (nevd_37.eve_tipo_evento)::text) AND (nev_37.eve_nseq_evento = nevd_37.eve_nseq_evento))
179. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento on nfe_evento nev_37 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
180. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_37 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
181. 0.163 3.912 ↓ 0.0 0 163

Limit (cost=16.92..16.92 rows=1 width=15) (actual time=0.024..0.024 rows=0 loops=163)

182. 0.489 3.749 ↓ 0.0 0 163

Sort (cost=16.92..16.92 rows=1 width=15) (actual time=0.023..0.023 rows=0 loops=163)

  • Sort Key: nev_38.eve_dh_nfe_evento
  • Sort Method: quicksort Memory: 25kB
183. 0.163 3.260 ↓ 0.0 0 163

Nested Loop (cost=0.83..16.91 rows=1 width=15) (actual time=0.020..0.020 rows=0 loops=163)

  • Join Filter: (((nev_38.eve_tipo_evento)::text = (nevd_38.eve_tipo_evento)::text) AND (nev_38.eve_nseq_evento = nevd_38.eve_nseq_evento))
184. 3.097 3.097 ↓ 0.0 0 163

Index Scan using pk_nfe_evento on nfe_evento nev_38 (cost=0.42..8.45 rows=1 width=49) (actual time=0.019..0.019 rows=0 loops=163)

  • Index Cond: (((cnpj_emitente)::text = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND ((mod)::text = (n.mod)::text))
  • Filter: ((eve_tipo_evento)::text <> '210210'::text)
185. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_38 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
186. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=16.91..16.92 rows=1 width=0) (never executed)

187. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..16.91 rows=1 width=0) (never executed)

  • Join Filter: (((nev_39.eve_tipo_evento)::text = (nevd_39.eve_tipo_evento)::text) AND (nev_39.eve_nseq_evento = nevd_39.eve_nseq_evento))
188. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento on nfe_evento nev_39 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
189. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_39 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
190. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.83..16.91 rows=1 width=7) (never executed)

191. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..16.91 rows=1 width=7) (never executed)

  • Join Filter: (((nev_40.eve_tipo_evento)::text = (nevd_40.eve_tipo_evento)::text) AND (nev_40.eve_nseq_evento = nevd_40.eve_nseq_evento))
192. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento on nfe_evento nev_40 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
193. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_40 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
194. 0.000 0.000 ↓ 0.0 0

Limit (cost=16.92..16.92 rows=1 width=15) (never executed)

195. 0.000 0.000 ↓ 0.0 0

Sort (cost=16.92..16.92 rows=1 width=15) (never executed)

  • Sort Key: nev_41.eve_dh_nfe_evento
196. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..16.91 rows=1 width=15) (never executed)

  • Join Filter: (((nev_41.eve_tipo_evento)::text = (nevd_41.eve_tipo_evento)::text) AND (nev_41.eve_nseq_evento = nevd_41.eve_nseq_evento))
197. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_nfe_evento on nfe_evento nev_41 (cost=0.42..8.45 rows=1 width=49) (never executed)

  • Index Cond: (((cnpj_emitente)::text = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND ((mod)::text = (n.mod)::text))
  • Filter: ((eve_tipo_evento)::text <> '210210'::text)
198. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_41 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
199. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=16.91..16.92 rows=1 width=0) (never executed)

200. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..16.91 rows=1 width=0) (never executed)

  • Join Filter: (((nev_42.eve_tipo_evento)::text = (nevd_42.eve_tipo_evento)::text) AND (nev_42.eve_nseq_evento = nevd_42.eve_nseq_evento))
201. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento on nfe_evento nev_42 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
202. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_42 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
203. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.83..16.91 rows=1 width=7) (never executed)

204. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..16.91 rows=1 width=7) (never executed)

  • Join Filter: (((nev_43.eve_tipo_evento)::text = (nevd_43.eve_tipo_evento)::text) AND (nev_43.eve_nseq_evento = nevd_43.eve_nseq_evento))
205. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento on nfe_evento nev_43 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
206. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_43 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
207. 0.000 0.000 ↓ 0.0 0

Limit (cost=16.92..16.92 rows=1 width=15) (never executed)

208. 0.000 0.000 ↓ 0.0 0

Sort (cost=16.92..16.92 rows=1 width=15) (never executed)

  • Sort Key: nev_44.eve_dh_nfe_evento
209. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..16.91 rows=1 width=15) (never executed)

  • Join Filter: (((nev_44.eve_tipo_evento)::text = (nevd_44.eve_tipo_evento)::text) AND (nev_44.eve_nseq_evento = nevd_44.eve_nseq_evento))
210. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_nfe_evento on nfe_evento nev_44 (cost=0.42..8.45 rows=1 width=49) (never executed)

  • Index Cond: (((cnpj_emitente)::text = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND ((mod)::text = (n.mod)::text))
  • Filter: ((eve_tipo_evento)::text <> '210210'::text)
211. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_44 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
212. 0.177 4.071 ↑ 1.0 1 177

Aggregate (cost=16.91..16.92 rows=1 width=0) (actual time=0.023..0.023 rows=1 loops=177)

213. 0.237 3.894 ↓ 0.0 0 177

Nested Loop (cost=0.83..16.91 rows=1 width=0) (actual time=0.022..0.022 rows=0 loops=177)

  • Join Filter: (((nev_45.eve_tipo_evento)::text = (nevd_45.eve_tipo_evento)::text) AND (nev_45.eve_nseq_evento = nevd_45.eve_nseq_evento))
214. 3.363 3.363 ↓ 0.0 0 177

Index Only Scan using pk_nfe_evento on nfe_evento nev_45 (cost=0.42..8.45 rows=1 width=41) (actual time=0.019..0.019 rows=0 loops=177)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
215. 0.294 0.294 ↑ 1.0 1 14

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_45 (cost=0.42..8.45 rows=1 width=41) (actual time=0.021..0.021 rows=1 loops=14)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 8
216. 0.014 0.700 ↑ 1.0 1 14

Limit (cost=0.83..16.91 rows=1 width=7) (actual time=0.050..0.050 rows=1 loops=14)

217. 0.084 0.686 ↑ 1.0 1 14

Nested Loop (cost=0.83..16.91 rows=1 width=7) (actual time=0.049..0.049 rows=1 loops=14)

  • Join Filter: (((nev_46.eve_tipo_evento)::text = (nevd_46.eve_tipo_evento)::text) AND (nev_46.eve_nseq_evento = nevd_46.eve_nseq_evento))
218. 0.308 0.308 ↑ 1.0 1 14

Index Only Scan using pk_nfe_evento on nfe_evento nev_46 (cost=0.42..8.45 rows=1 width=41) (actual time=0.022..0.022 rows=1 loops=14)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
219. 0.294 0.294 ↑ 1.0 1 14

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_46 (cost=0.42..8.45 rows=1 width=41) (actual time=0.021..0.021 rows=1 loops=14)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 8
220. 0.163 3.912 ↓ 0.0 0 163

Limit (cost=16.92..16.92 rows=1 width=15) (actual time=0.024..0.024 rows=0 loops=163)

221. 0.489 3.749 ↓ 0.0 0 163

Sort (cost=16.92..16.92 rows=1 width=15) (actual time=0.023..0.023 rows=0 loops=163)

  • Sort Key: nev_47.eve_dh_nfe_evento
  • Sort Method: quicksort Memory: 25kB
222. 0.163 3.260 ↓ 0.0 0 163

Nested Loop (cost=0.83..16.91 rows=1 width=15) (actual time=0.020..0.020 rows=0 loops=163)

  • Join Filter: (((nev_47.eve_tipo_evento)::text = (nevd_47.eve_tipo_evento)::text) AND (nev_47.eve_nseq_evento = nevd_47.eve_nseq_evento))
223. 3.097 3.097 ↓ 0.0 0 163

Index Scan using pk_nfe_evento on nfe_evento nev_47 (cost=0.42..8.45 rows=1 width=49) (actual time=0.019..0.019 rows=0 loops=163)

  • Index Cond: (((cnpj_emitente)::text = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND ((mod)::text = (n.mod)::text))
  • Filter: ((eve_tipo_evento)::text <> '210210'::text)
224. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_47 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
225. 0.163 3.423 ↑ 1.0 1 163

Aggregate (cost=16.91..16.92 rows=1 width=0) (actual time=0.021..0.021 rows=1 loops=163)

226. 0.163 3.260 ↓ 0.0 0 163

Nested Loop (cost=0.83..16.91 rows=1 width=0) (actual time=0.020..0.020 rows=0 loops=163)

  • Join Filter: (((nev_48.eve_tipo_evento)::text = (nevd_48.eve_tipo_evento)::text) AND (nev_48.eve_nseq_evento = nevd_48.eve_nseq_evento))
227. 3.097 3.097 ↓ 0.0 0 163

Index Only Scan using pk_nfe_evento on nfe_evento nev_48 (cost=0.42..8.45 rows=1 width=41) (actual time=0.019..0.019 rows=0 loops=163)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
228. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_48 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
229. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.83..16.91 rows=1 width=7) (never executed)

230. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..16.91 rows=1 width=7) (never executed)

  • Join Filter: (((nev_49.eve_tipo_evento)::text = (nevd_49.eve_tipo_evento)::text) AND (nev_49.eve_nseq_evento = nevd_49.eve_nseq_evento))
231. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento on nfe_evento nev_49 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
232. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_49 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
233. 0.326 3.912 ↓ 0.0 0 163

Limit (cost=16.92..16.92 rows=1 width=15) (actual time=0.024..0.024 rows=0 loops=163)

234. 0.326 3.586 ↓ 0.0 0 163

Sort (cost=16.92..16.92 rows=1 width=15) (actual time=0.022..0.022 rows=0 loops=163)

  • Sort Key: nev_50.eve_dh_nfe_evento
  • Sort Method: quicksort Memory: 25kB
235. 0.163 3.260 ↓ 0.0 0 163

Nested Loop (cost=0.83..16.91 rows=1 width=15) (actual time=0.020..0.020 rows=0 loops=163)

  • Join Filter: (((nev_50.eve_tipo_evento)::text = (nevd_50.eve_tipo_evento)::text) AND (nev_50.eve_nseq_evento = nevd_50.eve_nseq_evento))
236. 3.097 3.097 ↓ 0.0 0 163

Index Scan using pk_nfe_evento on nfe_evento nev_50 (cost=0.42..8.45 rows=1 width=49) (actual time=0.019..0.019 rows=0 loops=163)

  • Index Cond: (((cnpj_emitente)::text = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND ((mod)::text = (n.mod)::text))
  • Filter: ((eve_tipo_evento)::text <> '210210'::text)
237. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_50 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
238. 0.163 3.260 ↑ 1.0 1 163

Aggregate (cost=16.91..16.92 rows=1 width=0) (actual time=0.020..0.020 rows=1 loops=163)

239. 0.163 3.097 ↓ 0.0 0 163

Nested Loop (cost=0.83..16.91 rows=1 width=0) (actual time=0.019..0.019 rows=0 loops=163)

  • Join Filter: (((nev_51.eve_tipo_evento)::text = (nevd_51.eve_tipo_evento)::text) AND (nev_51.eve_nseq_evento = nevd_51.eve_nseq_evento))
240. 2.934 2.934 ↓ 0.0 0 163

Index Only Scan using pk_nfe_evento on nfe_evento nev_51 (cost=0.42..8.45 rows=1 width=41) (actual time=0.018..0.018 rows=0 loops=163)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
241. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_51 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
242. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.83..16.91 rows=1 width=7) (never executed)

243. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..16.91 rows=1 width=7) (never executed)

  • Join Filter: (((nev_52.eve_tipo_evento)::text = (nevd_52.eve_tipo_evento)::text) AND (nev_52.eve_nseq_evento = nevd_52.eve_nseq_evento))
244. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento on nfe_evento nev_52 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
245. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_52 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
246. 0.163 3.749 ↓ 0.0 0 163

Limit (cost=16.92..16.92 rows=1 width=15) (actual time=0.023..0.023 rows=0 loops=163)

247. 0.326 3.586 ↓ 0.0 0 163

Sort (cost=16.92..16.92 rows=1 width=15) (actual time=0.022..0.022 rows=0 loops=163)

  • Sort Key: nev_53.eve_dh_nfe_evento
  • Sort Method: quicksort Memory: 25kB
248. 0.163 3.260 ↓ 0.0 0 163

Nested Loop (cost=0.83..16.91 rows=1 width=15) (actual time=0.020..0.020 rows=0 loops=163)

  • Join Filter: (((nev_53.eve_tipo_evento)::text = (nevd_53.eve_tipo_evento)::text) AND (nev_53.eve_nseq_evento = nevd_53.eve_nseq_evento))
249. 3.097 3.097 ↓ 0.0 0 163

Index Scan using pk_nfe_evento on nfe_evento nev_53 (cost=0.42..8.45 rows=1 width=49) (actual time=0.019..0.019 rows=0 loops=163)

  • Index Cond: (((cnpj_emitente)::text = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND ((mod)::text = (n.mod)::text))
  • Filter: ((eve_tipo_evento)::text <> '210210'::text)
250. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_53 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
251. 0.326 3.423 ↑ 1.0 1 163

Aggregate (cost=16.91..16.92 rows=1 width=0) (actual time=0.021..0.021 rows=1 loops=163)

252. 0.000 3.097 ↓ 0.0 0 163

Nested Loop (cost=0.83..16.91 rows=1 width=0) (actual time=0.019..0.019 rows=0 loops=163)

  • Join Filter: (((nev_54.eve_tipo_evento)::text = (nevd_54.eve_tipo_evento)::text) AND (nev_54.eve_nseq_evento = nevd_54.eve_nseq_evento))
253. 3.097 3.097 ↓ 0.0 0 163

Index Only Scan using pk_nfe_evento on nfe_evento nev_54 (cost=0.42..8.45 rows=1 width=41) (actual time=0.019..0.019 rows=0 loops=163)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
254. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_54 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
255. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.83..16.91 rows=1 width=7) (never executed)

256. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..16.91 rows=1 width=7) (never executed)

  • Join Filter: (((nev_55.eve_tipo_evento)::text = (nevd_55.eve_tipo_evento)::text) AND (nev_55.eve_nseq_evento = nevd_55.eve_nseq_evento))
257. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento on nfe_evento nev_55 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
258. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_55 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
259. 0.163 3.912 ↓ 0.0 0 163

Limit (cost=16.92..16.92 rows=1 width=15) (actual time=0.024..0.024 rows=0 loops=163)

260. 0.489 3.749 ↓ 0.0 0 163

Sort (cost=16.92..16.92 rows=1 width=15) (actual time=0.023..0.023 rows=0 loops=163)

  • Sort Key: nev_56.eve_dh_nfe_evento
  • Sort Method: quicksort Memory: 25kB
261. 0.163 3.260 ↓ 0.0 0 163

Nested Loop (cost=0.83..16.91 rows=1 width=15) (actual time=0.020..0.020 rows=0 loops=163)

  • Join Filter: (((nev_56.eve_tipo_evento)::text = (nevd_56.eve_tipo_evento)::text) AND (nev_56.eve_nseq_evento = nevd_56.eve_nseq_evento))
262. 3.097 3.097 ↓ 0.0 0 163

Index Scan using pk_nfe_evento on nfe_evento nev_56 (cost=0.42..8.45 rows=1 width=49) (actual time=0.019..0.019 rows=0 loops=163)

  • Index Cond: (((cnpj_emitente)::text = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND ((mod)::text = (n.mod)::text))
  • Filter: ((eve_tipo_evento)::text <> '210210'::text)
263. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_56 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
264. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=16.91..16.92 rows=1 width=0) (never executed)

265. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..16.91 rows=1 width=0) (never executed)

  • Join Filter: (((nev_57.eve_tipo_evento)::text = (nevd_57.eve_tipo_evento)::text) AND (nev_57.eve_nseq_evento = nevd_57.eve_nseq_evento))
266. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento on nfe_evento nev_57 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
267. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_57 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
268. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.83..16.91 rows=1 width=7) (never executed)

269. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..16.91 rows=1 width=7) (never executed)

  • Join Filter: (((nev_58.eve_tipo_evento)::text = (nevd_58.eve_tipo_evento)::text) AND (nev_58.eve_nseq_evento = nevd_58.eve_nseq_evento))
270. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento on nfe_evento nev_58 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
271. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_58 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
272. 0.000 0.000 ↓ 0.0 0

Limit (cost=16.92..16.92 rows=1 width=15) (never executed)

273. 0.000 0.000 ↓ 0.0 0

Sort (cost=16.92..16.92 rows=1 width=15) (never executed)

  • Sort Key: nev_59.eve_dh_nfe_evento
274. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..16.91 rows=1 width=15) (never executed)

  • Join Filter: (((nev_59.eve_tipo_evento)::text = (nevd_59.eve_tipo_evento)::text) AND (nev_59.eve_nseq_evento = nevd_59.eve_nseq_evento))
275. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_nfe_evento on nfe_evento nev_59 (cost=0.42..8.45 rows=1 width=49) (never executed)

  • Index Cond: (((cnpj_emitente)::text = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND ((mod)::text = (n.mod)::text))
  • Filter: ((eve_tipo_evento)::text <> '210210'::text)
276. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_59 (cost=0.42..8.45 rows=1 width=41) (never executed)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 0
277. 20.979 552.447 ↑ 1.0 1 6,993

Aggregate (cost=16.91..16.92 rows=1 width=0) (actual time=0.079..0.079 rows=1 loops=6,993)

278. 26.873 531.468 ↑ 1.0 1 6,993

Nested Loop (cost=0.83..16.91 rows=1 width=0) (actual time=0.061..0.076 rows=1 loops=6,993)

  • Join Filter: (((nev_60.eve_tipo_evento)::text = (nevd_60.eve_tipo_evento)::text) AND (nev_60.eve_nseq_evento = nevd_60.eve_nseq_evento))
  • Rows Removed by Join Filter: 1
279. 216.783 216.783 ↑ 1.0 1 6,993

Index Only Scan using pk_nfe_evento on nfe_evento nev_60 (cost=0.42..8.45 rows=1 width=41) (actual time=0.030..0.031 rows=1 loops=6,993)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 1,110
280. 287.812 287.812 ↓ 2.0 2 10,279

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_60 (cost=0.42..8.45 rows=1 width=41) (actual time=0.028..0.028 rows=2 loops=10,279)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 87
281. 0.000 179.550 ↑ 1.0 1 3,325

Limit (cost=0.83..16.91 rows=1 width=7) (actual time=0.054..0.054 rows=1 loops=3,325)

282. 10.540 179.550 ↑ 1.0 1 3,325

Nested Loop (cost=0.83..16.91 rows=1 width=7) (actual time=0.054..0.054 rows=1 loops=3,325)

  • Join Filter: (((nev_61.eve_tipo_evento)::text = (nevd_61.eve_tipo_evento)::text) AND (nev_61.eve_nseq_evento = nevd_61.eve_nseq_evento))
  • Rows Removed by Join Filter: 0
283. 86.450 86.450 ↑ 1.0 1 3,325

Index Only Scan using pk_nfe_evento on nfe_evento nev_61 (cost=0.42..8.45 rows=1 width=41) (actual time=0.026..0.026 rows=1 loops=3,325)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 543
284. 82.560 82.560 ↑ 1.0 1 3,440

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_61 (cost=0.42..8.45 rows=1 width=41) (actual time=0.024..0.024 rows=1 loops=3,440)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 43
285. 7.336 256.760 ↑ 1.0 1 3,668

Limit (cost=16.92..16.92 rows=1 width=15) (actual time=0.070..0.070 rows=1 loops=3,668)

286. 22.008 249.424 ↑ 1.0 1 3,668

Sort (cost=16.92..16.92 rows=1 width=15) (actual time=0.068..0.068 rows=1 loops=3,668)

  • Sort Key: nev_62.eve_dh_nfe_evento
  • Sort Method: quicksort Memory: 25kB
287. 14.952 227.416 ↑ 1.0 1 3,668

Nested Loop (cost=0.83..16.91 rows=1 width=15) (actual time=0.059..0.062 rows=1 loops=3,668)

  • Join Filter: (((nev_62.eve_tipo_evento)::text = (nevd_62.eve_tipo_evento)::text) AND (nev_62.eve_nseq_evento = nevd_62.eve_nseq_evento))
  • Rows Removed by Join Filter: 1
288. 113.708 113.708 ↑ 1.0 1 3,668

Index Scan using pk_nfe_evento on nfe_evento nev_62 (cost=0.42..8.45 rows=1 width=49) (actual time=0.030..0.031 rows=1 loops=3,668)

  • Index Cond: (((cnpj_emitente)::text = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND ((mod)::text = (n.mod)::text))
  • Filter: ((eve_tipo_evento)::text <> '210210'::text)
  • Rows Removed by Filter: 1
289. 98.756 98.756 ↓ 2.0 2 3,527

Index Only Scan using pk_nfe_evento_manifesto_dest on nfe_evento_manifesto_dest nevd_62 (cost=0.42..8.45 rows=1 width=41) (actual time=0.027..0.028 rows=2 loops=3,527)

  • Index Cond: ((cnpj_emitente = (n.cnpj_emitente)::text) AND (numero = n.numero) AND (serie = n.serie) AND (tpamb = n.tpamb) AND (mod = (n.mod)::text))
  • Heap Fetches: 22