explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mBmF : Optimization for: Optimization for: plan #VuVT; plan #c5QV0

Settings

Optimization path:

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

Merge Join (cost=0..0 rows=0 width=0) (actual rows=1,068,298 loops=1)

2. 0.000 0.000 ↓ 0.0 1,155,097 1

Nested Loop (cost=0..0 rows=0 width=0) (actual rows=1,155,097 loops=1)

3. 0.000 0.000 ↓ 0.0 1,208,704 1

Nested Loop (cost=0..0 rows=0 width=0) (actual rows=1,208,704 loops=1)

4. 0.000 0.000 ↓ 0.0 1,205,393 1

Merge Append (cost=0..0 rows=0 width=0) (actual rows=1,205,393 loops=1)

5. 0.000 0.000 ↓ 0.0 165 1

Index Scan using edge_hv_bus_cb_pkey on edge_hv_bus_cb rami (cost=0..0 rows=0 width=0) (actual rows=165 loops=1)

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

Index Scan using edge_hv_bus_jun_pkey on edge_hv_bus_jun rami_1 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

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

Index Scan using edge_hv_gen_ca_pkey on edge_hv_gen_ca rami_2 (cost=0..0 rows=0 width=0) (actual rows=1,386 loops=1)

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

Index Scan using edge_hv_hv_pri_cb_pkey on edge_hv_hv_pri_cb rami_3 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

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

Index Scan using edge_hv_hv_sec_cb_pkey on edge_hv_hv_sec_cb rami_4 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

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

Index Scan using edge_hv_hv_ter_cb_pkey on edge_hv_hv_ter_cb rami_5 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

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

Index Scan using edge_hv_mv_pri_cb_pkey on edge_hv_mv_pri_cb rami_6 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

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

Index Scan using edge_hv_mv_sec_cb_pkey on edge_hv_mv_sec_cb rami_7 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

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

Index Scan using edge_hv_mv_ter_cb_pkey on edge_hv_mv_ter_cb rami_8 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

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

Index Scan using edge_lv_bus_cb_pkey on edge_lv_bus_cb rami_9 (cost=0..0 rows=0 width=0) (actual rows=82,082 loops=1)

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

Index Scan using edge_lv_bus_jun_pkey on edge_lv_bus_jun rami_10 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

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

Index Scan using edge_lv_del_str_co_pkey on edge_lv_del_str_co rami_11 (cost=0..0 rows=0 width=0) (actual rows=325,942 loops=1)

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

Index Scan using edge_lv_gen_ca_pkey on edge_lv_gen_ca rami_12 (cost=0..0 rows=0 width=0) (actual rows=684,952 loops=1)

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

Index Scan using edge_lv_lv_pri_cb_pkey on edge_lv_lv_pri_cb rami_13 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

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

Index Scan using edge_lv_lv_sec_cb_pkey on edge_lv_lv_sec_cb rami_14 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

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

Index Scan using edge_lv_lv_ter_cb_pkey on edge_lv_lv_ter_cb rami_15 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

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

Index Scan using edge_lv_tmp_ca_pkey on edge_lv_tmp_ca rami_16 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

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

Index Scan using edge_mv_bus_cb_pkey on edge_mv_bus_cb rami_17 (cost=0..0 rows=0 width=0) (actual rows=39,503 loops=1)

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

Index Scan using edge_mv_bus_jun_pkey on edge_mv_bus_jun rami_18 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

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

Index Scan using edge_mv_gen_ca_pkey on edge_mv_gen_ca rami_19 (cost=0..0 rows=0 width=0) (actual rows=45,745 loops=1)

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

Index Scan using edge_mv_lv_pri_cb_pkey on edge_mv_lv_pri_cb rami_20 (cost=0..0 rows=0 width=0) (actual rows=12,809 loops=1)

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

Index Scan using edge_mv_lv_sec_cb_pkey on edge_mv_lv_sec_cb rami_21 (cost=0..0 rows=0 width=0) (actual rows=12,809 loops=1)

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

Index Scan using edge_mv_lv_ter_cb_pkey on edge_mv_lv_ter_cb rami_22 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

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

Index Scan using edge_mv_mv_pri_cb_pkey on edge_mv_mv_pri_cb rami_23 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

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

Index Scan using edge_mv_mv_sec_cb_pkey on edge_mv_mv_sec_cb rami_24 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

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

Index Scan using edge_mv_mv_ter_cb_pkey on edge_mv_mv_ter_cb rami_25 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

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

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) (actual rows=0 loops=1,205,393)

  • 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 1 1,208,704

Append (cost=0..0 rows=0 width=0) (actual rows=1 loops=1,208,704)

33. 0.000 0.000 ↓ 0.0 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 1 158

Index Scan using node_hv_busbar_pkey on node_hv_busbar nodi_1 (cost=0..0 rows=0 width=0) (actual rows=1 loops=158)

  • 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 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 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 1 1,283

Index Scan using node_hv_junc_pkey on node_hv_junc nodi_4 (cost=0..0 rows=0 width=0) (actual rows=1 loops=1,283)

  • 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 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 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 1 110

Index Scan using node_hv_rig_no_pkey on node_hv_rig_no nodi_7 (cost=0..0 rows=0 width=0) (actual rows=1 loops=110)

  • 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 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 1 74,104

Index Scan using node_lv_busbar_pkey on node_lv_busbar nodi_9 (cost=0..0 rows=0 width=0) (actual rows=1 loops=74,104)

  • 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 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 0 53,607

Index Scan using node_lv_conn_li_pkey on node_lv_conn_li nodi_11 (cost=0..0 rows=0 width=0) (actual rows=0 loops=53,607)

  • 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 1 415,463

Index Scan using node_lv_del_no_pkey on node_lv_del_no nodi_12 (cost=0..0 rows=0 width=0) (actual rows=1 loops=415,463)

  • 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 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 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 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 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 1 553,113

Index Scan using node_lv_rig_no_pkey on node_lv_rig_no nodi_17 (cost=0..0 rows=0 width=0) (actual rows=1 loops=553,113)

  • 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 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 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 1 23,080

Index Scan using node_mv_busbar_pkey on node_mv_busbar nodi_20 (cost=0..0 rows=0 width=0) (actual rows=1 loops=23,080)

  • 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 1 141

Index Scan using node_mv_del_no_pkey on node_mv_del_no nodi_21 (cost=0..0 rows=0 width=0) (actual rows=1 loops=141)

  • 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 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 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 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 1 25,618

Index Scan using node_mv_lv_tr_pkey on node_mv_lv_tr nodi_25 (cost=0..0 rows=0 width=0) (actual rows=1 loops=25,618)

  • 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 1 38

Index Scan using node_mv_mv_tr_pkey on node_mv_mv_tr nodi_26 (cost=0..0 rows=0 width=0) (actual rows=1 loops=38)

  • 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 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 1 61,989

Index Scan using node_mv_rig_no_pkey on node_mv_rig_no nodi_28 (cost=0..0 rows=0 width=0) (actual rows=1 loops=61,989)

  • 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 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 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 1,121,732 1

Materialize (cost=0..0 rows=0 width=0) (actual rows=1,121,732 loops=1)

65. 0.000 0.000 ↓ 0.0 1,118,594 1

Sort (cost=0..0 rows=0 width=0) (actual rows=1,118,594 loops=1)

  • Sort Key: md5.table_id
  • Sort Method: external merge Disk: 28,488kB
66. 0.000 0.000 ↓ 0.0 1,118,594 1

Append (cost=0..0 rows=0 width=0) (actual rows=1,118,594 loops=1)

67. 0.000 0.000 ↓ 0.0 82,082 1

Seq Scan on md5_edge_lv_bus_cb md5 (cost=0..0 rows=0 width=0) (actual rows=82,082 loops=1)

  • 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_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 0 1

Bitmap Heap Scan on md5_edge_lv_bus_jun md5_1 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

  • 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_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 0 1

Bitmap Index Scan on md5_edge_lv_bus_jun_db_rt_action_idx (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

  • Index Cond: (db_rt = false)
70. 0.000 0.000 ↓ 0.0 325,942 1

Seq Scan on md5_edge_lv_del_str_co md5_2 (cost=0..0 rows=0 width=0) (actual rows=325,942 loops=1)

  • 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_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 684,952 1

Seq Scan on md5_edge_lv_gen_ca md5_3 (cost=0..0 rows=0 width=0) (actual rows=684,952 loops=1)

  • 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_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 0 1

Bitmap Heap Scan on md5_edge_lv_lv_pri_cb md5_4 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

  • 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_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 0 1

Bitmap Index Scan on md5_edge_lv_lv_pri_cb_db_rt_action_idx (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

  • Index Cond: (db_rt = false)
74. 0.000 0.000 ↓ 0.0 0 1

Bitmap Heap Scan on md5_edge_lv_lv_sec_cb md5_5 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

  • 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_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 0 1

Bitmap Index Scan on md5_edge_lv_lv_sec_cb_db_rt_action_idx (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

  • Index Cond: (db_rt = false)
76. 0.000 0.000 ↓ 0.0 0 1

Bitmap Heap Scan on md5_edge_lv_lv_ter_cb md5_6 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

  • 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_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 0 1

Bitmap Index Scan on md5_edge_lv_lv_ter_cb_db_rt_action_idx (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

  • Index Cond: (db_rt = false)
78. 0.000 0.000 ↓ 0.0 0 1

Bitmap Heap Scan on md5_edge_lv_tmp_ca md5_7 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

  • 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_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)))
79. 0.000 0.000 ↓ 0.0 0 1

Bitmap Index Scan on md5_edge_lv_tmp_ca_db_rt_action_idx (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

  • Index Cond: (db_rt = false)
80. 0.000 0.000 ↓ 0.0 12,809 1

Seq Scan on md5_edge_mv_lv_pri_cb md5_8 (cost=0..0 rows=0 width=0) (actual rows=12,809 loops=1)

  • 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_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)))
81. 0.000 0.000 ↓ 0.0 12,809 1

Seq Scan on md5_edge_mv_lv_sec_cb md5_9 (cost=0..0 rows=0 width=0) (actual rows=12,809 loops=1)

  • 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_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)))
82. 0.000 0.000 ↓ 0.0 0 1

Bitmap Heap Scan on md5_edge_mv_lv_ter_cb md5_10 (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

  • 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_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)))
83. 0.000 0.000 ↓ 0.0 0 1

Bitmap Index Scan on md5_edge_mv_lv_ter_cb_db_rt_action_idx (cost=0..0 rows=0 width=0) (actual rows=0 loops=1)

  • Index Cond: (db_rt = false)