explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xksT

Settings
# exclusive inclusive rows x rows loops node
1. 36.897 254.051 ↓ 0.0 0 1

Bitmap Heap Scan on szfej (cost=478.87..37,663.61 rows=1 width=28) (actual time=254.051..254.051 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 (szfejtypecode <> ALL ('{SL,SS,JS}'::text[])) AND ((szfejszlasz = ANY ('{67981-2018-55,TST-2016-1,12,1234,KETTO,xxx}'::text[])) OR ((szfejpartnerazon)::text = ANY ('{67981-2018-55,TST-2016-1,12,1234,KETTO,xxx}'::text[])) OR (szfejrendszam = ANY ('{67981-2018-55,TST-2016-1,12,1234,KETTO,xxx}'::text[]))))
  • Rows Removed by Filter: 15664
  • Heap Blocks: exact=14518
2. 217.154 217.154 ↓ 2.1 20,292 1

Bitmap Index Scan on idx_szfej_eszla_prfx_kelt (cost=0.00..478.87 rows=9,486 width=0) (actual time=217.154..217.154 rows=20,292 loops=1)

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