| Rank | Total time (seconds) | Times executed | Query text |
|---|
| 1 | 107.662 | 4741 | INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (0,'','','','','','','',''); |
| 2 | 36.013 | 279 | SELECT count(*) AS count FROM users WHERE status='' and user_id != 0 |
| 3 | 24.295 | 26 | SELECT * FROM stats_project_vw WHERE group_id='' ORDER BY month DESC, day DESC LIMIT 0 OFFSET 0 |
| 4 | 20.111 | 75 | SELECT rate_field,(avg(rating)+0) AS avg_rating,count(*) as count FROM user_ratings WHERE user_id='' GROUP BY rate_field |
| 5 | 19.405 | 230 | INSERT INTO stats_cvs_group (month,day,group_id,checkouts,commits,adds) VALUES ('','','',0,0,0) |
| 6 | 15.159 | 4778 | SELECT plugin_id, plugin_name FROM plugins |
| 7 | 8.382 | 21 | SELECT 0 FROM ONLY "public"."country_code" x WHERE "ccode" = $0 FOR UPDATE OF x |
| 8 | 8.154 | 457 | SELECT groups.group_name,groups.unix_group_name, groups.type_id,users.user_name,users.realname, news_bytes.forum_id,news_bytes.summary,news_bytes.post_date,news_bytes.details FROM users,news_bytes,groups WHERE news_bytes.is_approved=0 AND users.user_id=news_bytes.submitted_by AND news_bytes.group_id=groups.group_id ORDER BY post_date DESC LIMIT 0 OFFSET 0 |
| 9 | 7.683 | 4417 | SELECT total FROM forum_group_list_vw WHERE group_forum_id='' |
| 10 | 7.292 | 278 | INSERT INTO frs_dlstats_file (ip_address,file_id,month,day,user_id) VALUES ('','','','','') |
| 11 | 6.529 | 2749 | SELECT * FROM groups WHERE group_id='' |
| 12 | 5.859 | 91 | SELECT * FROM docdata_vw WHERE group_id='' AND stateid=0 AND language_id='' ORDER BY doc_group |
| 13 | 5.779 | 362 | SELECT frs_file.filename,frs_file.file_id,groups.unix_group_name,groups.group_id FROM frs_package,frs_release,frs_file,groups WHERE frs_release.release_id=frs_file.release_id AND groups.group_id=frs_package.group_id AND frs_release.package_id=frs_package.package_id AND frs_file.file_id='' |
| 14 | 5.028 | 1609 | SELECT frs_file.filename AS filename, frs_file.file_size AS file_size, frs_file.file_id AS file_id, frs_file.release_time AS release_time, frs_filetype.name AS type, frs_processor.name AS processor, frs_dlstats_filetotal_agg.downloads AS downloads FROM frs_filetype,frs_processor, frs_file LEFT JOIN frs_dlstats_filetotal_agg ON frs_dlstats_filetotal_agg.file_id=frs_file.file_id WHERE release_id='' AND frs_filetype.type_id=frs_file.type_id AND frs_processor.processor_id=frs_file.processor_id ORDER BY filename |
| 15 | 4.995 | 1 | COPY public.activity_log ("day", "hour", group_id, browser, ver, platform, "time", page, "type") TO stdout; |
| 16 | 4.759 | 713 | SELECT groups.group_name,groups.unix_group_name, groups.type_id,users.user_name,users.realname, news_bytes.forum_id,news_bytes.summary,news_bytes.post_date,news_bytes.details FROM users,news_bytes,groups WHERE news_bytes.group_id='' AND news_bytes.is_approved <> '' AND users.user_id=news_bytes.submitted_by AND news_bytes.group_id=groups.group_id ORDER BY post_date DESC LIMIT 0 OFFSET 0 |
| 17 | 4.401 | 3628 | select classname from supported_languages where language_code = '' |
| 18 | 4.107 | 474 | SELECT * FROM forum_group_list_vw WHERE group_forum_id='' AND group_id='' |
| 19 | 4.098 | 16 | SELECT user_name,user_id,authorized_keys |
| 20 | 3.828 | 143 | SELECT * FROM artifact_vw WHERE group_artifact_id='' AND status_id='' and (update_date>'' or message_date >'') ORDER BY group_artifact_id ASC, artifact_id ASC LIMIT 0 OFFSET 0 |
| 21 | 3.649 | 85 | SELECT * FROM artifact_vw WHERE artifact_id='' AND group_artifact_id='' |
| 22 | 3.551 | 4101 | SELECT language_id FROM supported_languages WHERE classname='' |
| 23 | 3.360 | 685 | SELECT agl.*,aca.count,aca.open_count FROM artifact_group_list agl LEFT JOIN artifact_counts_agg aca USING (group_artifact_id) WHERE agl.group_id='' AND agl.is_public=0 ORDER BY group_artifact_id ASC |
| 24 | 3.104 | 738 | SELECT users.user_id,users.user_name,users.realname FROM users,user_group WHERE user_group.user_id=users.user_id AND user_group.group_id='' AND user_group.admin_flags = '' AND users.status='' |
| 25 | 2.864 | 1 | INSERT INTO stats_agg_logo_by_day SELECT day, count(*) FROM activity_log WHERE type=0 AND day='' GROUP BY day |
| 26 | 2.853 | 7 | INSERT INTO project_counts_weekly_tmp |
| 27 | 2.748 | 716 | SELECT frs_package.package_id,frs_package.name AS package_name,frs_release.name AS release_name,frs_release.release_id AS release_id,frs_release.release_date AS release_date FROM frs_package,frs_release WHERE frs_package.package_id=frs_release.package_id AND frs_package.group_id='' AND frs_release.status_id=0 ORDER BY frs_package.package_id,frs_release.release_date DESC |
| 28 | 2.213 | 126 | SELECT groups.group_id, groups.group_name, groups.unix_group_name, groups.type_id, news_bytes.forum_id, news_bytes.summary, news_bytes.post_date, news_bytes.details FROM news_bytes, groups WHERE news_bytes.group_id=groups.group_id AND groups.status='' AND groups.is_public = 0 ORDER BY post_date DESC |
| 29 | 2.065 | 563 | SELECT * FROM artifact_group_list_vw WHERE group_artifact_id='' AND group_id='' |
| 30 | 1.905 | 238 | SELECT f.most_recent_date,users.user_name,users.realname,users.user_id,f.msg_id,f.subject,f.thread_id,(count(f0.thread_id)-0) AS followups,max(f0.post_date) AS recent FROM forum f, forum f0, users WHERE f.group_forum_id='' AND f.is_followup_to=0 AND users.user_id=f.posted_by AND f.thread_id=f0.thread_id GROUP BY f.most_recent_date,users.user_name,users.realname,users.user_id,f.msg_id,f.subject,f.thread_id ORDER BY f.most_recent_date DESC LIMIT 0 OFFSET 0 |
| 31 | 1.859 | 4101 | SELECT language_code FROM supported_languages WHERE language_id='' |
| 32 | 1.741 | 1 | COPY public.doc_data (docid, stateid, title, data, updatedate, createdate, created_by, doc_group, description, language_id, filename, filetype, group_id) TO stdout; |
| 33 | 1.682 | 141 | SELECT attnum, attname, atttypmod, attstattarget, attnotnull, atthasdef, attisdropped, attislocal, pg_catalog.format_type(atttypid,atttypmod) as atttypname from pg_catalog.pg_attribute a where attrelid = ''::pg_catalog.oid and attnum > 0::pg_catalog.int0 order by attrelid, attnum |
| 34 | 1.674 | 30 | COMMIT |
| 35 | 1.552 | 738 | SELECT name FROM people_job,people_job_category WHERE people_job.category_id=people_job_category.category_id AND people_job.status_id=0 AND group_id='' GROUP BY name LIMIT 0 OFFSET 0 |
| 36 | 1.527 | 279 | SELECT groups.group_name,groups.unix_group_name,groups.group_id,project_weekly_metric.ranking,project_weekly_metric.percentile FROM groups,project_weekly_metric WHERE groups.group_id=project_weekly_metric.group_id AND groups.is_public=0 AND groups.type_id=0 AND groups.status != '' ORDER BY ranking ASC LIMIT 0 OFFSET 0 |
| 37 | 1.518 | 1 | COPY public.frs_dlstats_file (ip_address, file_id, "month", "day", user_id) TO stdout; |
| 38 | 1.493 | 694 | SELECT * FROM frs_release WHERE package_id='' AND status_id=0 ORDER BY release_date DESC, name ASC |
| 39 | 1.464 | 257 | SELECT * FROM users WHERE user_id='' |
| 40 | 1.361 | 727 | SELECT type, count FROM project_sums_agg WHERE group_id=0 |
| 41 | 1.361 | 738 | select count(users.user_id) from user_group, users where user_group.group_id='' and users.user_id=user_group.user_id and users.status='' |
| 42 | 1.304 | 2 | SELECT 0 FROM ONLY "public"."doc_states" x WHERE "stateid" = $0 FOR UPDATE OF x |
| 43 | 1.187 | 200 | SELECT u.*,sl.language_id, sl.name, sl.filename, sl.classname, sl.language_code, t.dirname, t.fullname FROM users u, supported_languages sl, themes t WHERE u.language=sl.language_id AND u.theme_id=t.theme_id AND u.user_id='' |
| 44 | 1.101 | 351 | SELECT * FROM frs_package WHERE group_id='' AND status_id='' ORDER BY name |
| 45 | 1.088 | 55 | SELECT * FROM forum_group_list_vw WHERE group_id='' AND is_public =0 ORDER BY group_forum_id; |
| 46 | 1.058 | 1 | INSERT INTO stats_site (month,day,uniq_users,sessions,total_users,new_users,new_projects) VALUES ('', '', (SELECT COUNT(DISTINCT(user_id)) FROM user_session WHERE (time < '' AND time > '')), (SELECT COUNT(session_hash) FROM user_session WHERE (time < '' AND time > 0)), (SELECT COUNT(user_id) FROM users WHERE ( add_date < '' AND status='' )), (SELECT COUNT(user_id) FROM users WHERE ( add_date < '' AND add_date > '' )), (SELECT COUNT(group_id) FROM groups WHERE ( register_time < '' AND register_time > '' ))) |
| 47 | 1.008 | 1 | COPY public.stats_agg_site_by_group ("month", "day", group_id, count) TO stdout; |
| 48 | 0.994 | 7 | SELECT * FROM artifact_vw WHERE group_artifact_id='' and (update_date>'' or message_date >'') ORDER BY group_artifact_id ASC, artifact_id ASC LIMIT 0 OFFSET 0 |
| 49 | 0.952 | 229 | SELECT forum_id,summary,post_date,details,group_id FROM news_bytes WHERE is_approved=0 order by post_date desc LIMIT 0 OFFSET 0 |
| 50 | 0.929 | 1 | COPY public.stats_cvs_group ("month", "day", group_id, checkouts, commits, adds) TO stdout; |
| Rank | Time | Query text |
|---|
| 1 | 19.692 | SELECT rate_field,(avg(rating)+0) AS avg_rating,count(*) as count FROM user_ratings WHERE user_id='' GROUP BY rate_field |
| 2 | 12.276 | INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (0,'','','','','','','',''); |
| 3 | 6.431 | INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (0,'','','','','','','',''); |
| 4 | 4.995 | COPY public.activity_log ("day", "hour", group_id, browser, ver, platform, "time", page, "type") TO stdout; |
| 5 | 4.693 | SELECT * FROM stats_project_vw WHERE group_id='' ORDER BY month DESC, day DESC LIMIT 0 OFFSET 0 |
| 6 | 4.260 | SELECT * FROM docdata_vw WHERE group_id='' AND stateid=0 AND language_id='' ORDER BY doc_group |
| 7 | 4.084 | SELECT count(*) AS count FROM users WHERE status='' and user_id != 0 |
| 8 | 4.017 | INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (0,'','','','','','','',''); |
| 9 | 3.556 | SELECT * FROM stats_project_vw WHERE group_id='' ORDER BY month DESC, day DESC LIMIT 0 OFFSET 0 |
| 10 | 3.505 | INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (0,'','','','','','','',''); |
| 11 | 3.453 | SELECT count(*) AS count FROM users WHERE status='' and user_id != 0 |
| 12 | 3.417 | SELECT * FROM stats_project_vw WHERE group_id='' ORDER BY month DESC, day DESC LIMIT 0 OFFSET 0 |
| 13 | 3.229 | INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (0,'','','','','','','',''); |
| 14 | 2.895 | INSERT INTO frs_dlstats_file (ip_address,file_id,month,day,user_id) VALUES ('','','','','') |
| 15 | 2.864 | INSERT INTO stats_agg_logo_by_day SELECT day, count(*) FROM activity_log WHERE type=0 AND day='' GROUP BY day |
| 16 | 2.818 | INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (0,'','','','','','','',''); |
| 17 | 2.566 | SELECT user_name,user_id,authorized_keys |
| 18 | 2.541 | SELECT count(*) AS count FROM users WHERE status='' and user_id != 0 |
| 19 | 2.363 | SELECT 0 FROM ONLY "public"."country_code" x WHERE "ccode" = $0 FOR UPDATE OF x |
| 20 | 2.285 | SELECT count(*) AS count FROM users WHERE status='' and user_id != 0 |
| 21 | 2.281 | SELECT * FROM stats_project_vw WHERE group_id='' ORDER BY month DESC, day DESC LIMIT 0 OFFSET 0 |
| 22 | 1.741 | COPY public.doc_data (docid, stateid, title, data, updatedate, createdate, created_by, doc_group, description, language_id, filename, filetype, group_id) TO stdout; |
| 23 | 1.707 | SELECT frs_file.filename,frs_file.file_id,groups.unix_group_name,groups.group_id FROM frs_package,frs_release,frs_file,groups WHERE frs_release.release_id=frs_file.release_id AND groups.group_id=frs_package.group_id AND frs_release.package_id=frs_package.package_id AND frs_file.file_id='' |
| 24 | 1.538 | SELECT attnum, attname, atttypmod, attstattarget, attnotnull, atthasdef, attisdropped, attislocal, pg_catalog.format_type(atttypid,atttypmod) as atttypname from pg_catalog.pg_attribute a where attrelid = ''::pg_catalog.oid and attnum > 0::pg_catalog.int0 order by attrelid, attnum |
| 25 | 1.518 | COPY public.frs_dlstats_file (ip_address, file_id, "month", "day", user_id) TO stdout; |
| 26 | 1.435 | INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (0,'','','','','','','',''); |
| 27 | 1.434 | SELECT 0 FROM ONLY "public"."country_code" x WHERE "ccode" = $0 FOR UPDATE OF x |
| 28 | 1.313 | INSERT INTO project_counts_weekly_tmp |
| 29 | 1.291 | SELECT groups.group_name,groups.unix_group_name, groups.type_id,users.user_name,users.realname, news_bytes.forum_id,news_bytes.summary,news_bytes.post_date,news_bytes.details FROM users,news_bytes,groups WHERE news_bytes.group_id='' AND news_bytes.is_approved <> '' AND users.user_id=news_bytes.submitted_by AND news_bytes.group_id=groups.group_id ORDER BY post_date DESC LIMIT 0 OFFSET 0 |
| 30 | 1.290 | SELECT plugin_id, plugin_name FROM plugins |
| 31 | 1.259 | SELECT 0 FROM ONLY "public"."doc_states" x WHERE "stateid" = $0 FOR UPDATE OF x |
| 32 | 1.204 | INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (0,'','','','','','','',''); |
| 33 | 1.164 | INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (0,'','','','','','','',''); |
| 34 | 1.151 | SELECT frs_file.filename,frs_file.file_id,groups.unix_group_name,groups.group_id FROM frs_package,frs_release,frs_file,groups WHERE frs_release.release_id=frs_file.release_id AND groups.group_id=frs_package.group_id AND frs_release.package_id=frs_package.package_id AND frs_file.file_id='' |
| 35 | 1.097 | INSERT INTO frs_dlstats_file (ip_address,file_id,month,day,user_id) VALUES ('','','','','') |
| 36 | 1.093 | INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (0,'','','','','','','',''); |
| 37 | 1.069 | INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (0,'','','','','','','',''); |
| 38 | 1.063 | INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (0,'','','','','','','',''); |
| 39 | 1.061 | INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (0,'','','','','','','',''); |
| 40 | 1.058 | INSERT INTO stats_site (month,day,uniq_users,sessions,total_users,new_users,new_projects) VALUES ('', '', (SELECT COUNT(DISTINCT(user_id)) FROM user_session WHERE (time < '' AND time > '')), (SELECT COUNT(session_hash) FROM user_session WHERE (time < '' AND time > 0)), (SELECT COUNT(user_id) FROM users WHERE ( add_date < '' AND status='' )), (SELECT COUNT(user_id) FROM users WHERE ( add_date < '' AND add_date > '' )), (SELECT COUNT(group_id) FROM groups WHERE ( register_time < '' AND register_time > '' ))) |
| 41 | 1.008 | COPY public.stats_agg_site_by_group ("month", "day", group_id, count) TO stdout; |
| 42 | 0.968 | SELECT * FROM artifact_vw WHERE artifact_id='' AND group_artifact_id='' |
| 43 | 0.952 | COMMIT |
| 44 | 0.949 | INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (0,'','','','','','','',''); |
| 45 | 0.929 | COPY public.stats_cvs_group ("month", "day", group_id, checkouts, commits, adds) TO stdout; |
| 46 | 0.919 | INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (0,'','','','','','','',''); |
| 47 | 0.903 | INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (0,'','','','','','','',''); |
| 48 | 0.887 | COPY public.artifact_file (id, artifact_id, description, bin_data, filename, filesize, filetype, adddate, submitted_by) TO stdout; |
| 49 | 0.867 | COPY public.stats_project_developers ("month", "day", group_id, developers) TO stdout; |
| 50 | 0.850 | SELECT total FROM forum_group_list_vw WHERE group_forum_id='' |
| Rank | Times executed | Query text |
|---|
| 1 | 4778 | SELECT plugin_id, plugin_name FROM plugins |
| 2 | 4777 | INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (0,'','','','','','','',''); |
| 3 | 4420 | SELECT total FROM forum_group_list_vw WHERE group_forum_id='' |
| 4 | 4101 | SELECT language_id FROM supported_languages WHERE classname='' |
| 5 | 4101 | SELECT language_code FROM supported_languages WHERE language_id='' |
| 6 | 3628 | select classname from supported_languages where language_code = '' |
| 7 | 2765 | SELECT * FROM groups WHERE group_id='' |
| 8 | 1610 | SELECT frs_file.filename AS filename, frs_file.file_size AS file_size, frs_file.file_id AS file_id, frs_file.release_time AS release_time, frs_filetype.name AS type, frs_processor.name AS processor, frs_dlstats_filetotal_agg.downloads AS downloads FROM frs_filetype,frs_processor, frs_file LEFT JOIN frs_dlstats_filetotal_agg ON frs_dlstats_filetotal_agg.file_id=frs_file.file_id WHERE release_id='' AND frs_filetype.type_id=frs_file.type_id AND frs_processor.processor_id=frs_file.processor_id ORDER BY filename |
| 9 | 738 | SELECT name FROM people_job,people_job_category WHERE people_job.category_id=people_job_category.category_id AND people_job.status_id=0 AND group_id='' GROUP BY name LIMIT 0 OFFSET 0 |
| 10 | 738 | SELECT users.user_id,users.user_name,users.realname FROM users,user_group WHERE user_group.user_id=users.user_id AND user_group.group_id='' AND user_group.admin_flags = '' AND users.status='' |
| 11 | 738 | select count(users.user_id) from user_group, users where user_group.group_id='' and users.user_id=user_group.user_id and users.status='' |
| 12 | 728 | SELECT percentile FROM project_weekly_metric WHERE group_id='' |
| 13 | 727 | SELECT type, count FROM project_sums_agg WHERE group_id=0 |
| 14 | 716 | SELECT frs_package.package_id,frs_package.name AS package_name,frs_release.name AS release_name,frs_release.release_id AS release_id,frs_release.release_date AS release_date FROM frs_package,frs_release WHERE frs_package.package_id=frs_release.package_id AND frs_package.group_id='' AND frs_release.status_id=0 ORDER BY frs_package.package_id,frs_release.release_date DESC |
| 15 | 713 | SELECT groups.group_name,groups.unix_group_name, groups.type_id,users.user_name,users.realname, news_bytes.forum_id,news_bytes.summary,news_bytes.post_date,news_bytes.details FROM users,news_bytes,groups WHERE news_bytes.group_id='' AND news_bytes.is_approved <> '' AND users.user_id=news_bytes.submitted_by AND news_bytes.group_id=groups.group_id ORDER BY post_date DESC LIMIT 0 OFFSET 0 |
| 16 | 695 | SELECT * FROM frs_release WHERE package_id='' AND status_id=0 ORDER BY release_date DESC, name ASC |
| 17 | 687 | SELECT agl.*,aca.count,aca.open_count FROM artifact_group_list agl LEFT JOIN artifact_counts_agg aca USING (group_artifact_id) WHERE agl.group_id='' AND agl.is_public=0 ORDER BY group_artifact_id ASC |
| 18 | 618 | SELECT * FROM project_group_list WHERE group_id='' AND is_public=0 |
| 19 | 563 | SELECT * FROM artifact_group_list_vw WHERE group_artifact_id='' AND group_id='' |
| 20 | 561 | SELECT count(*) FROM snippet WHERE language=0 |
| 21 | 551 | SELECT description FROM pg_catalog.pg_description WHERE objoid = ''::pg_catalog.oid and classoid = ''::pg_catalog.regclass and objsubid = 0 |
| 22 | 474 | SELECT * FROM forum_group_list_vw WHERE group_forum_id='' AND group_id='' |
| 23 | 457 | SELECT groups.group_name,groups.unix_group_name, groups.type_id,users.user_name,users.realname, news_bytes.forum_id,news_bytes.summary,news_bytes.post_date,news_bytes.details FROM users,news_bytes,groups WHERE news_bytes.is_approved=0 AND users.user_id=news_bytes.submitted_by AND news_bytes.group_id=groups.group_id ORDER BY post_date DESC LIMIT 0 OFFSET 0 |
| 24 | 429 | SELECT count(*) FROM snippet WHERE category=0 |
| 25 | 362 | SELECT frs_file.filename,frs_file.file_id,groups.unix_group_name,groups.group_id FROM frs_package,frs_release,frs_file,groups WHERE frs_release.release_id=frs_file.release_id AND groups.group_id=frs_package.group_id AND frs_release.package_id=frs_package.package_id AND frs_file.file_id='' |
| 26 | 352 | SELECT * FROM frs_package WHERE group_id='' AND status_id='' ORDER BY name |
| 27 | 315 | SELECT * FROM user_group WHERE user_id='' AND group_id='' |
| 28 | 308 | INSERT INTO trove_treesums (trove_cat_id,subprojects) VALUES (0,0) |
| 29 | 304 | SELECT group_id FROM forum_group_list WHERE group_forum_id='' |
| 30 | 279 | SELECT count(*) AS count FROM groups WHERE status='' AND is_public=0 |
| 31 | 279 | INSERT INTO frs_dlstats_file (ip_address,file_id,month,day,user_id) VALUES ('','','','','') |
| 32 | 279 | SELECT group_id,unix_group_name,group_name,register_time FROM groups WHERE is_public=0 AND status='' AND type_id=0 AND register_time > 0 ORDER BY register_time DESC LIMIT 0 OFFSET 0 |
| 33 | 279 | SELECT groups.group_name,groups.unix_group_name,groups.group_id,project_weekly_metric.ranking,project_weekly_metric.percentile FROM groups,project_weekly_metric WHERE groups.group_id=project_weekly_metric.group_id AND groups.is_public=0 AND groups.type_id=0 AND groups.status != '' ORDER BY ranking ASC LIMIT 0 OFFSET 0 |
| 34 | 279 | SELECT count(*) AS count FROM users WHERE status='' and user_id != 0 |
| 35 | 258 | SELECT * FROM users WHERE user_id='' |
| 36 | 238 | SELECT f.most_recent_date,users.user_name,users.realname,users.user_id,f.msg_id,f.subject,f.thread_id,(count(f0.thread_id)-0) AS followups,max(f0.post_date) AS recent FROM forum f, forum f0, users WHERE f.group_forum_id='' AND f.is_followup_to=0 AND users.user_id=f.posted_by AND f.thread_id=f0.thread_id GROUP BY f.most_recent_date,users.user_name,users.realname,users.user_id,f.msg_id,f.subject,f.thread_id ORDER BY f.most_recent_date DESC LIMIT 0 OFFSET 0 |
| 37 | 230 | INSERT INTO stats_cvs_group (month,day,group_id,checkouts,commits,adds) VALUES ('','','',0,0,0) |
| 38 | 229 | SELECT forum_id,summary,post_date,details,group_id FROM news_bytes WHERE is_approved=0 order by post_date desc LIMIT 0 OFFSET 0 |
| 39 | 205 | SELECT count(*) FROM user_group WHERE user_id='' AND group_id='' AND admin_flags='' |
| 40 | 200 | SELECT * FROM user_group WHERE user_id='' AND group_id='' AND admin_flags='' |
| 41 | 200 | SELECT u.*,sl.language_id, sl.name, sl.filename, sl.classname, sl.language_code, t.dirname, t.fullname FROM users u, supported_languages sl, themes t WHERE u.language=sl.language_id AND u.theme_id=t.theme_id AND u.user_id='' |
| 42 | 197 | select id,group_name FROM artifact_group WHERE group_artifact_id='' |
| 43 | 197 | select id,category_name,auto_assign_to FROM artifact_category WHERE group_artifact_id='' ORDER BY category_name |
| 44 | 191 | SELECT classname FROM supported_languages WHERE language_id='' |
| 45 | 178 | SELECT * FROM news_bytes WHERE forum_id='' |
| 46 | 154 | select * from artifact_status |
| 47 | 154 | SELECT user_id,realname FROM artifactperm_user_vw WHERE group_artifact_id='' AND perm_level in (0,0) ORDER BY realname |
| 48 | 144 | SELECT * FROM artifact_vw WHERE group_artifact_id='' AND status_id='' and (update_date>'' or message_date >'') ORDER BY group_artifact_id ASC, artifact_id ASC LIMIT 0 OFFSET 0 |
| 49 | 141 | SELECT description, objsubid FROM pg_catalog.pg_description WHERE objoid = ''::pg_catalog.oid and classoid = ''::pg_catalog.regclass ORDER BY objoid, classoid, objsubid |
| 50 | 141 | SELECT attnum, attname, atttypmod, attstattarget, attnotnull, atthasdef, attisdropped, attislocal, pg_catalog.format_type(atttypid,atttypmod) as atttypname from pg_catalog.pg_attribute a where attrelid = ''::pg_catalog.oid and attnum > 0::pg_catalog.int0 order by attrelid, attnum |