explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dW9c

Settings
# exclusive inclusive rows x rows loops node
1. 37.194 273.931 ↓ 0.0 0 1

Bitmap Heap Scan on szfej (cost=1,566.86..38,585.72 rows=109 width=28) (actual time=273.931..273.931 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 (szfejdeviza = ANY ('{"",Ft,HUF}'::text[])))
  • Rows Removed by Filter: 15575
  • Heap Blocks: exact=14418
2. 236.737 236.737 ↓ 2.1 20,180 1

Bitmap Index Scan on idx_szfej_eszla_prfx_kelt (cost=0.00..1,566.84 rows=9,483 width=0) (actual time=236.737..236.737 rows=20,180 loops=1)

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