SQL Query Analysis (generated Mon Jun 07 14:20:04 EDT 2004)



Reports
Overall statistics
Queries by type
Queries that took up the most time
Slowest queries
Most frequent queries

Overall statistics

50221 queries
687 unique queries
Total query duration was 395.15 seconds
Longest query (SELECT rate_field,(avg(rating)+0) AS avg_rating,count(*) as count FROM user_ratings WHERE user_id='' GROUP BY rate_field) ran in 19.692 seconds
Shortest query (SET TRANSACTION ISOLATION LEVEL SERIALIZABLE) ran in 0.000 seconds
Log file parsed in 12.6 seconds

Queries by type

TypeCountPercentage
SELECT4414188
INSERT568811
UPDATE340
DELETE350

Queries that took up the most time

RankTotal time (seconds)Times executedQuery text
1107.6624741INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (0,'','','','','','','','');
236.013279SELECT count(*) AS count FROM users WHERE status='' and user_id != 0
324.29526SELECT * FROM stats_project_vw WHERE group_id='' ORDER BY month DESC, day DESC LIMIT 0 OFFSET 0
420.11175SELECT rate_field,(avg(rating)+0) AS avg_rating,count(*) as count FROM user_ratings WHERE user_id='' GROUP BY rate_field
519.405230INSERT INTO stats_cvs_group (month,day,group_id,checkouts,commits,adds) VALUES ('','','',0,0,0)
615.1594778SELECT plugin_id, plugin_name FROM plugins
78.38221SELECT 0 FROM ONLY "public"."country_code" x WHERE "ccode" = $0 FOR UPDATE OF x
88.154457SELECT 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
97.6834417SELECT total FROM forum_group_list_vw WHERE group_forum_id=''
107.292278INSERT INTO frs_dlstats_file (ip_address,file_id,month,day,user_id) VALUES ('','','','','')
116.5292749SELECT * FROM groups WHERE group_id=''
125.85991SELECT * FROM docdata_vw WHERE group_id='' AND stateid=0 AND language_id='' ORDER BY doc_group
135.779362SELECT 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=''
145.0281609SELECT 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
154.9951COPY public.activity_log ("day", "hour", group_id, browser, ver, platform, "time", page, "type") TO stdout;
164.759713SELECT 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
174.4013628select classname from supported_languages where language_code = ''
184.107474SELECT * FROM forum_group_list_vw WHERE group_forum_id='' AND group_id=''
194.09816SELECT user_name,user_id,authorized_keys
203.828143SELECT * 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
213.64985SELECT * FROM artifact_vw WHERE artifact_id='' AND group_artifact_id=''
223.5514101SELECT language_id FROM supported_languages WHERE classname=''
233.360685SELECT 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
243.104738SELECT 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=''
252.8641INSERT INTO stats_agg_logo_by_day SELECT day, count(*) FROM activity_log WHERE type=0 AND day='' GROUP BY day
262.8537INSERT INTO project_counts_weekly_tmp
272.748716SELECT 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
282.213126SELECT 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
292.065563SELECT * FROM artifact_group_list_vw WHERE group_artifact_id='' AND group_id=''
301.905238SELECT 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
311.8594101SELECT language_code FROM supported_languages WHERE language_id=''
321.7411COPY public.doc_data (docid, stateid, title, data, updatedate, createdate, created_by, doc_group, description, language_id, filename, filetype, group_id) TO stdout;
331.682141SELECT 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
341.67430COMMIT
351.552738SELECT 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
361.527279SELECT 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
371.5181COPY public.frs_dlstats_file (ip_address, file_id, "month", "day", user_id) TO stdout;
381.493694SELECT * FROM frs_release WHERE package_id='' AND status_id=0 ORDER BY release_date DESC, name ASC
391.464257SELECT * FROM users WHERE user_id=''
401.361727SELECT type, count FROM project_sums_agg WHERE group_id=0
411.361738select count(users.user_id) from user_group, users where user_group.group_id='' and users.user_id=user_group.user_id and users.status=''
421.3042SELECT 0 FROM ONLY "public"."doc_states" x WHERE "stateid" = $0 FOR UPDATE OF x
431.187200SELECT 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=''
441.101351SELECT * FROM frs_package WHERE group_id='' AND status_id='' ORDER BY name
451.08855SELECT * FROM forum_group_list_vw WHERE group_id='' AND is_public =0 ORDER BY group_forum_id;
461.0581INSERT 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 > '' )))
471.0081COPY public.stats_agg_site_by_group ("month", "day", group_id, count) TO stdout;
480.9947SELECT * 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
490.952229SELECT forum_id,summary,post_date,details,group_id FROM news_bytes WHERE is_approved=0 order by post_date desc LIMIT 0 OFFSET 0
500.9291COPY public.stats_cvs_group ("month", "day", group_id, checkouts, commits, adds) TO stdout;

Slowest queries

RankTimeQuery text
119.692SELECT rate_field,(avg(rating)+0) AS avg_rating,count(*) as count FROM user_ratings WHERE user_id='' GROUP BY rate_field
212.276INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (0,'','','','','','','','');
36.431INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (0,'','','','','','','','');
44.995COPY public.activity_log ("day", "hour", group_id, browser, ver, platform, "time", page, "type") TO stdout;
54.693SELECT * FROM stats_project_vw WHERE group_id='' ORDER BY month DESC, day DESC LIMIT 0 OFFSET 0
64.260SELECT * FROM docdata_vw WHERE group_id='' AND stateid=0 AND language_id='' ORDER BY doc_group
74.084SELECT count(*) AS count FROM users WHERE status='' and user_id != 0
84.017INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (0,'','','','','','','','');
93.556SELECT * FROM stats_project_vw WHERE group_id='' ORDER BY month DESC, day DESC LIMIT 0 OFFSET 0
103.505INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (0,'','','','','','','','');
113.453SELECT count(*) AS count FROM users WHERE status='' and user_id != 0
123.417SELECT * FROM stats_project_vw WHERE group_id='' ORDER BY month DESC, day DESC LIMIT 0 OFFSET 0
133.229INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (0,'','','','','','','','');
142.895INSERT INTO frs_dlstats_file (ip_address,file_id,month,day,user_id) VALUES ('','','','','')
152.864INSERT INTO stats_agg_logo_by_day SELECT day, count(*) FROM activity_log WHERE type=0 AND day='' GROUP BY day
162.818INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (0,'','','','','','','','');
172.566SELECT user_name,user_id,authorized_keys
182.541SELECT count(*) AS count FROM users WHERE status='' and user_id != 0
192.363SELECT 0 FROM ONLY "public"."country_code" x WHERE "ccode" = $0 FOR UPDATE OF x
202.285SELECT count(*) AS count FROM users WHERE status='' and user_id != 0
212.281SELECT * FROM stats_project_vw WHERE group_id='' ORDER BY month DESC, day DESC LIMIT 0 OFFSET 0
221.741COPY public.doc_data (docid, stateid, title, data, updatedate, createdate, created_by, doc_group, description, language_id, filename, filetype, group_id) TO stdout;
231.707SELECT 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=''
241.538SELECT 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
251.518COPY public.frs_dlstats_file (ip_address, file_id, "month", "day", user_id) TO stdout;
261.435INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (0,'','','','','','','','');
271.434SELECT 0 FROM ONLY "public"."country_code" x WHERE "ccode" = $0 FOR UPDATE OF x
281.313INSERT INTO project_counts_weekly_tmp
291.291SELECT 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
301.290SELECT plugin_id, plugin_name FROM plugins
311.259SELECT 0 FROM ONLY "public"."doc_states" x WHERE "stateid" = $0 FOR UPDATE OF x
321.204INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (0,'','','','','','','','');
331.164INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (0,'','','','','','','','');
341.151SELECT 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=''
351.097INSERT INTO frs_dlstats_file (ip_address,file_id,month,day,user_id) VALUES ('','','','','')
361.093INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (0,'','','','','','','','');
371.069INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (0,'','','','','','','','');
381.063INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (0,'','','','','','','','');
391.061INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (0,'','','','','','','','');
401.058INSERT 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 > '' )))
411.008COPY public.stats_agg_site_by_group ("month", "day", group_id, count) TO stdout;
420.968SELECT * FROM artifact_vw WHERE artifact_id='' AND group_artifact_id=''
430.952COMMIT
440.949INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (0,'','','','','','','','');
450.929COPY public.stats_cvs_group ("month", "day", group_id, checkouts, commits, adds) TO stdout;
460.919INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (0,'','','','','','','','');
470.903INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (0,'','','','','','','','');
480.887COPY public.artifact_file (id, artifact_id, description, bin_data, filename, filesize, filetype, adddate, submitted_by) TO stdout;
490.867COPY public.stats_project_developers ("month", "day", group_id, developers) TO stdout;
500.850SELECT total FROM forum_group_list_vw WHERE group_forum_id=''

Most frequent queries

RankTimes executedQuery text
14778SELECT plugin_id, plugin_name FROM plugins
24777INSERT INTO activity_log (day,hour,group_id,browser,ver,platform,time,page,type) VALUES (0,'','','','','','','','');
34420SELECT total FROM forum_group_list_vw WHERE group_forum_id=''
44101SELECT language_id FROM supported_languages WHERE classname=''
54101SELECT language_code FROM supported_languages WHERE language_id=''
63628select classname from supported_languages where language_code = ''
72765SELECT * FROM groups WHERE group_id=''
81610SELECT 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
9738SELECT 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
10738SELECT 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=''
11738select count(users.user_id) from user_group, users where user_group.group_id='' and users.user_id=user_group.user_id and users.status=''
12728SELECT percentile FROM project_weekly_metric WHERE group_id=''
13727SELECT type, count FROM project_sums_agg WHERE group_id=0
14716SELECT 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
15713SELECT 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
16695SELECT * FROM frs_release WHERE package_id='' AND status_id=0 ORDER BY release_date DESC, name ASC
17687SELECT 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
18618SELECT * FROM project_group_list WHERE group_id='' AND is_public=0
19563SELECT * FROM artifact_group_list_vw WHERE group_artifact_id='' AND group_id=''
20561SELECT count(*) FROM snippet WHERE language=0
21551SELECT description FROM pg_catalog.pg_description WHERE objoid = ''::pg_catalog.oid and classoid = ''::pg_catalog.regclass and objsubid = 0
22474SELECT * FROM forum_group_list_vw WHERE group_forum_id='' AND group_id=''
23457SELECT 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
24429SELECT count(*) FROM snippet WHERE category=0
25362SELECT 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=''
26352SELECT * FROM frs_package WHERE group_id='' AND status_id='' ORDER BY name
27315SELECT * FROM user_group WHERE user_id='' AND group_id=''
28308INSERT INTO trove_treesums (trove_cat_id,subprojects) VALUES (0,0)
29304SELECT group_id FROM forum_group_list WHERE group_forum_id=''
30279SELECT count(*) AS count FROM groups WHERE status='' AND is_public=0
31279INSERT INTO frs_dlstats_file (ip_address,file_id,month,day,user_id) VALUES ('','','','','')
32279SELECT 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
33279SELECT 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
34279SELECT count(*) AS count FROM users WHERE status='' and user_id != 0
35258SELECT * FROM users WHERE user_id=''
36238SELECT 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
37230INSERT INTO stats_cvs_group (month,day,group_id,checkouts,commits,adds) VALUES ('','','',0,0,0)
38229SELECT forum_id,summary,post_date,details,group_id FROM news_bytes WHERE is_approved=0 order by post_date desc LIMIT 0 OFFSET 0
39205SELECT count(*) FROM user_group WHERE user_id='' AND group_id='' AND admin_flags=''
40200SELECT * FROM user_group WHERE user_id='' AND group_id='' AND admin_flags=''
41200SELECT 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=''
42197select id,group_name FROM artifact_group WHERE group_artifact_id=''
43197select id,category_name,auto_assign_to FROM artifact_category WHERE group_artifact_id='' ORDER BY category_name
44191SELECT classname FROM supported_languages WHERE language_id=''
45178SELECT * FROM news_bytes WHERE forum_id=''
46154select * from artifact_status
47154SELECT user_id,realname FROM artifactperm_user_vw WHERE group_artifact_id='' AND perm_level in (0,0) ORDER BY realname
48144SELECT * 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
49141SELECT description, objsubid FROM pg_catalog.pg_description WHERE objoid = ''::pg_catalog.oid and classoid = ''::pg_catalog.regclass ORDER BY objoid, classoid, objsubid
50141SELECT 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