Hello,

(default) 326 queries took 206 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';10910914
2SELECT matviewname as name FROM pg_matviews;001
3SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
4SELECT matviewname as name FROM pg_matviews;001
5SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
6SELECT matviewname as name FROM pg_matviews;001
7SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
8SELECT matviewname as name FROM pg_matviews;001
9SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
10SELECT matviewname as name FROM pg_matviews;001
11SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
12SELECT matviewname as name FROM pg_matviews;001
13SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
14SELECT matviewname as name FROM pg_matviews;001
15SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
16SELECT matviewname as name FROM pg_matviews;001
17SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
18SELECT matviewname as name FROM pg_matviews;001
19SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
20SELECT matviewname as name FROM pg_matviews;001
21SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
22SELECT matviewname as name FROM pg_matviews;001
23SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
24SELECT matviewname as name FROM pg_matviews;001
25SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
26SELECT matviewname as name FROM pg_matviews;001
27SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
28SELECT matviewname as name FROM pg_matviews;001
29SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
30SELECT matviewname as name FROM pg_matviews;001
31SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
32SELECT matviewname as name FROM pg_matviews;001
33SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
34SELECT matviewname as name FROM pg_matviews;001
35SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
36SELECT matviewname as name FROM pg_matviews;001
37SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
38SELECT matviewname as name FROM pg_matviews;001
39SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
40SELECT matviewname as name FROM pg_matviews;001
41SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
42SELECT matviewname as name FROM pg_matviews;001
43SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
44SELECT matviewname as name FROM pg_matviews;001
45SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
46SELECT matviewname as name FROM pg_matviews;001
47SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
48SELECT matviewname as name FROM pg_matviews;001
49SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
50SELECT matviewname as name FROM pg_matviews;001
51SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
52SELECT matviewname as name FROM pg_matviews;001
53SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
54SELECT matviewname as name FROM pg_matviews;001
55SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
56SELECT matviewname as name FROM pg_matviews;001
57SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
58SELECT matviewname as name FROM pg_matviews;001
59SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
60SELECT matviewname as name FROM pg_matviews;001
61SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
62SELECT matviewname as name FROM pg_matviews;001
63SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
64SELECT matviewname as name FROM pg_matviews;001
65SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
66SELECT matviewname as name FROM pg_matviews;001
67SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
68SELECT matviewname as name FROM pg_matviews;001
69SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
70SELECT matviewname as name FROM pg_matviews;001
71SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
72SELECT matviewname as name FROM pg_matviews;001
73SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
74SELECT matviewname as name FROM pg_matviews;001
75SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
76SELECT matviewname as name FROM pg_matviews;001
77SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
78SELECT matviewname as name FROM pg_matviews;001
79SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
80SELECT matviewname as name FROM pg_matviews;001
81SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
82SELECT matviewname as name FROM pg_matviews;001
83SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
84SELECT matviewname as name FROM pg_matviews;001
85SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
86SELECT matviewname as name FROM pg_matviews;001
87SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
88SELECT matviewname as name FROM pg_matviews;001
89SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
90SELECT matviewname as name FROM pg_matviews;001
91SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
92SELECT matviewname as name FROM pg_matviews;001
93SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public' OR table_schema = 'targets' OR table_schema = 'users' OR table_schema = 'homology' OR table_schema = 'synchrotrons' OR table_schema = 'experiments' OR table_schema = 'tigr' OR table_schema = 'ncbi' OR table_schema = 'ligands' OR table_schema = 'taxonomy' OR table_schema = 'community' OR table_schema = 'csgid' OR table_schema = 'nysgrc' OR table_schema = 'mcsg' OR table_schema = 'mypdb';1091093
94SELECT matviewname as name FROM pg_matviews;001
95SELECT "User"."id" AS "User__id", "User"."username" AS "User__username", "User"."password" AS "User__password", "User"."email" AS "User__email", "User"."staff_id" AS "User__staff_id", "User"."last_login" AS "User__last_login", "User"."last_operation" AS "User__last_operation", "User"."request_person_id" AS "User__request_person_id", "User"."access_group_id" AS "User__access_group_id", "Staff"."id" AS "Staff__id", "Staff"."first_name" AS "Staff__first_name", "Staff"."last_name" AS "Staff__last_name", "Staff"."email" AS "Staff__email", "Staff"."phone" AS "Staff__phone", "Staff"."lab_id" AS "Staff__lab_id", "Staff"."responsibility" AS "Staff__responsibility", "Staff"."databases" AS "Staff__databases", "Staff"."admin" AS "Staff__admin", "Staff"."protein_production" AS "Staff__protein_production", "Staff"."crystallography" AS "Staff__crystallography", "Staff"."pi" AS "Staff__pi", "Staff"."lab_contact" AS "Staff__lab_contact", "Staff"."inserted" AS "Staff__inserted", "Staff"."updated" AS "Staff__updated", "Staff"."institution_id" AS "Staff__institution_id", "Staff"."middle_initials" AS "Staff__middle_initials", "Staff"."active" AS "Staff__active", "Staff"."manager" AS "Staff__manager", "Staff"."function" AS "Staff__function", "Staff"."real_id" AS "Staff__real_id" FROM "user_view" AS "User" LEFT JOIN "staff" AS "Staff" ON ("User"."staff_id" = "Staff"."id") WHERE "User"."username" = 'Nobody' LIMIT 1002
96SELECT "User"."id" AS "User__id", "User"."username" AS "User__username", "User"."password" AS "User__password", "User"."email" AS "User__email", "User"."staff_id" AS "User__staff_id", "User"."last_login" AS "User__last_login", "User"."last_operation" AS "User__last_operation", "User"."request_person_id" AS "User__request_person_id", "User"."access_group_id" AS "User__access_group_id", "Staff"."id" AS "Staff__id", "Staff"."first_name" AS "Staff__first_name", "Staff"."last_name" AS "Staff__last_name", "Staff"."email" AS "Staff__email", "Staff"."phone" AS "Staff__phone", "Staff"."lab_id" AS "Staff__lab_id", "Staff"."responsibility" AS "Staff__responsibility", "Staff"."databases" AS "Staff__databases", "Staff"."admin" AS "Staff__admin", "Staff"."protein_production" AS "Staff__protein_production", "Staff"."crystallography" AS "Staff__crystallography", "Staff"."pi" AS "Staff__pi", "Staff"."lab_contact" AS "Staff__lab_contact", "Staff"."inserted" AS "Staff__inserted", "Staff"."updated" AS "Staff__updated", "Staff"."institution_id" AS "Staff__institution_id", "Staff"."middle_initials" AS "Staff__middle_initials", "Staff"."active" AS "Staff__active", "Staff"."manager" AS "Staff__manager", "Staff"."function" AS "Staff__function", "Staff"."real_id" AS "Staff__real_id" FROM "user_view" AS "User" LEFT JOIN "staff" AS "Staff" ON ("User"."staff_id" = "Staff"."id") WHERE "User"."username" = 'Nobody' LIMIT 1001
97SELECT "User"."id" AS "User__id", "User"."username" AS "User__username", "User"."password" AS "User__password", "User"."email" AS "User__email", "User"."staff_id" AS "User__staff_id", "User"."last_login" AS "User__last_login", "User"."last_operation" AS "User__last_operation", "User"."request_person_id" AS "User__request_person_id", "User"."access_group_id" AS "User__access_group_id", "Staff"."id" AS "Staff__id", "Staff"."first_name" AS "Staff__first_name", "Staff"."last_name" AS "Staff__last_name", "Staff"."email" AS "Staff__email", "Staff"."phone" AS "Staff__phone", "Staff"."lab_id" AS "Staff__lab_id", "Staff"."responsibility" AS "Staff__responsibility", "Staff"."databases" AS "Staff__databases", "Staff"."admin" AS "Staff__admin", "Staff"."protein_production" AS "Staff__protein_production", "Staff"."crystallography" AS "Staff__crystallography", "Staff"."pi" AS "Staff__pi", "Staff"."lab_contact" AS "Staff__lab_contact", "Staff"."inserted" AS "Staff__inserted", "Staff"."updated" AS "Staff__updated", "Staff"."institution_id" AS "Staff__institution_id", "Staff"."middle_initials" AS "Staff__middle_initials", "Staff"."active" AS "Staff__active", "Staff"."manager" AS "Staff__manager", "Staff"."function" AS "Staff__function", "Staff"."real_id" AS "Staff__real_id" FROM "user_view" AS "User" LEFT JOIN "staff" AS "Staff" ON ("User"."staff_id" = "Staff"."id") WHERE "User"."id" IS NULL LIMIT 1001
98SELECT "Staff"."lab_id" AS "Staff__lab_id" FROM "staff" AS "Staff" WHERE "Staff"."id" IS NULL LIMIT 1000
99SELECT "User"."id" AS "User__id", "Staff"."last_name" AS "Staff__last_name", "Staff"."first_name" AS "Staff__first_name" FROM "staff" AS "Staff" LEFT JOIN "user_view" AS "User" ON ("User"."staff_id" = "Staff"."id") WHERE "lab_id" IS NULL 000
100Select distinct short from lab14141
101Select distinct staff_id from center_user1811811
102Select distinct last_name, first_name, id from staff where lab_id = 'UCSF' order by last_name, first_name;21210
103Select id from center_user where staff_id = '449736'110
104Select id from center_user where staff_id = '2653'110
105Select id from center_user where staff_id = '2596'110
106Select id from center_user where staff_id = '2619'110
107Select id from center_user where staff_id = '2628'110
108Select id from center_user where staff_id = '2620'110
109Select id from center_user where staff_id = '2625'110
110Select id from center_user where staff_id = '2603'110
111Select id from center_user where staff_id = '2655'110
112Select id from center_user where staff_id = '11429'110
113Select id from center_user where staff_id = '2614'110
114Select id from center_user where staff_id = '2652'110
115Select id from center_user where staff_id = '2605'110
116Select id from center_user where staff_id = '2608'110
117Select id from center_user where staff_id = '2609'110
118Select id from center_user where staff_id = '2657'110
119Select id from center_user where staff_id = '2626'110
120Select id from center_user where staff_id = '438205'110
121Select id from center_user where staff_id = '2651'110
122Select id from center_user where staff_id = '2612'110
123Select id from center_user where staff_id = '2613'110
124Select distinct last_name, first_name, id from staff where lab_id = 'CELLMAT' order by last_name, first_name;16160
125Select id from center_user where staff_id = '2597'110
126Select id from center_user where staff_id = '2642'110
127Select id from center_user where staff_id = '2636'110
128Select id from center_user where staff_id = '2635'110
129Select id from center_user where staff_id = '2637'110
130Select id from center_user where staff_id = '2643'110
131Select id from center_user where staff_id = '2644'110
132Select id from center_user where staff_id = '2634'110
133Select id from center_user where staff_id = '2645'110
134Select id from center_user where staff_id = '2598'110
135Select id from center_user where staff_id = '2649'110
136Select id from center_user where staff_id = '2640'110
137Select id from center_user where staff_id = '2647'110
138Select id from center_user where staff_id = '2633'110
139Select id from center_user where staff_id = '2650'110
140Select id from center_user where staff_id = '2646'110
141Select distinct last_name, first_name, id from staff where lab_id = 'UTAH' order by last_name, first_name;550
142Select id from center_user where staff_id = '423639'110
143Select id from center_user where staff_id = '2616'110
144Select id from center_user where staff_id = '2627'110
145Select id from center_user where staff_id = '2638'110
146Select id from center_user where staff_id = '2607'110
147Select distinct last_name, first_name, id from staff where lab_id = 'BNL' order by last_name, first_name;770
148Select id from center_user where staff_id = '288'110
149Select id from center_user where staff_id = '287'110
150Select id from center_user where staff_id = '424'110
151Select id from center_user where staff_id = '286'110
152Select id from center_user where staff_id = '3147'110
153Select id from center_user where staff_id = '208'110
154Select id from center_user where staff_id = '392'110
155Select distinct last_name, first_name, id from staff where lab_id = 'UVA' order by last_name, first_name;53530
156Select id from center_user where staff_id = '450220'110
157Select id from center_user where staff_id = '30'110
158Select id from center_user where staff_id = '450243'110
159Select id from center_user where staff_id = '87'110
160Select id from center_user where staff_id = '445495'110
161Select id from center_user where staff_id = '120'110
162Select id from center_user where staff_id = '62'220
163Select id from center_user where staff_id = '108'110
164Select id from center_user where staff_id = '450654'110
165Select id from center_user where staff_id = '14'110
166Select id from center_user where staff_id = '449527'110
167Select id from center_user where staff_id = '106'110
168Select id from center_user where staff_id = '77'110
169Select id from center_user where staff_id = '19533'110
170Select id from center_user where staff_id = '3464024'110
171Select id from center_user where staff_id = '449673'110
172Select id from center_user where staff_id = '94'110
173Select id from center_user where staff_id = '17'110
174Select id from center_user where staff_id = '450655'110
175Select id from center_user where staff_id = '124'110
176Select id from center_user where staff_id = '2484'110
177Select id from center_user where staff_id = '61'110
178Select id from center_user where staff_id = '123'110
179Select id from center_user where staff_id = '449608'110
180Select id from center_user where staff_id = '93'110
181Select id from center_user where staff_id = '3463499'110
182Select id from center_user where staff_id = '450270'110
183Select id from center_user where staff_id = '450494'110
184Select id from center_user where staff_id = '450314'110
185Select id from center_user where staff_id = '420'110
186Select id from center_user where staff_id = '391'110
187Select id from center_user where staff_id = '129'110
188Select id from center_user where staff_id = '15'110
189Select distinct last_name, first_name, id from staff where lab_id = 'AECOM' order by last_name, first_name;58580
190Select id from center_user where staff_id = '1825'110
191Select id from center_user where staff_id = '285'110
192Select id from center_user where staff_id = '370'110
193Select id from center_user where staff_id = '450145'110
194Select id from center_user where staff_id = '3143'110
195Select id from center_user where staff_id = '249'110
196Select id from center_user where staff_id = '214'110
197Select id from center_user where staff_id = '3463458'110
198Select id from center_user where staff_id = '450083'110
199Select id from center_user where staff_id = '245'110
200Select id from center_user where staff_id = '421'110
201Select id from center_user where staff_id = '415'110
202Select id from center_user where staff_id = '396'220
203Select id from center_user where staff_id = '284'110
204Select id from center_user where staff_id = '251'110
205Select id from center_user where staff_id = '250'110
206Select id from center_user where staff_id = '212'110
207Select id from center_user where staff_id = '22'110
208Select id from center_user where staff_id = '355'110
209Select id from center_user where staff_id = '242'110
210Select id from center_user where staff_id = '416'220
211Select id from center_user where staff_id = '419'110
212Select id from center_user where staff_id = '243'110
213Select id from center_user where staff_id = '423'110
214Select id from center_user where staff_id = '217'110
215Select id from center_user where staff_id = '429'110
216Select id from center_user where staff_id = '414'110
217Select id from center_user where staff_id = '17275'110
218Select id from center_user where staff_id = '216'220
219Select id from center_user where staff_id = '2059'110
220Select id from center_user where staff_id = '23'110
221Select id from center_user where staff_id = '11420'110
222Select id from center_user where staff_id = '254'110
223Select id from center_user where staff_id = '422'110
224Select id from center_user where staff_id = '417'110
225Select id from center_user where staff_id = '244'110
226Select id from center_user where staff_id = '451598'110
227Select id from center_user where staff_id = '450275'110
228Select id from center_user where staff_id = '211'110
229Select id from center_user where staff_id = '246'110
230Select id from center_user where staff_id = '431'110
231Select id from center_user where staff_id = '252'110
232Select id from center_user where staff_id = '253'110
233Select id from center_user where staff_id = '241'110
234Select id from center_user where staff_id = '418'110
235Select id from center_user where staff_id = '210'110
236Select id from center_user where staff_id = '430'110
237Select id from center_user where staff_id = '213'110
238Select id from center_user where staff_id = '2483'110
239Select id from center_user where staff_id = '19200'110
240Select id from center_user where staff_id = '247'110
241Select id from center_user where staff_id = '209'110
242Select id from center_user where staff_id = '394'110
243Select id from center_user where staff_id = '3463614'110
244Select id from center_user where staff_id = '215'110
245Select distinct last_name, first_name, id from staff where lab_id = 'NPCXstals' order by last_name, first_name;110
246Select id from center_user where staff_id = '2662'110
247Select distinct last_name, first_name, id from staff where lab_id = 'TAMU' order by last_name, first_name;440
248Select id from center_user where staff_id = '2622'110
249Select id from center_user where staff_id = '2630'110
250Select id from center_user where staff_id = '2606'110
251Select id from center_user where staff_id = '2600'110
252Select distinct last_name, first_name, id from staff where lab_id = 'NYCOLLAB' order by last_name, first_name;000
253Select distinct last_name, first_name, id from staff where lab_id = 'BU' order by last_name, first_name;440
254Select id from center_user where staff_id = '2617'110
255Select id from center_user where staff_id = '2615'110
256Select id from center_user where staff_id = '450539'110
257Select id from center_user where staff_id = '2658'110
258Select distinct last_name, first_name, id from staff where lab_id = 'UNM' order by last_name, first_name;550
259Select id from center_user where staff_id = '2623'110
260Select id from center_user where staff_id = '2602'110
261Select id from center_user where staff_id = '3145'110
262Select id from center_user where staff_id = '3144'110
263Select id from center_user where staff_id = '3146'110
264Select distinct last_name, first_name, id from staff where lab_id = 'VU' order by last_name, first_name;550
265Select id from center_user where staff_id = '2618'110
266Select id from center_user where staff_id = '2629'110
267Select id from center_user where staff_id = '2654'110
268Select id from center_user where staff_id = '6548'110
269Select id from center_user where staff_id = '2611'110
270Select distinct last_name, first_name, id from staff where lab_id = 'UIUC' order by last_name, first_name;20200
271Select id from center_user where staff_id = '413'110
272Select id from center_user where staff_id = '3463355'110
273Select id from center_user where staff_id = '2621'110
274Select id from center_user where staff_id = '2624'110
275Select id from center_user where staff_id = '2641'110
276Select id from center_user where staff_id = '2631'110
277Select id from center_user where staff_id = '2604'110
278Select id from center_user where staff_id = '2599'110
279Select id from center_user where staff_id = '2648'110
280Select id from center_user where staff_id = '2639'110
281Select id from center_user where staff_id = '450621'110
282Select id from center_user where staff_id = '450461'110
283Select id from center_user where staff_id = '3463816'110
284Select id from center_user where staff_id = '2601'110
285Select id from center_user where staff_id = '17916'110
286Select id from center_user where staff_id = '2610'110
287Select id from center_user where staff_id = '450215'110
288Select id from center_user where staff_id = '428'110
289Select id from center_user where staff_id = '2632'110
290Select id from center_user where staff_id = '450140'110
291Select distinct last_name, first_name, id from staff where lab_id = 'IFN' order by last_name, first_name;440
292Select id from center_user where staff_id = '6682'110
293Select id from center_user where staff_id = '2661'110
294Select id from center_user where staff_id = '3148'110
295Select id from center_user where staff_id = '3341'110
296SELECT "RequestPerson"."person_id" AS "RequestPerson__person_id", "RequestPerson"."firstname" AS "RequestPerson__firstname", "RequestPerson"."lastname" AS "RequestPerson__lastname" FROM "request_person" AS "RequestPerson" WHERE 1 = 1 ORDER BY "lastname" ASC 30301
297SELECT "User"."id" AS "User__id" FROM "user_view" AS "User" WHERE "request_person_id" = '40' LIMIT 1000
298SELECT "User"."id" AS "User__id" FROM "user_view" AS "User" WHERE "request_person_id" = '7' LIMIT 1000
299SELECT "User"."id" AS "User__id" FROM "user_view" AS "User" WHERE "request_person_id" = '24' LIMIT 1000
300SELECT "User"."id" AS "User__id" FROM "user_view" AS "User" WHERE "request_person_id" = '39' LIMIT 1000
301SELECT "User"."id" AS "User__id" FROM "user_view" AS "User" WHERE "request_person_id" = '27' LIMIT 1000
302SELECT "User"."id" AS "User__id" FROM "user_view" AS "User" WHERE "request_person_id" = '30' LIMIT 1000
303SELECT "User"."id" AS "User__id" FROM "user_view" AS "User" WHERE "request_person_id" = '29' LIMIT 1000
304SELECT "User"."id" AS "User__id" FROM "user_view" AS "User" WHERE "request_person_id" = '37' LIMIT 1000
305SELECT "User"."id" AS "User__id" FROM "user_view" AS "User" WHERE "request_person_id" = '1' LIMIT 1000
306SELECT "User"."id" AS "User__id" FROM "user_view" AS "User" WHERE "request_person_id" = '6' LIMIT 1000
307SELECT "User"."id" AS "User__id" FROM "user_view" AS "User" WHERE "request_person_id" = '8' LIMIT 1000
308SELECT "User"."id" AS "User__id" FROM "user_view" AS "User" WHERE "request_person_id" = '23' LIMIT 1000
309SELECT "User"."id" AS "User__id" FROM "user_view" AS "User" WHERE "request_person_id" = '31' LIMIT 1000
310SELECT "User"."id" AS "User__id" FROM "user_view" AS "User" WHERE "request_person_id" = '5' LIMIT 1000
311SELECT "User"."id" AS "User__id" FROM "user_view" AS "User" WHERE "request_person_id" = '34' LIMIT 1000
312SELECT "User"."id" AS "User__id" FROM "user_view" AS "User" WHERE "request_person_id" = '21' LIMIT 1000
313SELECT "User"."id" AS "User__id" FROM "user_view" AS "User" WHERE "request_person_id" = '26' LIMIT 1000
314SELECT "User"."id" AS "User__id" FROM "user_view" AS "User" WHERE "request_person_id" = '33' LIMIT 1000
315SELECT "User"."id" AS "User__id" FROM "user_view" AS "User" WHERE "request_person_id" = '3' LIMIT 1000
316SELECT "User"."id" AS "User__id" FROM "user_view" AS "User" WHERE "request_person_id" = '9' LIMIT 1000
317SELECT "User"."id" AS "User__id" FROM "user_view" AS "User" WHERE "request_person_id" = '2' LIMIT 1000
318SELECT "User"."id" AS "User__id" FROM "user_view" AS "User" WHERE "request_person_id" = '28' LIMIT 1000
319SELECT "User"."id" AS "User__id" FROM "user_view" AS "User" WHERE "request_person_id" = '35' LIMIT 1000
320SELECT "User"."id" AS "User__id" FROM "user_view" AS "User" WHERE "request_person_id" = '4' LIMIT 1000
321SELECT "User"."id" AS "User__id" FROM "user_view" AS "User" WHERE "request_person_id" = '32' LIMIT 1000
322SELECT "User"."id" AS "User__id" FROM "user_view" AS "User" WHERE "request_person_id" = '36' LIMIT 1000
323SELECT "User"."id" AS "User__id" FROM "user_view" AS "User" WHERE "request_person_id" = '38' LIMIT 1000
324SELECT "User"."id" AS "User__id" FROM "user_view" AS "User" WHERE "request_person_id" = '22' LIMIT 1000
325SELECT "User"."id" AS "User__id" FROM "user_view" AS "User" WHERE "request_person_id" = '25' LIMIT 1000
326SELECT "User"."id" AS "User__id" FROM "user_view" AS "User" WHERE "request_person_id" = '10' LIMIT 1000
(labdb) 2 queries took 3 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'hkldb' OR table_schema = 'pepdb' OR table_schema = 'xtaldb' OR table_schema = 'public';2932932
2SELECT matviewname as name FROM pg_matviews;001