-- [CQ-5-5-1]
EXPLAIN (ANALYZE,BUFFERS,COSTS OFF)
SELECT t1.*
FROM startdbpg.tr_event_entry_big t1
WHERE t1.shop_id = 'S146'
AND t1.entry_dtm >= '2024-02-01'::date
AND t1.entry_dtm < '2024-02-06'::date
AND t1.mbr_id = 'M46501';
SQL
복사
-- [CQ-5-5-2]
SELECT t1.*
FROM startdbpg.tr_event_entry_big t1
WHERE t1.entry_dtm >= '2022-07-12 07:00:00'::timestamp
AND t1.entry_dtm < '2022-07-12 08:00:00'::timestamp
AND t1.event_id = 'EVS10022071207'
AND t1.entry_rslt_cd = 'SUCC';
SQL
복사
-- [CQ-5-5-3]
EXPLAIN (ANALYZE,COSTS OFF)
SELECT t1.*
FROM startdbpg.tr_event_entry_big t1
WHERE t1.shop_id = 'S100'
AND t1.entry_dtm >= '2022-07-01'::date
AND t1.entry_dtm < '2022-07-11'::date
AND t1.mbr_id = 'M44161'
AND t1.entry_rslt_cd = 'FAIL';
SQL
복사