explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6uRZ

Settings
# exclusive inclusive rows x rows loops node
1. 47.700 279.697 ↓ 0.0 0 1
→

Bitmap Heap Scan on szfej (cost=498.90..37,493.93 rows=116 width=28) (actual time=279.697..279.697 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[])))
  • Rows Removed by Filter: 15666
  • Heap Blocks: exact=14520
2. 231.997 231.997 ↓ 2.1 20,294 1
→

Bitmap Index Scan on idx_szfej_eszla_prfx_kelt (cost=0.00..498.87 rows=9,486 width=0) (actual time=231.997..231.997 rows=20,294 loops=1)

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