Statistics

Jo aapdi pase matra basic system metrics hase, jem k CPU, Memory and Disk, to aa case ma ae janvu sakya nathi k traffic kai type no aave 6e. aapde ae janvu jaruri 6e k read and write no load ketlok 6e. Aa janva mate aapde ek shortcut no use karsu. Generally, most of the databases ma, aapde top 10 queries ne find karsu sort by total time consumed. Aa 10 queries, generally janavi dese k 90% of hardware utilization kon kare 6e. Aa same query aapde database performance nu bottleneck find karta hoi tyare bhi use thai sake 6e.

Actually ma, aapde aa statistics ne PostgreSQL ma enable karvu pade 6e pehla tyar pa6ij aapde aa statistics ne jani sakay.

vadhare information mate, Installation & Config section ma aavel "Integrate pg_stat_statements" page ne check karo.