Query analysis report


Overall Statistics

Total number of queries: 138297
Unique number of queries: 103
Shortest query: rollback ;
Longest query: select rash_dash.requestid from rash_dash where rash_dash.dd={}
Log file parsed in: 20 seconds



Most Frequent queries

RankTimes
executed		Query
122893SELECT value FROM sysconf_local WHERE key={}
222695SELECT sysconf_local.value FROM sysconf_local WHERE sysconf_local.key={}
319309SELECT requestid, pid_stime FROM rash_jo WHERE deve={}
419309SELECT requestid FROM rash_jo WHERE deve={}
59034SELECT il.ipaddress FROM il WHERE il.il={}
65127UPDATE serv_deny_log set dd={}, fallback_sync_done={} WHERE tlid={} AND
74815INSERT into serv_deny_log ( sno, params, stime, tlid, twer_seqno, sdate, twerid) values ( {}, {},
84647begin; SELECT getdatabaseencoding(); commit
93722SELECT clog.tlid, clog.channel, clog.sellerid, clog.sdate, clog.stime, clog.language, clog.custid,
103297SELECT branchno FROM il WHERE il={}
113031SELECT value FROM sysconf_global WHERE key={}
122621SELECT sion FROM lest_con WHERE il={} AND channelno={}
132621INSERT into blgg ( stime, tlid, idd_rg, sdate, channel) values ( {}, {}, {},
142619UPDATE blgg set edate={}, dd={}, etime={}, duration={},
152327UPDATE blgg set language={} WHERE tlid={}
162243SELECT tlid, sno, twerid, twer_seqno FROM serv_deny_log_view WHERE tlid={} order
171313SELECT selltype FROM blgg WHERE tlid={}
18908SELECT cdn_no FROM cdn_map WHERE cdn_mapno={}
19903INSERT into serv_deny_log ( sno, params, stime, tlid, twer_seqno, sdate, twerid) values ( {},
20814UPDATE blgg set custid={} WHERE tlid={}

Slowest Queries

RankTimeQuery
12.087vacuum full verbose analyze
20.557INSERT into blgg ( stime, tlid, idd_rg, sdate, channel) values ( {}, {}, {},
30.237SELECT serv_deny_log.tlid, serv_deny_log.sno, serv_deny_log.twerid, serv_deny_log.twer_seqno FROM
40.107INSERT into rash_jo ( message, requestid, faxno1, tlid, twer_seqno, max_noof_tries, sno,
50.078SELECT tlid, sno, twerid, twer_seqno FROM serv_deny_log_view WHERE tlid={} order
60.068UPDATE serv_deny_log set dd={}, fallback_sync_done={} WHERE tlid={} AND
70.064SELECT tlid, sno, twerid, twer_seqno FROM serv_deny_log_view WHERE tlid={} ORDER BY
80.048UPDATE blgg set edate={}, dd={}, etime={}, duration={},
90.043UPDATE serv_deny_log set status={}, dd={}, fallback_sync_done={} WHERE tlid=
100.037SELECT n.nspname as "schema",
110.030UPDATE blgg set language={} WHERE tlid={}
120.028begin; SELECT usesuper FROM pg_catalog.pg_user WHERE usename={}; commit
130.027SELECT sysconf_local.value FROM sysconf_local WHERE sysconf_local.key={}
140.026UPDATE rash_jo set agreed_date={}, agreed_channel={}, reason={},
150.026INSERT into acc_deny_log ( tlid, accno, fallback_sync_done, channel, sno, stime, custid, idd_rg, acctype,
160.023SELECT selltype FROM blgg WHERE tlid={}
170.022UPDATE blgg set denyvalid={} WHERE tlid={}
180.021INSERT into acc_deny_log ( tlid, accno, fallback_sync_done, channel, sno, stime, idd_rg, custid, acctype,
190.021UPDATE blgg set denyvalid={}, custid={} WHERE tlid={}
200.020INSERT into serv_deny_log ( sno, params, stime, tlid, twer_seqno, sdate, twerid) values ( {}, {},

Queries Took Most Time

RankTotal timeTimes
executed		Query
141.6445127UPDATE serv_deny_log set dd={}, fallback_sync_done={} WHERE tlid={} AND
221.8452243SELECT tlid, sno, twerid, twer_seqno FROM serv_deny_log_view WHERE tlid={} order
315.8272327UPDATE blgg set language={} WHERE tlid={}
413.2172619UPDATE blgg set edate={}, dd={}, etime={}, duration={},
53.839377SELECT tlid, sno, twerid, twer_seqno FROM serv_deny_log_view WHERE tlid={} ORDER BY
63.4644815INSERT into serv_deny_log ( sno, params, stime, tlid, twer_seqno, sdate, twerid) values ( {}, {},
72.3652621INSERT into blgg ( stime, tlid, idd_rg, sdate, channel) values ( {}, {}, {},
82.33022893SELECT value FROM sysconf_local WHERE key={}
92.0871vacuum full verbose analyze
101.76522695SELECT sysconf_local.value FROM sysconf_local WHERE sysconf_local.key={}
110.978814UPDATE blgg set custid={} WHERE tlid={}
120.9261313SELECT selltype FROM blgg WHERE tlid={}
130.9003297SELECT branchno FROM il WHERE il={}
140.8909034SELECT il.ipaddress FROM il WHERE il.il={}
150.81219309SELECT requestid, pid_stime FROM rash_jo WHERE deve={}
160.79419309SELECT requestid FROM rash_jo WHERE deve={}
170.7072621SELECT sion FROM lest_con WHERE il={} AND channelno={}
180.515207UPDATE blgg set denyvalid={} WHERE tlid={}
190.502903INSERT into serv_deny_log ( sno, params, stime, tlid, twer_seqno, sdate, twerid) values ( {},
200.494589INSERT into acc_deny_log ( tlid, accno, fallback_sync_done, channel, sno, stime, custid, idd_rg, acctype,


Error Queries
Number of TimesQuery
32WARNING: Message from PostgreSQL backend:
13FATAL: The database system is starting up
1ERROR: Query was cancelled.
1ERROR: Attribute "csdate" not found
1ERROR: current transaction is aborted, queries ignored until end of transaction block

Fastest Queries

RankTimeQuery
10.000rollback ;
20.000begin ;
30.000set datestyle to "sql,european"
40.000SELECT branchno FROM il WHERE il={}
50.000SELECT value FROM sysconf_local WHERE key={}
60.000SELECT value FROM sysconf_global WHERE key={}
70.000SELECT il.ipaddress FROM il WHERE il.il={}
80.000SELECT sysconf_local.value FROM sysconf_local WHERE sysconf_local.key={}
90.000SELECT cdn_no FROM cdn_map WHERE cdn_mapno={}
100.000SELECT requestid FROM rash_jo WHERE deve={}
110.000UPDATE rash_dash set status={}, channel={}, trycount={}, reason={},
120.000UPDATE rash_dash set status={}, channel={}, trycount={}, reason={}, requestid=
130.000SELECT requestid, pid_stime FROM rash_jo WHERE deve={}
140.000SELECT requested_date, requested_time FROM rash_jo WHERE requestid={}
150.000SELECT sion FROM lest_con WHERE il={} AND channelno={}
160.000SELECT selltype FROM blgg WHERE tlid={}
170.000SELECT max_noof_tries, noof_tries FROM rash_jo WHERE requestid={}
180.000SELECT tlid, sno, twerid, twer_seqno FROM rash_jo WHERE requestid={}
190.000SELECT requestid, faxno1, message, message_type FROM rash_jo WHERE requestid={}
200.000SELECT stime, etime FROM officehours WHERE day={}



Report generated by epqa