explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hkh6

Settings
# exclusive inclusive rows x rows loops node
1. 37.538 265.079 ↓ 0.0 0 1

Bitmap Heap Scan on szfej (cost=558.87..37,613.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
2. 227.541 227.541 ↓ 2.1 20,305 1

Bitmap Index Scan on idx_szfej_eszla_prfx_kelt (cost=0.00..558.87 rows=9,486 width=0) (actual time=227.541..227.541 rows=20,305 loops=1)

  • Index Cond: ((ceg_id = '2'::numeric) AND (szfejkeltdat > (CURRENT_DATE - ('30days'::cstring)::interval)))