Bitmap Heap Scan on szfej (cost=558.87..37613.20 rows=2 width=28) (actual time=265.079..265.079 rows=0 loops=1)
Recheck Cond: ((ceg_id = '2'::numeric) AND (szfejkeltdat > (CURRENT_DATE - ('30days'::cstring)::interval)))
Filter: ((szfej_id_child_dijbekero IS NULL) AND (szfejkifizstate <> ALL ('{2,3}'::numeric[])) AND (ARRAY[szfejszlasz, (szfejpartnerazon)::text, szfejrendszam] && '{67981-2018-55,TST-2016-1,12,1234,KETTO,xxx}'::text[]) AND (szfejtypecode <> ALL ('{SL,SS,JS}'::text[])) AND (upper(szfejdeviza) = ANY ('{"",Ft,HUF}'::text[])))
Rows Removed by Filter: 15673
Heap Blocks: exact=14530
-> Bitmap Index Scan on idx_szfej_eszla_prfx_kelt (cost=0.00..558.87 rows=9486 width=0) (actual time=227.541..227.541 rows=20305 loops=1)
Index Cond: ((ceg_id = '2'::numeric) AND (szfejkeltdat > (CURRENT_DATE - ('30days'::cstring)::interval)))
Planning time: 0.496 ms
Execution time: 265.125 ms