group by + limit 의 성능 이슈
테스트 데이터 생성(테이블 생성 + 벌크 데이터) CREATE TABLE public.test2m ( id serial primary key, timeslice timestamp , system_idVARCHAR(100), group_idVARCHAR(100), agent_nameVARCHAR(100), svc_nameVARCHAR(100), COUNTINT ); INSERT INTO public.test2m (timeslice, system_id, group_id, agent_name, svc_name, COUNT) SELECT now() as timeslice, LEFT(md5(random()::text),3) as system_id, LEFT(md5(random()::text),5) as group..
더보기
