Question

5
Replies
690
Views
PonnurangamN2827 Member since 2019 43 posts
Vodafone
Posted: July 1, 2019
Last activity: July 2, 2019
Closed

query pr_sys_app_hierarchy_flat causing performance isssue

Team,

Our application uses pega 7.3.1 and below are the slow running queries observed in prod

query #1 : select 1 from pr_sys_app_hierarchy_flat - record count 647 -> taking 3 mins to run this query

Query #2 : on table PEGADATA.pr_perf_stats -> record count 12 millions - taking 3 mins to run this query

I followed the link https://community1.pega.com/community/product-support/question/long-running-queries-causing-system

wherein they have suggested to truncate cache tables . is this right practice to do this?

what should have caused the query2 too slower? any clue would be great help here.

***Edited by Moderator: Lochan to update platform capability tags***

System Administration
Moderation Team has archived post
Share this page LinkedIn