explain.depesz.com

PostgreSQL's explain analyze made readable

Result: C3HC

Settings
# exclusive inclusive rows x rows loops node
1. 36.157 274.342 ↓ 0.0 0 1

Bitmap Heap Scan on szfej (cost=1,566.86..38,585.72 rows=109 width=28) (actual time=274.342..274.342 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. 238.185 238.185 ↓ 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=238.185..238.185 rows=20,180 loops=1)

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