pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feed From: Alex <cdalxndr@yahoo.com>
To: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Subject: Delete in list with join using partitions generates monstrous query plan
Date: Fri, 18 Dec 2020 13:22:53 +0000 (UTC)
Message-ID: <1966497320.2175534.1608297773488@mail.yahoo.com> (raw )
References: <1966497320.2175534.1608297773488.ref@mail.yahoo.com >
I have a table with 80 partitions (product_property) partitioned on somecolumn not used in the following query:
DELETE
FROM "product_property"
WHERE "product_property".."id" IN
( SELECT "product_property"."id"
FROM "product_property"
JOIN "product" ON"product_property"."product" ="product"."id"
WHERE ("product"."language"= cast('ro' AS regconfig)
AND"product_property"."secondary_meaning" = 'V') )
This query creates a plan where eachpartition uses a hash semi join with 80 index scans (one for each partition),with a total of 6643 index scans.
Interesting is that 5443 out of 6643index scans are „never executed” .
This query also uses lots of memory(>500MB) and the planner time is ~10sec.
Querying only the subquery, returns norows and plan uses one index scan per each partition, as expected, with aplanning time of 118ms.
As the subquery plan is simple enough, Iexpected the delete to use something similar.
Any suggestion on improving the plannedexecution? Or it’s something you guys can do to optimize the planner on devside?
I’ve attached the explain analyze forwhole query and subquery.
Thanks
Attachments:
explain_analyze_query.txt (text/plain, 2.0M) download
explain_analyze_subquery.txt (text/plain, 22.3K) download
explain analyze SELECT "product_property"."id"
FROM "product_property"
JOIN "product" ON "product_property"."product" = "product"."id"
WHERE ("product"."language" = cast('ro' AS regconfig)
AND "product_property"."secondary_meaning" = 'V')
"Gather (cost=1000.71..9740.13 rows=7871 width=4) (actual time=126.320..137.155 rows=0 loops=1)"
" Workers Planned: 2"
" Workers Launched: 2"
" -> Nested Loop (cost=0.71..7953.03 rows=3280 width=4) (actual time=0.371..0.380 rows=0 loops=3)"
" -> Parallel Append (cost=0.42..1725.06 rows=3328 width=8) (actual time=0.370..0.379 rows=0 loops=3)"
" -> Parallel Bitmap Heap Scan on product_property_m (cost=116.78..1381.05 rows=4582 width=8) (actual time=0.941..0.941 rows=0 loops=1)"
" Recheck Cond: (secondary_meaning = 'V'::text)"
" -> Bitmap Index Scan on product_property_m_secondary_meaning_idx (cost=0.00..114.83 rows=7789 width=0) (actual time=0.496..0.496 rows=8156 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using product_property_global_id_secondary_meaning_idx on product_property_global_id (cost=0.42..4.43 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using product_property_default_secondary_meaning_idx on product_property_default (cost=0.42..2.43 rows=1 width=8) (actual time=0.006..0.006 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using product_property_hsl_secondary_meaning_idx on product_property_hsl (cost=0.29..4.30 rows=1 width=8) (actual time=0.002..0.003 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using product_property_g_secondary_meaning_idx on product_property_g (cost=0.29..2.30 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using product_property_rpm_secondary_meaning_idx on product_property_rpm (cost=0.28..4.30 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using product_property_s_secondary_meaning_idx on product_property_s (cost=0.28..4.30 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using product_property_dpi_secondary_meaning_idx on product_property_dpi (cost=0.28..2.29 rows=1 width=8) (actual time=0.012..0.012 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using product_property_fps_secondary_meaning_idx on product_property_fps (cost=0.28..4.29 rows=1 width=8) (actual time=0.002..0.003 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using product_property_lm_secondary_meaning_idx on product_property_lm (cost=0.28..4.29 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using product_property_ppm_secondary_meaning_idx on product_property_ppm (cost=0.28..4.29 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using product_property_hp_secondary_meaning_idx on product_property_hp (cost=0.28..4.29 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using product_property_gr_secondary_meaning_idx on product_property_gr (cost=0.14..4.16 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using product_property_gr_s_secondary_meaning_idx on product_property_gr_s (cost=0.14..4.16 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_grC_secondary_meaning_idx"" on ""product_property_grC"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.002 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_A_secondary_meaning_idx"" on ""product_property_A"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_A_h_secondary_meaning_idx"" on ""product_property_A_h"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_A_m_secondary_meaning_idx"" on ""product_property_A_m"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.002 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_Ah_secondary_meaning_idx"" on ""product_property_Ah"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_B_secondary_meaning_idx"" on ""product_property_B"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_B_s_secondary_meaning_idx"" on ""product_property_B_s"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.002 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_BTU_secondary_meaning_idx"" on ""product_property_BTU"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_BTU_h_secondary_meaning_idx"" on ""product_property_BTU_h"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_C_secondary_meaning_idx"" on ""product_property_C"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_C_h_secondary_meaning_idx"" on ""product_property_C_h"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.002 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using product_property_cd_m_secondary_meaning_idx on product_property_cd_m (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using product_property_cd_m2_secondary_meaning_idx on product_property_cd_m2 (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using product_property_cd_m3_secondary_meaning_idx on product_property_cd_m3 (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.002 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_cd_MP_secondary_meaning_idx"" on ""product_property_cd_MP"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.002 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_dB_secondary_meaning_idx"" on ""product_property_dB"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_dB_A_secondary_meaning_idx"" on ""product_property_dB_A"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_dB_m_secondary_meaning_idx"" on ""product_property_dB_m"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.002 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_dB_V_secondary_meaning_idx"" on ""product_property_dB_V"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.002 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_dB_W_secondary_meaning_idx"" on ""product_property_dB_W"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_dBA_secondary_meaning_idx"" on ""product_property_dBA"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_dBi_secondary_meaning_idx"" on ""product_property_dBi"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_dBm_secondary_meaning_idx"" on ""product_property_dBm"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_dBV_secondary_meaning_idx"" on ""product_property_dBV"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using product_property_f__secondary_meaning_idx on product_property_f_ (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_FLOPS_secondary_meaning_idx"" on ""product_property_FLOPS"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.002 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_g_L_secondary_meaning_idx"" on ""product_property_g_L"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using product_property_g_m_secondary_meaning_idx on product_property_g_m (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using product_property_g_m2_secondary_meaning_idx on product_property_g_m2 (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.002 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using product_property_g_m3_secondary_meaning_idx on product_property_g_m3 (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_Hz_secondary_meaning_idx"" on ""product_property_Hz"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_J_secondary_meaning_idx"" on ""product_property_J"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.002 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_L_secondary_meaning_idx"" on ""product_property_L"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_L_h_secondary_meaning_idx"" on ""product_property_L_h"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_L_m_secondary_meaning_idx"" on ""product_property_L_m"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_L_m2_secondary_meaning_idx"" on ""product_property_L_m2"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_L_s_secondary_meaning_idx"" on ""product_property_L_s"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using product_property_lm_m_secondary_meaning_idx on product_property_lm_m (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.002 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_lm_W_secondary_meaning_idx"" on ""product_property_lm_W"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using product_property_m_h_secondary_meaning_idx on product_property_m_h (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using product_property_m_s_secondary_meaning_idx on product_property_m_s (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using product_property_m_s2_secondary_meaning_idx on product_property_m_s2 (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using product_property_m2_secondary_meaning_idx on product_property_m2 (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_m2_L_secondary_meaning_idx"" on ""product_property_m2_L"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.002 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using product_property_m3_secondary_meaning_idx on product_property_m3 (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using product_property_m3_h_secondary_meaning_idx on product_property_m3_h (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_MP_secondary_meaning_idx"" on ""product_property_MP"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_N_secondary_meaning_idx"" on ""product_property_N"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.002 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_N_m_secondary_meaning_idx"" on ""product_property_N_m"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_Pa_secondary_meaning_idx"" on ""product_property_Pa"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_Pa_m_secondary_meaning_idx"" on ""product_property_Pa_m"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_SPF_secondary_meaning_idx"" on ""product_property_SPF"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_Sv_secondary_meaning_idx"" on ""product_property_Sv"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_V_secondary_meaning_idx"" on ""product_property_V"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_V_A_secondary_meaning_idx"" on ""product_property_V_A"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_V_m_secondary_meaning_idx"" on ""product_property_V_m"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.002 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_VA_secondary_meaning_idx"" on ""product_property_VA"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_W_secondary_meaning_idx"" on ""product_property_W"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_W_h_secondary_meaning_idx"" on ""product_property_W_h"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_W_m_secondary_meaning_idx"" on ""product_property_W_m"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_W_m2_secondary_meaning_idx"" on ""product_property_W_m2"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_W_rpm_secondary_meaning_idx"" on ""product_property_W_rpm"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_W_s_secondary_meaning_idx"" on ""product_property_W_s"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using ""product_property_Whr_secondary_meaning_idx"" on ""product_property_Whr"" (cost=0.14..4.16 rows=1 width=8) (actual time=0.001..0.002 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using product_property_ohm_secondary_meaning_idx on product_property_ohm (cost=0.14..4.16 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Index Scan using product_property_ohm_m_secondary_meaning_idx on product_property_ohm_m (cost=0.14..4.16 rows=1 width=8) (actual time=0.005..0.006 rows=0 loops=1)"
" Index Cond: (secondary_meaning = 'V'::text)"
" -> Parallel Seq Scan on product_property_cd (cost=0.00..1.03 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)"
" Filter: (secondary_meaning = 'V'::text)"
" Rows Removed by Filter: 4"
" -> Parallel Seq Scan on product_property_lx (cost=0.00..1.03 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=1)"
" Filter: (secondary_meaning = 'V'::text)"
" Rows Removed by Filter: 4"
" -> Parallel Seq Scan on product_property_cal (cost=0.00..1.01 rows=1 width=8) (actual time=0.008..0.008 rows=0 loops=1)"
" Filter: (secondary_meaning = 'V'::text)"
" Rows Removed by Filter: 2"
" -> Index Scan using product_pkey on product (cost=0.29..1.87 rows=1 width=4) (never executed)"
" Index Cond: (id = product_property_m.product)"
" Filter: ((language)::oid = '3513046'::oid)"
"Planning Time: 118.114 ms"
"Execution Time: 137.963 ms"
Message-ID: <1966497320.2175534.1608297773488@mail.yahoo.com>
Permalink: ../1966497320.2175534.1608297773488@mail.yahoo.com/
Also on: postgresql.org/message-id/1966497320.2175534.1608297773488@mail.yahoo.com
copy link · copy postgr.es
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: cdalxndr@yahoo.com, pgsql-bugs@lists.postgresql.org
Subject: Re: Delete in list with join using partitions generates monstrous query plan
In-Reply-To: <1966497320.2175534.1608297773488@mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox