AndBondStyle commented on issue #628:
URL: https://github.com/apache/age/issues/628#issuecomment-1404796558
@moeed-k yes, I currently have 30 different labels. Looking at EXPLAIN
ANALYZE, it seems like query is running for each label separately (?)
```
Gather (cost=1000.00..102971702.31 rows=20 width=96) (actual
time=48253.194..634513.180 rows=20 loops=1)
--
Workers Planned: 2
Workers Launched: 2
-> Nested Loop (cost=0.00..102970700.31 rows=8 width=96) (actual
time=438399.167..633819.081 rows=7 loops=3)
Join Filter: ((("R".start_id = "V".id) AND ("R".end_id = "V2_2".id)) OR
(("R".end_id = "V".i…
Rows Removed by Join Filter: 2240006423
-> Parallel Append (cost=0.00..920.52 rows=10806 width=104) (actual
time=0.016..12.256 rows=8641 loops=3)
-> Parallel Seq Scan on column_table "V2_2" (cost=0.00..538.64 rows=11164
width=103) (actual time=0.007..5.137 rows=6326…
-> Parallel Seq Scan on column_view "V2_3" (cost=0.00..167.01 rows=2101
width=101) (actual time=0.007..1.647 rows=1786 l…
-> Parallel Seq Scan on transformation_rule "V2_5" (cost=0.00..39.79
rows=379 width=154) (actual time=0.002..0.636 rows=…
-> Parallel Seq Scan on "table" "V2_4" (cost=0.00..24.84 rows=384 width=112)
(actual time=0.002..0.543 rows=652 …
-> Parallel Seq Scan on view "V2_6" (cost=0.00..16.19 rows=319 width=105)
(actual time=0.002..0.425 rows=542 loops=1)
-> Parallel Seq Scan on transport_request "V2_9" (cost=0.00..14.54 rows=154
width=98) (actual time=0.002..0.192 rows=262…
-> Parallel Seq Scan on master_data "V2_15" (cost=0.00..8.69 rows=169
width=96) (actual time=0.002..0.215 rows=287 loops…
-> Parallel Seq Scan on dtp "V2_7" (cost=0.00..5.50 rows=50 width=117)
(actual time=0.002..0.071 rows=85 loops=1)
-> Parallel Seq Scan on cv_hana "V2_8" (cost=0.00..5.45 rows=45 width=129)
(actual time=0.001..0.062 rows=76 loops=1)
-> Parallel Seq Scan on _ag_label_vertex "V2" (cost=0.00..4.74 rows=174
width=28) (actual time=0.007..0.363 rows=296 loo…
-> Parallel Seq Scan on sheet "V2_10" (cost=0.00..4.54 rows=54 width=117)
(actual time=0.002..0.066 rows=91 loops=1)
-> Parallel Seq Scan on pc_variant "V2_13" (cost=0.00..4.42 rows=42
width=107) (actual time=0.002..0.050 rows=72 loops=1)
-> Parallel Seq Scan on first_source "V2_16" (cost=0.00..4.29 rows=29
width=102) (actual time=0.001..0.043 rows=50 loops…
-> Parallel Seq Scan on workflow "V2_19" (cost=0.00..3.46 rows=46 width=132)
(actual time=0.002..0.060 rows=79 loops=1)
-> Parallel Seq Scan on transformation_bw "V2_12" (cost=0.00..3.29 rows=29
width=120) (actual time=0.003..0.043 rows=49 …
-> Parallel Seq Scan on info_package "V2_20" (cost=0.00..2.20 rows=20
width=118) (actual time=0.002..0.028 rows=34 loops…
-> Parallel Seq Scan on trigger "V2_11" (cost=0.00..2.18 rows=18 width=110)
(actual time=0.002..0.026 rows=31 loops=1)
-> Parallel Seq Scan on process_chain "V2_22" (cost=0.00..2.18 rows=18
width=107) (actual time=0.001..0.023 rows=30 loop…
-> Parallel Seq Scan on job "V2_21" (cost=0.00..1.10 rows=10 width=130)
(actual time=0.002..0.012 rows=17 loops=1)
-> Parallel Seq Scan on dso "V2_17" (cost=0.00..1.09 rows=9 width=94)
(actual time=0.002..0.013 rows=15 loops=1)
-> Parallel Seq Scan on info_source "V2_24" (cost=0.00..1.08 rows=8
width=100) (actual time=0.002..0.010 rows=13 loops=1)
-> Parallel Seq Scan on function "V2_25" (cost=0.00..1.07 rows=7 width=109)
(actual time=0.001..0.009 rows=12 loops=1)
-> Parallel Seq Scan on dataflow "V2_18" (cost=0.00..1.06 rows=6 width=134)
(actual time=0.002..0.011 rows=11 loops=1)
-> Parallel Seq Scan on composite_provider "V2_1" (cost=0.00..1.06 rows=6
width=95) (actual time=0.002..0.012 rows=10 lo…
-> Parallel Seq Scan on cds "V2_14" (cost=0.00..1.04 rows=4 width=107)
(actual time=0.001..0.007 rows=7 loops=1)
-> Parallel Seq Scan on schema "V2_27" (cost=0.00..1.01 rows=1 width=95)
(actual time=0.002..0.004 rows=2 loops=1)
-> Parallel Seq Scan on system "V2_23" (cost=0.00..1.01 rows=1 width=108)
(actual time=0.003..0.004 rows=1 loops=1)
-> Parallel Seq Scan on role "V2_26" (cost=0.00..1.01 rows=1 width=113)
(actual time=0.001..0.003 rows=1 loops=1)
-> Parallel Seq Scan on graph "V2_28" (cost=0.00..1.01 rows=1 width=112)
(actual time=0.001..0.003 rows=1 loops=1)
-> Parallel Seq Scan on report "V2_29" (cost=0.00..1.01 rows=1 width=106)
(actual time=0.001..0.003 rows=1 loops=1)
-> Parallel Seq Scan on term "V2_30" (cost=0.00..1.01 rows=1 width=106)
(actual time=0.002..0.003 rows=1 loops=1)
-> Parallel Seq Scan on cube "V2_31" (cost=0.00..1.01 rows=1 width=97)
(actual time=0.017..0.018 rows=1 loops=1)
-> Nested Loop (cost=0.00..4344.35 rows=259230 width=133) (actual
time=0.026..56.704 rows=259230 loops=25923)
-> Append (cost=0.00..1102.84 rows=25923 width=104) (actual
time=0.005..5.026 rows=25923 loops=25923)
-> Seq Scan on _ag_label_vertex "V" (cost=0.00..5.96 rows=296 width=28)
(actual time=0.005..0.034 rows=296 loops=2…
-> Seq Scan on composite_provider "V_1" (cost=0.00..1.10 rows=10 width=95)
(actual time=0.002..0.002 rows=10 loops…
-> Seq Scan on column_table "V_2" (cost=0.00..616.78 rows=18978 width=103)
(actual time=0.002..2.073 rows=18978 lo…
-> Seq Scan on column_view "V_3" (cost=0.00..181.71 rows=3571 width=101)
(actual time=0.002..0.458 rows=3571 loops…
-> Seq Scan on "table" "V_4" (cost=0.00..27.52 rows=652 width=112) (actual
time=0.003..0.079 rows=652 loop…
-> Seq Scan on transformation_rule "V_5" (cost=0.00..42.45 rows=645
width=154) (actual time=0.002..0.091 rows=645 …
-> Seq Scan on view "V_6" (cost=0.00..18.42 rows=542 width=105) (actual
time=0.003..0.062 rows=542 loops=25923)
-> Seq Scan on dtp "V_7" (cost=0.00..5.85 rows=85 width=117) (actual
time=0.002..0.013 rows=85 loops=25923)
-> Seq Scan on cv_hana "V_8" (cost=0.00..5.76 rows=76 width=129) (actual
time=0.002..0.012 rows=76 loops=25923)
-> Seq Scan on transport_request "V_9" (cost=0.00..15.62 rows=262 width=98)
(actual time=0.002..0.037 rows=262 loo…
-> Seq Scan on sheet "V_10" (cost=0.00..4.91 rows=91 width=117) (actual
time=0.002..0.013 rows=91 loops=25923)
-> Seq Scan on trigger "V_11" (cost=0.00..2.31 rows=31 width=110) (actual
time=0.002..0.006 rows=31 loops=25923)
-> Seq Scan on transformation_bw "V_12" (cost=0.00..3.49 rows=49 width=120)
(actual time=0.002..0.008 rows=49 loop…
-> Seq Scan on pc_variant "V_13" (cost=0.00..4.72 rows=72 width=107) (actual
time=0.002..0.011 rows=72 loops=25923)
-> Seq Scan on cds "V_14" (cost=0.00..1.07 rows=7 width=107) (actual
time=0.002..0.003 rows=7 loops=25923)
-> Seq Scan on master_data "V_15" (cost=0.00..9.87 rows=287 width=96)
(actual time=0.002..0.034 rows=287 loops=259…
-> Seq Scan on first_source "V_16" (cost=0.00..4.50 rows=50 width=102)
(actual time=0.002..0.010 rows=50 loops=259…
-> Seq Scan on dso "V_17" (cost=0.00..1.15 rows=15 width=94) (actual
time=0.002..0.003 rows=15 loops=25923)
-> Seq Scan on dataflow "V_18" (cost=0.00..1.11 rows=11 width=134) (actual
time=0.002..0.003 rows=11 loops=25923)
-> Seq Scan on workflow "V_19" (cost=0.00..3.79 rows=79 width=132) (actual
time=0.002..0.011 rows=79 loops=25923)
-> Seq Scan on info_package "V_20" (cost=0.00..2.34 rows=34 width=118)
(actual time=0.002..0.006 rows=34 loops=259…
-> Seq Scan on job "V_21" (cost=0.00..1.17 rows=17 width=130) (actual
time=0.002..0.003 rows=17 loops=25923)
-> Seq Scan on process_chain "V_22" (cost=0.00..2.30 rows=30 width=107)
(actual time=0.002..0.006 rows=30 loops=25…
-> Seq Scan on system "V_23" (cost=0.00..1.01 rows=1 width=108) (actual
time=0.004..0.004 rows=1 loops=25923)
-> Seq Scan on info_source "V_24" (cost=0.00..1.13 rows=13 width=100)
(actual time=0.002..0.003 rows=13 loops=25923)
-> Seq Scan on function "V_25" (cost=0.00..1.12 rows=12 width=109) (actual
time=0.002..0.003 rows=12 loops=25923)
-> Seq Scan on role "V_26" (cost=0.00..1.01 rows=1 width=113) (actual
time=0.002..0.003 rows=1 loops=25923)
-> Seq Scan on schema "V_27" (cost=0.00..1.02 rows=2 width=95) (actual
time=0.003..0.003 rows=2 loops=25923)
-> Seq Scan on graph "V_28" (cost=0.00..1.01 rows=1 width=112) (actual
time=0.002..0.002 rows=1 loops=25923)
-> Seq Scan on report "V_29" (cost=0.00..1.01 rows=1 width=106) (actual
time=0.002..0.002 rows=1 loops=25923)
-> Seq Scan on term "V_30" (cost=0.00..1.01 rows=1 width=106) (actual
time=0.003..0.003 rows=1 loops=25923)
-> Seq Scan on cube "V_31" (cost=0.00..1.01 rows=1 width=97) (actual
time=0.003..0.003 rows=1 loops=25923)
-> Materialize (cost=0.00..1.15 rows=10 width=29) (actual time=0.000..0.001
rows=10 loops=672001929)
-> Seq Scan on "similar" "R" (cost=0.00..1.10 rows=10 width=29) (actual
time=0.012..0.016 rows=10 loops=3)
Planning Time: 2.518 ms
JIT:
Functions: 12
Options: Inlining true, Optimization true, Expressions true, Deforming true
Timing: Generation 2.464 ms, Inlining 216.522 ms, Optimization 175.063 ms,
Emission 141.756 ms, Total 535.804 ms
Execution Time: 634543.340 ms
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscr...@age.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
