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"