explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VuVT

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Merge Join (cost=0..0 rows=0 width=0) (never executed)

2. 0.000 0.000 ↓ 0.0

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

3. 0.000 0.000 ↓ 0.0

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

4. 0.000 0.000 ↓ 0.0

Merge Append (cost=0..0 rows=0 width=0) (never executed)

5. 0.000 0.000 ↓ 0.0

Index Scan using edge_hv_bus_cb_pkey on edge_hv_bus_cb rami (cost=0..0 rows=0 width=0) (never executed)

  • Filter: (tag_lst @> '{SCADA}'::character varying[])
6. 0.000 0.000 ↓ 0.0

Index Scan using edge_hv_bus_jun_pkey on edge_hv_bus_jun rami_1 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: (tag_lst @> '{SCADA}'::character varying[])
7. 0.000 0.000 ↓ 0.0

Index Scan using edge_hv_gen_ca_pkey on edge_hv_gen_ca rami_2 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: (tag_lst @> '{SCADA}'::character varying[])
8. 0.000 0.000 ↓ 0.0

Index Scan using edge_hv_hv_pri_cb_pkey on edge_hv_hv_pri_cb rami_3 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: (tag_lst @> '{SCADA}'::character varying[])
9. 0.000 0.000 ↓ 0.0

Index Scan using edge_hv_hv_sec_cb_pkey on edge_hv_hv_sec_cb rami_4 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: (tag_lst @> '{SCADA}'::character varying[])
10. 0.000 0.000 ↓ 0.0

Index Scan using edge_hv_hv_ter_cb_pkey on edge_hv_hv_ter_cb rami_5 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: (tag_lst @> '{SCADA}'::character varying[])
11. 0.000 0.000 ↓ 0.0

Index Scan using edge_hv_mv_pri_cb_pkey on edge_hv_mv_pri_cb rami_6 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: (tag_lst @> '{SCADA}'::character varying[])
12. 0.000 0.000 ↓ 0.0

Index Scan using edge_hv_mv_sec_cb_pkey on edge_hv_mv_sec_cb rami_7 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: (tag_lst @> '{SCADA}'::character varying[])
13. 0.000 0.000 ↓ 0.0

Index Scan using edge_hv_mv_ter_cb_pkey on edge_hv_mv_ter_cb rami_8 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: (tag_lst @> '{SCADA}'::character varying[])
14. 0.000 0.000 ↓ 0.0

Index Scan using edge_lv_bus_cb_pkey on edge_lv_bus_cb rami_9 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: (tag_lst @> '{SCADA}'::character varying[])
15. 0.000 0.000 ↓ 0.0

Index Scan using edge_lv_bus_jun_pkey on edge_lv_bus_jun rami_10 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: (tag_lst @> '{SCADA}'::character varying[])
16. 0.000 0.000 ↓ 0.0

Index Scan using edge_lv_del_str_co_pkey on edge_lv_del_str_co rami_11 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: (tag_lst @> '{SCADA}'::character varying[])
17. 0.000 0.000 ↓ 0.0

Index Scan using edge_lv_gen_ca_pkey on edge_lv_gen_ca rami_12 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: (tag_lst @> '{SCADA}'::character varying[])
18. 0.000 0.000 ↓ 0.0

Index Scan using edge_lv_lv_pri_cb_pkey on edge_lv_lv_pri_cb rami_13 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: (tag_lst @> '{SCADA}'::character varying[])
19. 0.000 0.000 ↓ 0.0

Index Scan using edge_lv_lv_sec_cb_pkey on edge_lv_lv_sec_cb rami_14 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: (tag_lst @> '{SCADA}'::character varying[])
20. 0.000 0.000 ↓ 0.0

Index Scan using edge_lv_lv_ter_cb_pkey on edge_lv_lv_ter_cb rami_15 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: (tag_lst @> '{SCADA}'::character varying[])
21. 0.000 0.000 ↓ 0.0

Index Scan using edge_lv_tmp_ca_pkey on edge_lv_tmp_ca rami_16 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: (tag_lst @> '{SCADA}'::character varying[])
22. 0.000 0.000 ↓ 0.0

Index Scan using edge_mv_bus_cb_pkey on edge_mv_bus_cb rami_17 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: (tag_lst @> '{SCADA}'::character varying[])
23. 0.000 0.000 ↓ 0.0

Index Scan using edge_mv_bus_jun_pkey on edge_mv_bus_jun rami_18 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: (tag_lst @> '{SCADA}'::character varying[])
24. 0.000 0.000 ↓ 0.0

Index Scan using edge_mv_gen_ca_pkey on edge_mv_gen_ca rami_19 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: (tag_lst @> '{SCADA}'::character varying[])
25. 0.000 0.000 ↓ 0.0

Index Scan using edge_mv_lv_pri_cb_pkey on edge_mv_lv_pri_cb rami_20 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: (tag_lst @> '{SCADA}'::character varying[])
26. 0.000 0.000 ↓ 0.0

Index Scan using edge_mv_lv_sec_cb_pkey on edge_mv_lv_sec_cb rami_21 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: (tag_lst @> '{SCADA}'::character varying[])
27. 0.000 0.000 ↓ 0.0

Index Scan using edge_mv_lv_ter_cb_pkey on edge_mv_lv_ter_cb rami_22 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: (tag_lst @> '{SCADA}'::character varying[])
28. 0.000 0.000 ↓ 0.0

Index Scan using edge_mv_mv_pri_cb_pkey on edge_mv_mv_pri_cb rami_23 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: (tag_lst @> '{SCADA}'::character varying[])
29. 0.000 0.000 ↓ 0.0

Index Scan using edge_mv_mv_sec_cb_pkey on edge_mv_mv_sec_cb rami_24 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: (tag_lst @> '{SCADA}'::character varying[])
30. 0.000 0.000 ↓ 0.0

Index Scan using edge_mv_mv_ter_cb_pkey on edge_mv_mv_ter_cb rami_25 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: (tag_lst @> '{SCADA}'::character varying[])
31. 0.000 0.000 ↓ 0.0

Index Scan using edge_lv_bus_cb_ns_parent_id_ns_parent_type_idx on edge_lv_bus_cb linee (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((ns_parent_id = rami.ns_parent_id) AND ((ns_parent_type)::text = (rami.ns_parent_type)::text))
  • Filter: (tag_lst @> '{SCADA}'::character varying[])
32. 0.000 0.000 ↓ 0.0

Append (cost=0..0 rows=0 width=0) (never executed)

33. 0.000 0.000 ↓ 0.0

Index Scan using node_hv_bor_no_type_scada_id_key on node_hv_bor_no nodi (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((type)::text = (rami.node_1_type)::text)
  • Filter: ((tag_lst @> '{SCADA}'::character varying[]) AND (rami.node_1_id = id))
34. 0.000 0.000 ↓ 0.0

Index Scan using node_hv_busbar_pkey on node_hv_busbar nodi_1 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((id = rami.node_1_id) AND ((type)::text = (rami.node_1_type)::text))
  • Filter: (tag_lst @> '{SCADA}'::character varying[])
35. 0.000 0.000 ↓ 0.0

Index Scan using node_hv_del_no_type_scada_id_key on node_hv_del_no nodi_2 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((type)::text = (rami.node_1_type)::text)
  • Filter: ((tag_lst @> '{SCADA}'::character varying[]) AND (rami.node_1_id = id))
36. 0.000 0.000 ↓ 0.0

Index Scan using node_hv_hv_tr_type_scada_id_key on node_hv_hv_tr nodi_3 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((type)::text = (rami.node_1_type)::text)
  • Filter: ((tag_lst @> '{SCADA}'::character varying[]) AND (rami.node_1_id = id))
37. 0.000 0.000 ↓ 0.0

Index Scan using node_hv_junc_pkey on node_hv_junc nodi_4 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((id = rami.node_1_id) AND ((type)::text = (rami.node_1_type)::text))
  • Filter: (tag_lst @> '{SCADA}'::character varying[])
38. 0.000 0.000 ↓ 0.0

Index Scan using node_hv_line_type_scada_id_key on node_hv_line nodi_5 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((type)::text = (rami.node_1_type)::text)
  • Filter: ((tag_lst @> '{SCADA}'::character varying[]) AND (rami.node_1_id = id))
39. 0.000 0.000 ↓ 0.0

Index Scan using node_hv_mv_tr_type_scada_id_key on node_hv_mv_tr nodi_6 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((type)::text = (rami.node_1_type)::text)
  • Filter: ((tag_lst @> '{SCADA}'::character varying[]) AND (rami.node_1_id = id))
40. 0.000 0.000 ↓ 0.0

Index Scan using node_hv_rig_no_pkey on node_hv_rig_no nodi_7 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((id = rami.node_1_id) AND ((type)::text = (rami.node_1_type)::text))
  • Filter: (tag_lst @> '{SCADA}'::character varying[])
41. 0.000 0.000 ↓ 0.0

Index Scan using node_lv_bor_no_type_scada_id_key on node_lv_bor_no nodi_8 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((type)::text = (rami.node_1_type)::text)
  • Filter: ((tag_lst @> '{SCADA}'::character varying[]) AND (rami.node_1_id = id))
42. 0.000 0.000 ↓ 0.0

Index Scan using node_lv_busbar_pkey on node_lv_busbar nodi_9 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((id = rami.node_1_id) AND ((type)::text = (rami.node_1_type)::text))
  • Filter: (tag_lst @> '{SCADA}'::character varying[])
43. 0.000 0.000 ↓ 0.0

Index Scan using node_lv_com_no_type_scada_id_key on node_lv_com_no nodi_10 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((type)::text = (rami.node_1_type)::text)
  • Filter: ((tag_lst @> '{SCADA}'::character varying[]) AND (rami.node_1_id = id))
44. 0.000 0.000 ↓ 0.0

Index Scan using node_lv_conn_li_pkey on node_lv_conn_li nodi_11 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((id = rami.node_1_id) AND ((type)::text = (rami.node_1_type)::text))
  • Filter: (tag_lst @> '{SCADA}'::character varying[])
45. 0.000 0.000 ↓ 0.0

Index Scan using node_lv_del_no_pkey on node_lv_del_no nodi_12 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((id = rami.node_1_id) AND ((type)::text = (rami.node_1_type)::text))
  • Filter: (tag_lst @> '{SCADA}'::character varying[])
46. 0.000 0.000 ↓ 0.0

Index Scan using node_lv_junc_type_scada_id_key on node_lv_junc nodi_13 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((type)::text = (rami.node_1_type)::text)
  • Filter: ((tag_lst @> '{SCADA}'::character varying[]) AND (rami.node_1_id = id))
47. 0.000 0.000 ↓ 0.0

Index Scan using node_lv_lay_ch_type_scada_id_key on node_lv_lay_ch nodi_14 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((type)::text = (rami.node_1_type)::text)
  • Filter: ((tag_lst @> '{SCADA}'::character varying[]) AND (rami.node_1_id = id))
48. 0.000 0.000 ↓ 0.0

Index Scan using node_lv_line_pkey on node_lv_line nodi_15 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((id = rami.node_1_id) AND ((type)::text = (rami.node_1_type)::text))
  • Filter: (tag_lst @> '{SCADA}'::character varying[])
49. 0.000 0.000 ↓ 0.0

Index Scan using node_lv_lv_tr_type_scada_id_key on node_lv_lv_tr nodi_16 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((type)::text = (rami.node_1_type)::text)
  • Filter: ((tag_lst @> '{SCADA}'::character varying[]) AND (rami.node_1_id = id))
50. 0.000 0.000 ↓ 0.0

Index Scan using node_lv_rig_no_pkey on node_lv_rig_no nodi_17 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((id = rami.node_1_id) AND ((type)::text = (rami.node_1_type)::text))
  • Filter: (tag_lst @> '{SCADA}'::character varying[])
51. 0.000 0.000 ↓ 0.0

Index Scan using node_lv_str_no_type_scada_id_key on node_lv_str_no nodi_18 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((type)::text = (rami.node_1_type)::text)
  • Filter: ((tag_lst @> '{SCADA}'::character varying[]) AND (rami.node_1_id = id))
52. 0.000 0.000 ↓ 0.0

Index Scan using node_mv_bor_no_type_scada_id_key on node_mv_bor_no nodi_19 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((type)::text = (rami.node_1_type)::text)
  • Filter: ((tag_lst @> '{SCADA}'::character varying[]) AND (rami.node_1_id = id))
53. 0.000 0.000 ↓ 0.0

Index Scan using node_mv_busbar_pkey on node_mv_busbar nodi_20 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((id = rami.node_1_id) AND ((type)::text = (rami.node_1_type)::text))
  • Filter: (tag_lst @> '{SCADA}'::character varying[])
54. 0.000 0.000 ↓ 0.0

Index Scan using node_mv_del_no_pkey on node_mv_del_no nodi_21 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((id = rami.node_1_id) AND ((type)::text = (rami.node_1_type)::text))
  • Filter: (tag_lst @> '{SCADA}'::character varying[])
55. 0.000 0.000 ↓ 0.0

Index Scan using node_mv_junc_type_scada_id_key on node_mv_junc nodi_22 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((type)::text = (rami.node_1_type)::text)
  • Filter: ((tag_lst @> '{SCADA}'::character varying[]) AND (rami.node_1_id = id))
56. 0.000 0.000 ↓ 0.0

Index Scan using node_mv_lay_ch_type_scada_id_key on node_mv_lay_ch nodi_23 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((type)::text = (rami.node_1_type)::text)
  • Filter: ((tag_lst @> '{SCADA}'::character varying[]) AND (rami.node_1_id = id))
57. 0.000 0.000 ↓ 0.0

Index Scan using node_mv_line_pkey on node_mv_line nodi_24 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((id = rami.node_1_id) AND ((type)::text = (rami.node_1_type)::text))
  • Filter: (tag_lst @> '{SCADA}'::character varying[])
58. 0.000 0.000 ↓ 0.0

Index Scan using node_mv_lv_tr_pkey on node_mv_lv_tr nodi_25 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((id = rami.node_1_id) AND ((type)::text = (rami.node_1_type)::text))
  • Filter: (tag_lst @> '{SCADA}'::character varying[])
59. 0.000 0.000 ↓ 0.0

Index Scan using node_mv_mv_tr_pkey on node_mv_mv_tr nodi_26 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((id = rami.node_1_id) AND ((type)::text = (rami.node_1_type)::text))
  • Filter: (tag_lst @> '{SCADA}'::character varying[])
60. 0.000 0.000 ↓ 0.0

Index Scan using node_mv_pole_st_type_scada_id_key on node_mv_pole_st nodi_27 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((type)::text = (rami.node_1_type)::text)
  • Filter: ((tag_lst @> '{SCADA}'::character varying[]) AND (rami.node_1_id = id))
61. 0.000 0.000 ↓ 0.0

Index Scan using node_mv_rig_no_pkey on node_mv_rig_no nodi_28 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((id = rami.node_1_id) AND ((type)::text = (rami.node_1_type)::text))
  • Filter: (tag_lst @> '{SCADA}'::character varying[])
62. 0.000 0.000 ↓ 0.0

Index Scan using node_pri_subst_pkey on node_pri_subst nodi_29 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((id = rami.node_1_id) AND ((type)::text = (rami.node_1_type)::text))
  • Filter: (tag_lst @> '{SCADA}'::character varying[])
63. 0.000 0.000 ↓ 0.0

Index Scan using node_sec_subst_pkey on node_sec_subst nodi_30 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: ((id = rami.node_1_id) AND ((type)::text = (rami.node_1_type)::text))
  • Filter: (tag_lst @> '{SCADA}'::character varying[])
64. 0.000 0.000 ↓ 0.0

Materialize (cost=0..0 rows=0 width=0) (never executed)

65. 0.000 0.000 ↓ 0.0

Sort (cost=0..0 rows=0 width=0) (never executed)

  • Sort Key: md5.table_id
66. 0.000 0.000 ↓ 0.0

Append (cost=0..0 rows=0 width=0) (never executed)

67. 0.000 0.000 ↓ 0.0

Seq Scan on md5_edge_lv_bus_cb md5 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: ((NOT db_rt) AND (action <> 'N'::network_config.md5_action) AND (((custom_attributes -> 'scada'::text))::text IS DISTINCT FROM 'false'::text) AND ((((custom_attributes -> 'conf'::text))::text IS DISTINCT FROM 'true'::text) OR (((custom_attributes -> 'conf_overlapping_tbl'::text))::text IS DISTINCT FROM 'true'::text)) AND (((table_name)::text = 'edge_lv_bus_cb'::text) OR ((table_name)::text = 'edge_lv_bus_jun'::text) OR ((table_name)::text = 'edge_lv_lv_pri_cb'::text) OR ((table_name)::text = 'edge_lv_lv_sec_cb'::text) OR ((table_name)::text = 'edge_lv_lv_ter_cb'::text) OR ((table_name)::text = 'edge_mv_lv_pri_cb'::text) OR ((table_name)::text = 'edge_mv_lv_sec_cb'::text) OR ((table_name)::text = 'edge_mv_lv_ter_cb'::text) OR ((table_name)::text = 'edge_lv_tmp_ca'::text) OR ((table_name)::text = 'edge_lv_gen_ca'::text) OR ((table_name)::text = 'edge_lv_del_str_co'::text)))
68. 0.000 0.000 ↓ 0.0

Seq Scan on md5_edge_lv_bus_jun md5_1 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: ((NOT db_rt) AND (action <> 'N'::network_config.md5_action) AND (((custom_attributes -> 'scada'::text))::text IS DISTINCT FROM 'false'::text) AND ((((custom_attributes -> 'conf'::text))::text IS DISTINCT FROM 'true'::text) OR (((custom_attributes -> 'conf_overlapping_tbl'::text))::text IS DISTINCT FROM 'true'::text)) AND (((table_name)::text = 'edge_lv_bus_cb'::text) OR ((table_name)::text = 'edge_lv_bus_jun'::text) OR ((table_name)::text = 'edge_lv_lv_pri_cb'::text) OR ((table_name)::text = 'edge_lv_lv_sec_cb'::text) OR ((table_name)::text = 'edge_lv_lv_ter_cb'::text) OR ((table_name)::text = 'edge_mv_lv_pri_cb'::text) OR ((table_name)::text = 'edge_mv_lv_sec_cb'::text) OR ((table_name)::text = 'edge_mv_lv_ter_cb'::text) OR ((table_name)::text = 'edge_lv_tmp_ca'::text) OR ((table_name)::text = 'edge_lv_gen_ca'::text) OR ((table_name)::text = 'edge_lv_del_str_co'::text)))
69. 0.000 0.000 ↓ 0.0

Seq Scan on md5_edge_lv_del_str_co md5_2 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: ((NOT db_rt) AND (action <> 'N'::network_config.md5_action) AND (((custom_attributes -> 'scada'::text))::text IS DISTINCT FROM 'false'::text) AND ((((custom_attributes -> 'conf'::text))::text IS DISTINCT FROM 'true'::text) OR (((custom_attributes -> 'conf_overlapping_tbl'::text))::text IS DISTINCT FROM 'true'::text)) AND (((table_name)::text = 'edge_lv_bus_cb'::text) OR ((table_name)::text = 'edge_lv_bus_jun'::text) OR ((table_name)::text = 'edge_lv_lv_pri_cb'::text) OR ((table_name)::text = 'edge_lv_lv_sec_cb'::text) OR ((table_name)::text = 'edge_lv_lv_ter_cb'::text) OR ((table_name)::text = 'edge_mv_lv_pri_cb'::text) OR ((table_name)::text = 'edge_mv_lv_sec_cb'::text) OR ((table_name)::text = 'edge_mv_lv_ter_cb'::text) OR ((table_name)::text = 'edge_lv_tmp_ca'::text) OR ((table_name)::text = 'edge_lv_gen_ca'::text) OR ((table_name)::text = 'edge_lv_del_str_co'::text)))
70. 0.000 0.000 ↓ 0.0

Seq Scan on md5_edge_lv_gen_ca md5_3 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: ((NOT db_rt) AND (action <> 'N'::network_config.md5_action) AND (((custom_attributes -> 'scada'::text))::text IS DISTINCT FROM 'false'::text) AND ((((custom_attributes -> 'conf'::text))::text IS DISTINCT FROM 'true'::text) OR (((custom_attributes -> 'conf_overlapping_tbl'::text))::text IS DISTINCT FROM 'true'::text)) AND (((table_name)::text = 'edge_lv_bus_cb'::text) OR ((table_name)::text = 'edge_lv_bus_jun'::text) OR ((table_name)::text = 'edge_lv_lv_pri_cb'::text) OR ((table_name)::text = 'edge_lv_lv_sec_cb'::text) OR ((table_name)::text = 'edge_lv_lv_ter_cb'::text) OR ((table_name)::text = 'edge_mv_lv_pri_cb'::text) OR ((table_name)::text = 'edge_mv_lv_sec_cb'::text) OR ((table_name)::text = 'edge_mv_lv_ter_cb'::text) OR ((table_name)::text = 'edge_lv_tmp_ca'::text) OR ((table_name)::text = 'edge_lv_gen_ca'::text) OR ((table_name)::text = 'edge_lv_del_str_co'::text)))
71. 0.000 0.000 ↓ 0.0

Seq Scan on md5_edge_lv_lv_pri_cb md5_4 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: ((NOT db_rt) AND (action <> 'N'::network_config.md5_action) AND (((custom_attributes -> 'scada'::text))::text IS DISTINCT FROM 'false'::text) AND ((((custom_attributes -> 'conf'::text))::text IS DISTINCT FROM 'true'::text) OR (((custom_attributes -> 'conf_overlapping_tbl'::text))::text IS DISTINCT FROM 'true'::text)) AND (((table_name)::text = 'edge_lv_bus_cb'::text) OR ((table_name)::text = 'edge_lv_bus_jun'::text) OR ((table_name)::text = 'edge_lv_lv_pri_cb'::text) OR ((table_name)::text = 'edge_lv_lv_sec_cb'::text) OR ((table_name)::text = 'edge_lv_lv_ter_cb'::text) OR ((table_name)::text = 'edge_mv_lv_pri_cb'::text) OR ((table_name)::text = 'edge_mv_lv_sec_cb'::text) OR ((table_name)::text = 'edge_mv_lv_ter_cb'::text) OR ((table_name)::text = 'edge_lv_tmp_ca'::text) OR ((table_name)::text = 'edge_lv_gen_ca'::text) OR ((table_name)::text = 'edge_lv_del_str_co'::text)))
72. 0.000 0.000 ↓ 0.0

Seq Scan on md5_edge_lv_lv_sec_cb md5_5 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: ((NOT db_rt) AND (action <> 'N'::network_config.md5_action) AND (((custom_attributes -> 'scada'::text))::text IS DISTINCT FROM 'false'::text) AND ((((custom_attributes -> 'conf'::text))::text IS DISTINCT FROM 'true'::text) OR (((custom_attributes -> 'conf_overlapping_tbl'::text))::text IS DISTINCT FROM 'true'::text)) AND (((table_name)::text = 'edge_lv_bus_cb'::text) OR ((table_name)::text = 'edge_lv_bus_jun'::text) OR ((table_name)::text = 'edge_lv_lv_pri_cb'::text) OR ((table_name)::text = 'edge_lv_lv_sec_cb'::text) OR ((table_name)::text = 'edge_lv_lv_ter_cb'::text) OR ((table_name)::text = 'edge_mv_lv_pri_cb'::text) OR ((table_name)::text = 'edge_mv_lv_sec_cb'::text) OR ((table_name)::text = 'edge_mv_lv_ter_cb'::text) OR ((table_name)::text = 'edge_lv_tmp_ca'::text) OR ((table_name)::text = 'edge_lv_gen_ca'::text) OR ((table_name)::text = 'edge_lv_del_str_co'::text)))
73. 0.000 0.000 ↓ 0.0

Seq Scan on md5_edge_lv_lv_ter_cb md5_6 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: ((NOT db_rt) AND (action <> 'N'::network_config.md5_action) AND (((custom_attributes -> 'scada'::text))::text IS DISTINCT FROM 'false'::text) AND ((((custom_attributes -> 'conf'::text))::text IS DISTINCT FROM 'true'::text) OR (((custom_attributes -> 'conf_overlapping_tbl'::text))::text IS DISTINCT FROM 'true'::text)) AND (((table_name)::text = 'edge_lv_bus_cb'::text) OR ((table_name)::text = 'edge_lv_bus_jun'::text) OR ((table_name)::text = 'edge_lv_lv_pri_cb'::text) OR ((table_name)::text = 'edge_lv_lv_sec_cb'::text) OR ((table_name)::text = 'edge_lv_lv_ter_cb'::text) OR ((table_name)::text = 'edge_mv_lv_pri_cb'::text) OR ((table_name)::text = 'edge_mv_lv_sec_cb'::text) OR ((table_name)::text = 'edge_mv_lv_ter_cb'::text) OR ((table_name)::text = 'edge_lv_tmp_ca'::text) OR ((table_name)::text = 'edge_lv_gen_ca'::text) OR ((table_name)::text = 'edge_lv_del_str_co'::text)))
74. 0.000 0.000 ↓ 0.0

Seq Scan on md5_edge_lv_tmp_ca md5_7 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: ((NOT db_rt) AND (action <> 'N'::network_config.md5_action) AND (((custom_attributes -> 'scada'::text))::text IS DISTINCT FROM 'false'::text) AND ((((custom_attributes -> 'conf'::text))::text IS DISTINCT FROM 'true'::text) OR (((custom_attributes -> 'conf_overlapping_tbl'::text))::text IS DISTINCT FROM 'true'::text)) AND (((table_name)::text = 'edge_lv_bus_cb'::text) OR ((table_name)::text = 'edge_lv_bus_jun'::text) OR ((table_name)::text = 'edge_lv_lv_pri_cb'::text) OR ((table_name)::text = 'edge_lv_lv_sec_cb'::text) OR ((table_name)::text = 'edge_lv_lv_ter_cb'::text) OR ((table_name)::text = 'edge_mv_lv_pri_cb'::text) OR ((table_name)::text = 'edge_mv_lv_sec_cb'::text) OR ((table_name)::text = 'edge_mv_lv_ter_cb'::text) OR ((table_name)::text = 'edge_lv_tmp_ca'::text) OR ((table_name)::text = 'edge_lv_gen_ca'::text) OR ((table_name)::text = 'edge_lv_del_str_co'::text)))
75. 0.000 0.000 ↓ 0.0

Seq Scan on md5_edge_mv_lv_pri_cb md5_8 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: ((NOT db_rt) AND (action <> 'N'::network_config.md5_action) AND (((custom_attributes -> 'scada'::text))::text IS DISTINCT FROM 'false'::text) AND ((((custom_attributes -> 'conf'::text))::text IS DISTINCT FROM 'true'::text) OR (((custom_attributes -> 'conf_overlapping_tbl'::text))::text IS DISTINCT FROM 'true'::text)) AND (((table_name)::text = 'edge_lv_bus_cb'::text) OR ((table_name)::text = 'edge_lv_bus_jun'::text) OR ((table_name)::text = 'edge_lv_lv_pri_cb'::text) OR ((table_name)::text = 'edge_lv_lv_sec_cb'::text) OR ((table_name)::text = 'edge_lv_lv_ter_cb'::text) OR ((table_name)::text = 'edge_mv_lv_pri_cb'::text) OR ((table_name)::text = 'edge_mv_lv_sec_cb'::text) OR ((table_name)::text = 'edge_mv_lv_ter_cb'::text) OR ((table_name)::text = 'edge_lv_tmp_ca'::text) OR ((table_name)::text = 'edge_lv_gen_ca'::text) OR ((table_name)::text = 'edge_lv_del_str_co'::text)))
76. 0.000 0.000 ↓ 0.0

Seq Scan on md5_edge_mv_lv_sec_cb md5_9 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: ((NOT db_rt) AND (action <> 'N'::network_config.md5_action) AND (((custom_attributes -> 'scada'::text))::text IS DISTINCT FROM 'false'::text) AND ((((custom_attributes -> 'conf'::text))::text IS DISTINCT FROM 'true'::text) OR (((custom_attributes -> 'conf_overlapping_tbl'::text))::text IS DISTINCT FROM 'true'::text)) AND (((table_name)::text = 'edge_lv_bus_cb'::text) OR ((table_name)::text = 'edge_lv_bus_jun'::text) OR ((table_name)::text = 'edge_lv_lv_pri_cb'::text) OR ((table_name)::text = 'edge_lv_lv_sec_cb'::text) OR ((table_name)::text = 'edge_lv_lv_ter_cb'::text) OR ((table_name)::text = 'edge_mv_lv_pri_cb'::text) OR ((table_name)::text = 'edge_mv_lv_sec_cb'::text) OR ((table_name)::text = 'edge_mv_lv_ter_cb'::text) OR ((table_name)::text = 'edge_lv_tmp_ca'::text) OR ((table_name)::text = 'edge_lv_gen_ca'::text) OR ((table_name)::text = 'edge_lv_del_str_co'::text)))
77. 0.000 0.000 ↓ 0.0

Seq Scan on md5_edge_mv_lv_ter_cb md5_10 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: ((NOT db_rt) AND (action <> 'N'::network_config.md5_action) AND (((custom_attributes -> 'scada'::text))::text IS DISTINCT FROM 'false'::text) AND ((((custom_attributes -> 'conf'::text))::text IS DISTINCT FROM 'true'::text) OR (((custom_attributes -> 'conf_overlapping_tbl'::text))::text IS DISTINCT FROM 'true'::text)) AND (((table_name)::text = 'edge_lv_bus_cb'::text) OR ((table_name)::text = 'edge_lv_bus_jun'::text) OR ((table_name)::text = 'edge_lv_lv_pri_cb'::text) OR ((table_name)::text = 'edge_lv_lv_sec_cb'::text) OR ((table_name)::text = 'edge_lv_lv_ter_cb'::text) OR ((table_name)::text = 'edge_mv_lv_pri_cb'::text) OR ((table_name)::text = 'edge_mv_lv_sec_cb'::text) OR ((table_name)::text = 'edge_mv_lv_ter_cb'::text) OR ((table_name)::text = 'edge_lv_tmp_ca'::text) OR ((table_name)::text = 'edge_lv_gen_ca'::text) OR ((table_name)::text = 'edge_lv_del_str_co'::text)))