CDS Home Page
Jump to the VizieR home page
VizieR Search Page
  
META
  VizieR META catalogue
Describes the Catalogues and Tables accessible via VizieR (also called ReferenceDirectory)
Post annotation
img(gal)
1.METAtabContains details of all tables; PK=(catid,tabid) (44 rows) (released 2010-04-19)
[METAtab] [METAcola]

 
Query by Constraints constraints help applied on Columns (Output Order: + - ) [METAcola]
ShowSortColumn  Constraint Explain   (UCD)
  name (char) logical table name in catalog (meta.id;meta.table;meta.main)
  dbname (char) name of table in db or script (meta.id;meta.table)
  dbaid  Data-base identifier FK(METAdba) (meta.code;meta.dataset)
  catid  (i) catalogue identification FK(METAcat) (meta.code;meta.dataset)
  tabid  (i) identifier of table within catid (meta.code;meta.table)
  notid  METAnot_Note related to the Table (meta.note)
  flags  Flags: MEDIA (01=Spectrum, 02=Image, 04=timeSerie, 08=Cube, 10=filter, 20=model, 40=profile), SED(0x100) (meta.code.status)
  equinox yr Equinox of RA and DE coordinates (time.equinox;pos.frame)
  epoch yr Epoch of coordinates (need pm) (time.epoch;pos.frame)
  cooframe  Frame of Coordinates FK4/G/S/Ecl/FK5/ICRS (1-6) + flags: 0x10=cooprec computed; 0x20=individual errors; 0x40=individual epochs (meta.code;pos.frame)
  status  0x80=Obsolete, 0x40=noQbox, 0x10=inPrep (meta.code.status)
  explain (char) Caption of this table (meta.title)
  comment (char) Free-text comments (meta.note)
  records  Number of records (tuples) in table (meta.number)
  loadate  Date/time table loaded (sec/2000) (time.epoch;meta.table)
  release  Date/time table Released (sec/2000) (time.release;meta.table)
  filename (char) original file (at CDS only) (meta.id;meta.file)
  cooprec mas average precision of position (stat.error;pos)
  morexplain (char) added description (LaTeX) (meta.title)

ALL cols
    
 (i)indexed column
Adapt form
Display your selection only Reset to default columns
usage  Display UCD1+    UCD1  
.errorfile=/tmp/V-3.err (2020-04-01T20:56:21)
-3
-source=METAtab
-ref=VIZ5e84fff520d1
elapse time 0

Options: wopt=0, optS=0, onote=0, opt1=8, opos=0


Contents of error file (/tmp/V-3.err):
CATCLIENT_AGENT=python-vizier-local
CATS=/ftp/cats
CDSportal=http://cdsportal.u-strasbg.fr/StoreVizierData.html
COCAT=130.79.128.31
COCATPORT=1801
CONTEXT_DOCUMENT_ROOT=/home/cds/httpd/local/cgi/
CONTEXT_PREFIX=/local/viz-bin/
Content=text/html
DOCUMENT_ROOT=/home/cds/httpd/Pages/
GATEWAY_INTERFACE=CGI/1.1
GLUDIR=/home/cds/glu
GROUP=www-data
HOME=/home/cds/httpd
HOST=cdsarc
HOSTTYPE=x86_64-linux
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=br,gzip
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
HTTP_CONNECTION=Keep-Alive
HTTP_HOST=cdsarc.u-strasbg.fr
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
LC_ALL=C
LD_LIBRARY_PATH=/usr/local/sybase/OCS-15_0/lib:/home/cds/httpd/../lib:/home/cds/lib:/usr/local/sybase/OCS-15_0/lib:/usr/local/lib:/usr/lib
LOGNAME=www-data
MACHTYPE=x86_64
METADB=metaviz@VIZDB asu asu4VizieR
NEWS=/VizieR/+news.htx
OSTYPE=linux
PATH=/home/cds/httpd/bin:/usr/local/bin:/usr/local/sybase/OCS-15_0/bin:/usr/bin:/bin
PATH_INFO=/
PWD=/home/cds/httpd/cgi
PYTHONPATH=/home/cds/pythonlib/vizier.ingestion/esearch/qcat/
QUERY_STRING=-source=METAtab
REMOTE_ADDR=18.232.188.251
REMOTE_PORT=38728
REQUEST_METHOD=GET
REQUEST_SCHEME=http
REQUEST_URI=/local/viz-bin/VizieR-3?-source=METAtab
SCRIPT_FILENAME=/home/cds/httpd/local/cgi/VizieR-3
SCRIPT_NAME=/local/viz-bin/VizieR-3
SCRIPT_URI=http://cdsarc.u-strasbg.fr/local/viz-bin/VizieR-3
SCRIPT_URL=/local/viz-bin/VizieR-3
SERVER_ADDR=130.79.128.5
SERVER_ADMIN=gilles.landais@astro.u-strasbg.fr
SERVER_NAME=cdsarc.u-strasbg.fr
SERVER_PORT=80
SERVER_PROTOCOL=HTTP/1.1
SERVER_SIGNATURE=<address>Apache/2.4.29 (Ubuntu) Server at cdsarc.u-strasbg.fr Port 80</address>

SERVER_SOFTWARE=Apache/2.4.29 (Ubuntu)
SESAME_SERVER=glu
SHLVL=1
SYBASE=/usr/local/sybase
SYCOMP=OCS-15_0
UNIQUE_ID=XoT-9Xcggzht@X4q1nJwUgAAAIo
USER=www-data
VENDOR=unknown
Vaccess=*
Vprog=/home/cds/httpd/bin/vizier
Vprog_ls=-rwxr-xr-x 1 cds archive 1431200 Mar 17 17:25 /home/cds/httpd/bin/vizier
Vroot=/home/cds/httpd
XDG_CONFIG_HOME=/var/www/

################################################################
....(in): -source=METAtab
################################################################

....Trying '/home/cds/httpd/interfaces' => OK
....Trying '/home/cds/httpd/interfaces' => 3
....db1_interfaces(/home/cds/httpd/interfaces)
----db1_open(metaviz@VIZDB) gives: 0
----Open server: cdsarc.unistra.fr, port 5432 (type postgres base vizier)
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAdba'
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAtab'
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAcol'
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAcat'
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAmor'
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAdic'
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAfam'
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAucd'
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAauth'
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select MAX(dbaid) as nlogins from METAdba
----db1_reset(0 'metaviz@VIZDB')
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select MAX(famid) as mUCD1 from METAfam
----db1_reset(0 'metaviz@VIZDB')
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select hstid, flag from METAhst where name='cdsarc.u-strasbg.fr'
----db1_reset(0 'metaviz@VIZDB')
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select authid, name From METAauth where authid=0
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab where name = 'METAtab' and catid in (select catid from METAcat where catid=METAtab.catid and (authid=0))
----db1_reset(0 'metaviz@VIZDB')
------------db1_tcreate(0): temporary table=T1
----db1_exec(0 'metaviz@VIZDB'):
[1585774581]    insert into T1 values(0)
------------(1 records affected)
------------db1_tcreate(0): temporary table=T2
----db1_exec(0 'metaviz@VIZDB'):
[1585774581]    insert into T2 values(0)
------------(1 records affected)
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   select k.catid,k.kwdid from METAkwd k,T2 t where k.catid=t.id and ((-1*kwdid)<(select min(kwdno_min*1) from METAkwcat where name in ('Astronomy')) or  (-1*kwdid)>(select max(kwdno_max*1) from METAkwcat where name in ('Astronomy'))) order by catid
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab where name = 'METAkwdef' and catid in (select catid from METAcat where catid=METAtab.catid and (authid=0))
----db1_reset(0 'metaviz@VIZDB')
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select catid, morid, text From METAmor where catid=0 order by morid
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, morexplain From METAcol where catid=0 and  tabid=11 order by colid
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAfilter'
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select      METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length      from METAcol, METAtab      where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid      and METAtab.name = 'METAsed'
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=11
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   select login from METAdba where login like 'vizls%'
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select name, kwdid, kwdkm, kwdno, Nk From METAkwdef
#...meta_close(1): retrieved 141/0 tuples [tested=141]
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid From METAcat where catid=0 and (authid=0)
----db1_reset(0 'metaviz@VIZDB')
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=0 order by tabid
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, morexplain From METAcol where catid=0 order by catid,tabid
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=1
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=2
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=3
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=4
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=5
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=6
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=7
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=8
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=9
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=10
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=11
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=12
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=13
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=14
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=15
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=16
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=17
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=18
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=19
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=20
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=21
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=22
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=23
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=24
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=25
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=26
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=27
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=28
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=29
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=30
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=31
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=32
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=33
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=34
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=35
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=36
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=37
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=39
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=40
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=41
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=42
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=43
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=44
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=45
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=46
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=48
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=49
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=51
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=52
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=240
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=242
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=243
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=249
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=250
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=251
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=252
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=253
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=254
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, morexplain From METAcol where catid=0 and  tabid=2 order by colid
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=2

====Contents of more_defs:
(nil)
====argColors='(nil)'

....DisplayFile(/home/cds/httpd/VizieR/+menu.htx) 
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid From METAcat where catid=0 and (authid=0)
----db1_reset(0 'metaviz@VIZDB')
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=0 order by tabid
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab where name = 'METApop' and catid in (select catid from METAcat where catid=METAtab.catid and (authid=0))
----db1_reset(0 'metaviz@VIZDB')
----db1_open(metaviz@VIZDB) gives: 1
----Open server: cdsarc.unistra.fr, port 5432 (type postgres base vizier)
----db1_query(1 'metaviz@VIZDB'):
[1585774581]   SELECT max(popu) as Ncalls FROM METAcat where catid!=0
----db1_close(1 'metaviz@VIZDB')
++++popularity(all): 6.73243e+06 => 6.83
++++popularity(catid=0): 5680363 => 0.99
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select idori, kwdid, name, explain From METAorigin
----db1_open(metaviz@VIZDB) gives: 1
----Open server: cdsarc.unistra.fr, port 5432 (type postgres base vizier)
----db1_exec(1 'metaviz@VIZDB'):
[1585774581]    Update METAhit set etime=639089781,  Ncalls = Ncalls+1 where catid=0 and hstid=4 and btime=639041400
------------(1 records affected)
----db1_exec(1 'metaviz@VIZDB'):
[1585774581]    UPDATE METAstat set nlocal=nlocal+1, tlocal=639089781 Where phase=3 and catid=0
------------(1 records affected)
....meta_stat(cat=0, phase=3): 1 'local' updates
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select famid, name From METAfam where famid>=0
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select ucdid, name From METAucd where ucdid>=0
....show_table(METAtab): show_status = (14, 5, 0, 0, 0)
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select ucdid, name, class, explain From METAucd where ucdid=74
----db1_reset(0 'metaviz@VIZDB')
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select ucdid, name, class, explain From METAucd where ucdid=85
----db1_reset(0 'metaviz@VIZDB')
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select ucdid, name, class, explain From METAucd where ucdid=1
----db1_reset(0 'metaviz@VIZDB')
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select ucdid, name, class, explain From METAucd where ucdid=62
----db1_reset(0 'metaviz@VIZDB')
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select ucdid, name, class, explain From METAucd where ucdid=70
----db1_reset(0 'metaviz@VIZDB')
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select ucdid, name, class, explain From METAucd where ucdid=80
----db1_reset(0 'metaviz@VIZDB')
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select ucdid, name, class, explain From METAucd where ucdid=425
----db1_reset(0 'metaviz@VIZDB')
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select ucdid, name, class, explain From METAucd where ucdid=371
----db1_reset(0 'metaviz@VIZDB')
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select ucdid, name, class, explain From METAucd where ucdid=251
----db1_reset(0 'metaviz@VIZDB')
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select ucdid, name, class, explain From METAucd where ucdid=370
----db1_reset(0 'metaviz@VIZDB')
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select ucdid, name, class, explain From METAucd where ucdid=87
----db1_reset(0 'metaviz@VIZDB')
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select ucdid, name, class, explain From METAucd where ucdid=81
----db1_reset(0 'metaviz@VIZDB')
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select ucdid, name, class, explain From METAucd where ucdid=454
----db1_reset(0 'metaviz@VIZDB')
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select ucdid, name, class, explain From METAucd where ucdid=71
----db1_reset(0 'metaviz@VIZDB')
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select ucdid, name, class, explain From METAucd where ucdid=348
----db1_reset(0 'metaviz@VIZDB')
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select ucdid, name, class, explain From METAucd where ucdid=227
----db1_reset(0 'metaviz@VIZDB')
----db1_query(0 'metaviz@VIZDB'):
[1585774581]   Select famid, name, explain From METAfam where famid=120
----db1_reset(0 'metaviz@VIZDB')
----inherit(u=used, h=hidden):
     [u] +source=METAtab
     [u] -ref=VIZ5e84fff520d1
====inherit(): added 0 hidden fields
----db1_close(0 'metaviz@VIZDB')
----db1_close(1 'metaviz@VIZDB')

© Université de Strasbourg/CNRS

    • Contact