Contents of the last log file
2008-04-20 22:37:45.363 CEST,,,9977,,480ba999.26f9,1,,2008-04-20 22:37:45 CEST,,0,LOG,00000,"le système de bases de données a été arrêté à 2008-04-20 11:02:16 CEST",,,,,,,,"StartupXLOG, xlog.c:4781"
2008-04-20 22:37:45.709 CEST,,,9980,,480ba999.26fc,1,,2008-04-20 22:37:45 CEST,,0,LOG,00000,"lancement du processus autovacuum",,,,,,,,"AutoVacLauncherMain, autovacuum.c:520"
2008-04-20 22:37:45.710 CEST,,,9975,,480ba998.26f7,1,,2008-04-20 22:37:44 CEST,,0,LOG,00000,"le système de bases de données est prêt pour accepter les connexions",,,,,,,,"reaper, postmaster.c:2156"
2008-04-20 22:37:49.214 CEST,,,9985,"",480ba99d.2701,1,"/opt/postgresql-8.3/bin/postgres",2008-04-20 22:37:49 CEST,,0,LOG,00000,"connexion reçue : hôte=127.0.0.1 port=38028",,,,,,,,"BackendInitialize, postmaster.c:3027"
2008-04-20 22:37:49.243 CEST,"guillaume","pagila",9985,"127.0.0.1:38028",480ba99d.2701,2,"authentication",2008-04-20 22:37:49 CEST,,0,LOG,00000,"connexion autorisée : utilisateur=guillaume, base de données=pagila",,,,,,,,"BackendInitialize, postmaster.c:3097"
2008-04-20 22:37:49.490 CEST,"guillaume","pagila",9985,"127.0.0.1:38028",480ba99d.2701,3,"idle",2008-04-20 22:37:49 CEST,1/2,0,LOG,00000,"instruction : SHOW server_version",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:37:49.584 CEST,"guillaume","pagila",9985,"127.0.0.1:38028",480ba99d.2701,4,"idle",2008-04-20 22:37:49 CEST,1/3,0,LOG,00000,"instruction : SELECT 1 FROM pg_proc WHERE proname LIKE '%buffercache%'",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:37:49.725 CEST,"guillaume","pagila",9985,"127.0.0.1:38028",480ba99d.2701,5,"idle",2008-04-20 22:37:49 CEST,1/4,0,LOG,00000,"instruction : SELECT 1 FROM pg_proc WHERE proname LIKE '%stattuple%'",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:37:49.727 CEST,"guillaume","pagila",9985,"127.0.0.1:38028",480ba99d.2701,6,"idle",2008-04-20 22:37:49 CEST,1/5,0,LOG,00000,"instruction : SELECT 1 FROM pg_proc WHERE proname LIKE '%statindex%'",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:37:49.728 CEST,"guillaume","pagila",9985,"127.0.0.1:38028",480ba99d.2701,7,"idle",2008-04-20 22:37:49 CEST,1/6,0,LOG,00000,"instruction : show pool_status",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:37:49.728 CEST,"guillaume","pagila",9985,"127.0.0.1:38028",480ba99d.2701,8,"SHOW",2008-04-20 22:37:49 CEST,1/6,0,ERREUR,42704,"paramètre de configuration « pool_status » non reconnu",,,,,,"show pool_status",,"GetConfigOptionByName, guc.c:5499"
2008-04-20 22:37:49.729 CEST,"guillaume","pagila",9985,"127.0.0.1:38028",480ba99d.2701,9,"idle",2008-04-20 22:37:49 CEST,1/7,0,LOG,00000,"instruction : SELECT name, setting FROM pg_settings",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:37:49.808 CEST,"guillaume","pagila",9985,"127.0.0.1:38028",480ba99d.2701,10,"idle",2008-04-20 22:37:49 CEST,1/8,0,LOG,00000,"instruction : SHOW server_version",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:37:49.810 CEST,"guillaume","pagila",9985,"127.0.0.1:38028",480ba99d.2701,11,"idle",2008-04-20 22:37:49 CEST,1/9,0,LOG,00000,"instruction : SELECT 'PostgreSQL' AS product, version() AS version;",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:37:49.870 CEST,"guillaume","pagila",9985,"127.0.0.1:38028",480ba99d.2701,12,"idle",2008-04-20 22:37:49 CEST,1/10,0,LOG,00000,"instruction : SELECT name, setting FROM pg_settings
WHERE name IN ('max_connections', 'autovacuum_max_workers');",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:37:49.897 CEST,"guillaume","pagila",9985,"127.0.0.1:38028",480ba99d.2701,13,"idle",2008-04-20 22:37:49 CEST,1/11,0,LOG,00000,"instruction : SELECT COUNT(*) FROM pg_stat_activity",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:37:49.978 CEST,"guillaume","pagila",9985,"127.0.0.1:38028",480ba99d.2701,14,"idle",2008-04-20 22:37:49 CEST,1/12,0,LOG,00000,"instruction : SELECT name,
setting,
unit,
category,
short_desc,
extra_desc,
context,
vartype,
source,
min_val,
max_val
FROM pg_settings
ORDER BY category, name",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:37:50.018 CEST,"guillaume","pagila",9985,"127.0.0.1:38028",480ba99d.2701,15,"idle",2008-04-20 22:37:49 CEST,1/13,0,LOG,00000,"instruction : SELECT
relname,
enabled,
vac_base_thresh,
vac_scale_factor,
anl_base_thresh,
anl_scale_factor,
vac_cost_delay,
vac_cost_limit,
freeze_min_age,
freeze_max_age
FROM pg_class, pg_autovacuum
WHERE pg_class.oid = vacrelid
ORDER BY relname",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:37:50.057 CEST,"guillaume","pagila",9985,"127.0.0.1:38028",480ba99d.2701,16,"idle",2008-04-20 22:37:49 CEST,1/14,0,LOG,00000,"instruction : SELECT * FROM (
SELECT
pg_ls_dir('pg_log'))
AS tmp (filename)WHERE filename LIKE '%csv' ORDER BY 1 DESC LIMIT 1",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:37:50.094 CEST,"guillaume","pagila",9985,"127.0.0.1:38028",480ba99d.2701,17,"idle",2008-04-20 22:37:49 CEST,1/15,0,LOG,00000,"instruction : SELECT size
FROM pg_stat_file('pg_log/postgresql-2008-04-20_223745.csv')",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:37:50.095 CEST,"guillaume","pagila",9985,"127.0.0.1:38028",480ba99d.2701,18,"idle",2008-04-20 22:37:49 CEST,1/16,0,LOG,00000,"instruction : SELECT pg_read_file('pg_log/postgresql-2008-04-20_223745.csv',
0, 5155) as contents",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:37:50.097 CEST,"guillaume","pagila",9985,"127.0.0.1:38028",480ba99d.2701,19,"idle",2008-04-20 22:37:49 CEST,1/17,0,LOG,00000,"instruction : SELECT datname,
rolname AS dba,
pg_catalog.pg_encoding_to_char(encoding) AS encoding,
datistemplate,
datallowconn,
datconnlimit,
datlastsysoid,
datfrozenxid,
spcname as tablespace,
pg_size_pretty(pg_database_size(datname)) AS size,
datconfig,
datacl
FROM pg_database, pg_roles, pg_tablespace
WHERE datdba = pg_roles.oid
AND dattablespace = pg_tablespace.oid
ORDER BY datname",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:37:50.261 CEST,"guillaume","pagila",9985,"127.0.0.1:38028",480ba99d.2701,20,"idle",2008-04-20 22:37:49 CEST,1/18,0,LOG,00000,"instruction : SELECT
datname,
pg_database_size(reldatabase) AS size,
count(*) AS buffers
FROM pg_buffercache, pg_database
WHERE reldatabase=pg_database.oid
GROUP BY 1, 2
ORDER BY 1, 2",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:37:50.435 CEST,"guillaume","pagila",9985,"127.0.0.1:38028",480ba99d.2701,21,"idle",2008-04-20 22:37:49 CEST,1/19,0,LOG,00000,"instruction : SELECT rolname,
rolsuper,
rolinherit,
rolcreaterole,
rolcreatedb,
rolcatupdate,
rolcanlogin,
rolconnlimit,
rolvaliduntil,
rolconfig
FROM pg_roles
ORDER BY rolname",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:37:50.458 CEST,"guillaume","pagila",9985,"127.0.0.1:38028",480ba99d.2701,22,"idle",2008-04-20 22:37:49 CEST,1/20,0,LOG,00000,"instruction : SELECT rolname,
CASE WHEN relkind='r' THEN 'table'
WHEN relkind='i' THEN 'index'
WHEN relkind='S' THEN 'sequence'
WHEN relkind='v' THEN 'view'
WHEN relkind='c' THEN 'type composite'
WHEN relkind='t' THEN 'table TOAST'
ELSE '' END AS kind,
COUNT(*) AS total
FROM pg_class, pg_roles
WHERE pg_roles.oid=relowner
GROUP BY 1, 2
ORDER BY 1, 2",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:37:50.461 CEST,"guillaume","pagila",9985,"127.0.0.1:38028",480ba99d.2701,23,"idle",2008-04-20 22:37:49 CEST,1/21,0,LOG,00000,"instruction : SELECT rolname,
CASE WHEN relkind='r' THEN 'table'
WHEN relkind='i' THEN 'index'
WHEN relkind='S' THEN 'sequence'
WHEN relkind='t' THEN 'table TOAST'
ELSE '' END AS kind,
SUM(pg_relation_size(pg_class.oid)) AS total
FROM pg_class, pg_roles
WHERE pg_roles.oid=relowner
AND relkind IN ('r', 't', 'i', 'S')
GROUP BY 1, 2
ORDER BY 1, 2",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:37:50.522 CEST,"guillaume","pagila",9985,"127.0.0.1:38028",480ba99d.2701,24,"idle",2008-04-20 22:37:49 CEST,1/22,0,LOG,00000,"instruction : SELECT spcname,
rolname AS owner,
spclocation,
spcacl,
pg_size_pretty(pg_tablespace_size(spcname)) AS size
FROM pg_tablespace, pg_roles
WHERE spcowner = pg_roles.oid
ORDER BY rolname",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:37:50.594 CEST,"guillaume","pagila",9985,"127.0.0.1:38028",480ba99d.2701,25,"idle",2008-04-20 22:37:49 CEST,1/23,0,LOG,00000,"instruction : SELECT
rolname,
spcname,
CASE WHEN relkind='r' THEN 'Tables' ELSE 'Index' END AS kind,
count(*) AS total
FROM pg_class, pg_tablespace, pg_roles
WHERE spcowner=pg_roles.oid
AND pg_tablespace.oid=reltablespace
AND relkind IN ('r', 'i')
GROUP BY 1, 2, 3
ORDER BY 1, 2, 3;",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:37:50.597 CEST,"guillaume","pagila",9985,"127.0.0.1:38028",480ba99d.2701,26,"idle",2008-04-20 22:37:49 CEST,1/24,0,LOG,00000,"instruction : SELECT nspname,
rolname AS owner,
nspacl
FROM pg_namespace, pg_roles
WHERE nspowner = pg_roles.oid
ORDER BY nspname",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:37:50.599 CEST,"guillaume","pagila",9985,"127.0.0.1:38028",480ba99d.2701,27,"idle",2008-04-20 22:37:49 CEST,1/25,0,LOG,00000,"instruction : SELECT
relname,
nspname AS schema,
rolname AS owner,
relam,
relfilenode,
(select spcname from pg_tablespace where oid=reltablespace) as tablespace,
relpages,
reltuples,
reltoastrelid,
reltoastidxid,
relhasindex,
relisshared,
reltype,
relnatts,
relchecks,
reltriggers,
relukeys,
relfkeys,
relrefs,
relhasoids,
relhaspkey,
relhasrules,
relhassubclass,
relfrozenxid,
relacl,
reloptions,
pg_size_pretty(pg_relation_size(pg_class.oid)) AS size
FROM pg_class, pg_roles, pg_namespace
WHERE relkind = 'r'
AND relowner = pg_roles.oid
AND relnamespace = pg_namespace.oid
AND nspname <> 'pg_catalog'
AND nspname !~ '^pg_toast'
AND pg_table_is_visible(pg_class.oid)
ORDER BY relname",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:37:50.662 CEST,"guillaume","pagila",9985,"127.0.0.1:38028",480ba99d.2701,28,"idle",2008-04-20 22:37:49 CEST,1/26,0,LOG,00000,"instruction : SELECT
n.nspname,
c.relname,
pg_relation_size(c.oid) AS size,
count(*) AS buffers
FROM pg_buffercache b, pg_class c, pg_namespace n
WHERE b.relfilenode = c.relfilenode
AND c.relnamespace = n.oid
AND c.relkind = 'r'
AND b.reldatabase IN (0, (SELECT oid FROM pg_database
WHERE datname = current_database()))
GROUP BY n.nspname, c.relname, size
ORDER BY 3 DESC",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:37:50.688 CEST,"guillaume","pagila",9985,"127.0.0.1:38028",480ba99d.2701,29,"idle",2008-04-20 22:37:49 CEST,1/27,0,LOG,00000,"instruction : SELECT oid, nspname, relname
FROM pg_class, pg_namespace
WHERE relkind IN ('r', 't')
AND relnamespace = pg_namespace.oid
ORDER BY relname",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:37:50.688 CEST,"guillaume","pagila",9985,"127.0.0.1:38028",480ba99d.2701,30,"SELECT",2008-04-20 22:37:49 CEST,1/27,0,ERREUR,42702,"la référence à la colonne « oid » est ambigu",,,,,,"SELECT oid, nspname, relname
FROM pg_class, pg_namespace
WHERE relkind IN ('r', 't')
AND relnamespace = pg_namespace.oid
ORDER BY relname",8,"colNameToVar, parse_relation.c:435"
2008-04-20 22:37:50.689 CEST,"guillaume","pagila",9985,"127.0.0.1:38028",480ba99d.2701,31,"idle",2008-04-20 22:37:49 CEST,,0,LOG,00000,"déconnexion : durée de la session : 0:00:01.475
utilisateur=guillaume base=pagila hôte=127.0.0.1 port=38028",,,,,,,,"log_disconnections, postgres.c:3982"
2008-04-20 22:38:54.318 CEST,,,10089,"",480ba9de.2769,1,"/opt/postgresql-8.3/bin/postgres",2008-04-20 22:38:54 CEST,,0,LOG,00000,"connexion reçue : hôte=127.0.0.1 port=38030",,,,,,,,"BackendInitialize, postmaster.c:3027"
2008-04-20 22:38:54.319 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,2,"authentication",2008-04-20 22:38:54 CEST,,0,LOG,00000,"connexion autorisée : utilisateur=guillaume, base de données=pagila",,,,,,,,"BackendInitialize, postmaster.c:3097"
2008-04-20 22:38:54.321 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,3,"idle",2008-04-20 22:38:54 CEST,1/43,0,LOG,00000,"instruction : SHOW server_version",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.324 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,4,"idle",2008-04-20 22:38:54 CEST,1/44,0,LOG,00000,"instruction : SELECT 1 FROM pg_proc WHERE proname LIKE '%buffercache%'",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.328 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,5,"idle",2008-04-20 22:38:54 CEST,1/45,0,LOG,00000,"instruction : SELECT 1 FROM pg_proc WHERE proname LIKE '%stattuple%'",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.330 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,6,"idle",2008-04-20 22:38:54 CEST,1/46,0,LOG,00000,"instruction : SELECT 1 FROM pg_proc WHERE proname LIKE '%statindex%'",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.332 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,7,"idle",2008-04-20 22:38:54 CEST,1/47,0,LOG,00000,"instruction : show pool_status",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.332 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,8,"SHOW",2008-04-20 22:38:54 CEST,1/47,0,ERREUR,42704,"paramètre de configuration « pool_status » non reconnu",,,,,,"show pool_status",,"GetConfigOptionByName, guc.c:5499"
2008-04-20 22:38:54.332 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,9,"idle",2008-04-20 22:38:54 CEST,1/48,0,LOG,00000,"instruction : SELECT name, setting FROM pg_settings",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.337 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,10,"idle",2008-04-20 22:38:54 CEST,1/49,0,LOG,00000,"instruction : SHOW server_version",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.339 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,11,"idle",2008-04-20 22:38:54 CEST,1/50,0,LOG,00000,"instruction : SELECT 'PostgreSQL' AS product, version() AS version;",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.340 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,12,"idle",2008-04-20 22:38:54 CEST,1/51,0,LOG,00000,"instruction : SELECT name, setting FROM pg_settings
WHERE name IN ('max_connections', 'autovacuum_max_workers');",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.342 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,13,"idle",2008-04-20 22:38:54 CEST,1/52,0,LOG,00000,"instruction : SELECT COUNT(*) FROM pg_stat_activity",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.358 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,14,"idle",2008-04-20 22:38:54 CEST,1/53,0,LOG,00000,"instruction : SELECT name,
setting,
unit,
category,
short_desc,
extra_desc,
context,
vartype,
source,
min_val,
max_val
FROM pg_settings
ORDER BY category, name",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.379 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,15,"idle",2008-04-20 22:38:54 CEST,1/54,0,LOG,00000,"instruction : SELECT
relname,
enabled,
vac_base_thresh,
vac_scale_factor,
anl_base_thresh,
anl_scale_factor,
vac_cost_delay,
vac_cost_limit,
freeze_min_age,
freeze_max_age
FROM pg_class, pg_autovacuum
WHERE pg_class.oid = vacrelid
ORDER BY relname",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.382 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,16,"idle",2008-04-20 22:38:54 CEST,1/55,0,LOG,00000,"instruction : SELECT * FROM (
SELECT
pg_ls_dir('pg_log'))
AS tmp (filename)WHERE filename LIKE '%csv' ORDER BY 1 DESC LIMIT 1",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.384 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,17,"idle",2008-04-20 22:38:54 CEST,1/56,0,LOG,00000,"instruction : SELECT size
FROM pg_stat_file('pg_log/postgresql-2008-04-20_223745.csv')",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.385 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,18,"idle",2008-04-20 22:38:54 CEST,1/57,0,LOG,00000,"instruction : SELECT pg_read_file('pg_log/postgresql-2008-04-20_223745.csv',
0, 16007) as contents",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.386 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,19,"idle",2008-04-20 22:38:54 CEST,1/58,0,LOG,00000,"instruction : SELECT datname,
rolname AS dba,
pg_catalog.pg_encoding_to_char(encoding) AS encoding,
datistemplate,
datallowconn,
datconnlimit,
datlastsysoid,
datfrozenxid,
spcname as tablespace,
pg_size_pretty(pg_database_size(datname)) AS size,
datconfig,
datacl
FROM pg_database, pg_roles, pg_tablespace
WHERE datdba = pg_roles.oid
AND dattablespace = pg_tablespace.oid
ORDER BY datname",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.399 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,20,"idle",2008-04-20 22:38:54 CEST,1/59,0,LOG,00000,"instruction : SELECT
datname,
pg_database_size(reldatabase) AS size,
count(*) AS buffers
FROM pg_buffercache, pg_database
WHERE reldatabase=pg_database.oid
GROUP BY 1, 2
ORDER BY 1, 2",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.706 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,21,"SELECT",2008-04-20 22:38:54 CEST,1/0,0,LOG,00000,"durée : 307.238 ms",,,,,,,,"exec_simple_query, postgres.c:1056"
2008-04-20 22:38:54.707 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,22,"idle",2008-04-20 22:38:54 CEST,1/60,0,LOG,00000,"instruction : SELECT rolname,
rolsuper,
rolinherit,
rolcreaterole,
rolcreatedb,
rolcatupdate,
rolcanlogin,
rolconnlimit,
rolvaliduntil,
rolconfig
FROM pg_roles
ORDER BY rolname",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.708 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,23,"idle",2008-04-20 22:38:54 CEST,1/61,0,LOG,00000,"instruction : SELECT rolname,
CASE WHEN relkind='r' THEN 'table'
WHEN relkind='i' THEN 'index'
WHEN relkind='S' THEN 'sequence'
WHEN relkind='v' THEN 'view'
WHEN relkind='c' THEN 'type composite'
WHEN relkind='t' THEN 'table TOAST'
ELSE '' END AS kind,
COUNT(*) AS total
FROM pg_class, pg_roles
WHERE pg_roles.oid=relowner
GROUP BY 1, 2
ORDER BY 1, 2",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.710 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,24,"idle",2008-04-20 22:38:54 CEST,1/62,0,LOG,00000,"instruction : SELECT rolname,
CASE WHEN relkind='r' THEN 'table'
WHEN relkind='i' THEN 'index'
WHEN relkind='S' THEN 'sequence'
WHEN relkind='t' THEN 'table TOAST'
ELSE '' END AS kind,
SUM(pg_relation_size(pg_class.oid)) AS total
FROM pg_class, pg_roles
WHERE pg_roles.oid=relowner
AND relkind IN ('r', 't', 'i', 'S')
GROUP BY 1, 2
ORDER BY 1, 2",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.719 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,25,"idle",2008-04-20 22:38:54 CEST,1/63,0,LOG,00000,"instruction : SELECT spcname,
rolname AS owner,
spclocation,
spcacl,
pg_size_pretty(pg_tablespace_size(spcname)) AS size
FROM pg_tablespace, pg_roles
WHERE spcowner = pg_roles.oid
ORDER BY rolname",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.724 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,26,"idle",2008-04-20 22:38:54 CEST,1/64,0,LOG,00000,"instruction : SELECT
rolname,
spcname,
CASE WHEN relkind='r' THEN 'Tables' ELSE 'Index' END AS kind,
count(*) AS total
FROM pg_class, pg_tablespace, pg_roles
WHERE spcowner=pg_roles.oid
AND pg_tablespace.oid=reltablespace
AND relkind IN ('r', 'i')
GROUP BY 1, 2, 3
ORDER BY 1, 2, 3;",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.726 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,27,"idle",2008-04-20 22:38:54 CEST,1/65,0,LOG,00000,"instruction : SELECT nspname,
rolname AS owner,
nspacl
FROM pg_namespace, pg_roles
WHERE nspowner = pg_roles.oid
ORDER BY nspname",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.727 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,28,"idle",2008-04-20 22:38:54 CEST,1/66,0,LOG,00000,"instruction : SELECT
relname,
nspname AS schema,
rolname AS owner,
relam,
relfilenode,
(select spcname from pg_tablespace where oid=reltablespace) as tablespace,
relpages,
reltuples,
reltoastrelid,
reltoastidxid,
relhasindex,
relisshared,
reltype,
relnatts,
relchecks,
reltriggers,
relukeys,
relfkeys,
relrefs,
relhasoids,
relhaspkey,
relhasrules,
relhassubclass,
relfrozenxid,
relacl,
reloptions,
pg_size_pretty(pg_relation_size(pg_class.oid)) AS size
FROM pg_class, pg_roles, pg_namespace
WHERE relkind = 'r'
AND relowner = pg_roles.oid
AND relnamespace = pg_namespace.oid
AND nspname <> 'pg_catalog'
AND nspname !~ '^pg_toast'
AND pg_table_is_visible(pg_class.oid)
ORDER BY relname",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.736 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,29,"idle",2008-04-20 22:38:54 CEST,1/67,0,LOG,00000,"instruction : SELECT
n.nspname,
c.relname,
pg_relation_size(c.oid) AS size,
count(*) AS buffers
FROM pg_buffercache b, pg_class c, pg_namespace n
WHERE b.relfilenode = c.relfilenode
AND c.relnamespace = n.oid
AND c.relkind = 'r'
AND b.reldatabase IN (0, (SELECT oid FROM pg_database
WHERE datname = current_database()))
GROUP BY n.nspname, c.relname, size
ORDER BY 3 DESC",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.753 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,30,"idle",2008-04-20 22:38:54 CEST,1/68,0,LOG,00000,"instruction : SELECT pg_class.oid, nspname, relname
FROM pg_class, pg_namespace
WHERE relkind IN ('r', 't')
AND relnamespace = pg_namespace.oid
ORDER BY relname",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.754 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,31,"idle",2008-04-20 22:38:54 CEST,1/69,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(18024)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.804 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,32,"idle",2008-04-20 22:38:54 CEST,1/70,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(18076)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.818 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,33,"idle",2008-04-20 22:38:54 CEST,1/71,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(18042)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.823 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,34,"idle",2008-04-20 22:38:54 CEST,1/72,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(18083)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.834 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,35,"idle",2008-04-20 22:38:54 CEST,1/73,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(18090)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.835 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,36,"idle",2008-04-20 22:38:54 CEST,1/74,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(18097)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.838 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,37,"idle",2008-04-20 22:38:54 CEST,1/75,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(18049)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.854 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,38,"idle",2008-04-20 22:38:54 CEST,1/76,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(18061)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.868 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,39,"idle",2008-04-20 22:38:54 CEST,1/77,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(18065)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.880 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,40,"idle",2008-04-20 22:38:54 CEST,1/78,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(18116)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.893 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,41,"idle",2008-04-20 22:38:54 CEST,1/79,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(18123)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.898 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,42,"idle",2008-04-20 22:38:54 CEST,1/80,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(18135)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.899 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,43,"idle",2008-04-20 22:38:54 CEST,1/81,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(18139)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.906 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,44,"idle",2008-04-20 22:38:54 CEST,1/82,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(18144)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.922 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,45,"idle",2008-04-20 22:38:54 CEST,1/83,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(18149)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.938 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,46,"idle",2008-04-20 22:38:54 CEST,1/84,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(18154)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.963 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,47,"idle",2008-04-20 22:38:54 CEST,1/85,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(18159)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.969 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,48,"idle",2008-04-20 22:38:54 CEST,1/86,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(18164)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.970 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,49,"idle",2008-04-20 22:38:54 CEST,1/87,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(2600)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.971 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,50,"idle",2008-04-20 22:38:54 CEST,1/88,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(2601)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.971 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,51,"idle",2008-04-20 22:38:54 CEST,1/89,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(2602)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.972 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,52,"idle",2008-04-20 22:38:54 CEST,1/90,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(2603)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.973 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,53,"idle",2008-04-20 22:38:54 CEST,1/91,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(2604)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.974 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,54,"idle",2008-04-20 22:38:54 CEST,1/92,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(1249)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.976 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,55,"idle",2008-04-20 22:38:54 CEST,1/93,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(1261)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.976 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,56,"idle",2008-04-20 22:38:54 CEST,1/94,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(1260)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.979 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,57,"idle",2008-04-20 22:38:54 CEST,1/95,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(1248)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.979 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,58,"idle",2008-04-20 22:38:54 CEST,1/96,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(2605)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.980 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,59,"idle",2008-04-20 22:38:54 CEST,1/97,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(1259)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.981 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,60,"idle",2008-04-20 22:38:54 CEST,1/98,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(2606)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:54.982 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,61,"idle",2008-04-20 22:38:54 CEST,1/99,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(2607)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.075 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,62,"idle",2008-04-20 22:38:54 CEST,1/100,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(1262)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.075 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,63,"idle",2008-04-20 22:38:54 CEST,1/101,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(2608)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.100 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,64,"idle",2008-04-20 22:38:54 CEST,1/102,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(2609)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.116 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,65,"idle",2008-04-20 22:38:54 CEST,1/103,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(3501)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.130 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,66,"idle",2008-04-20 22:38:54 CEST,1/104,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(2610)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.130 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,67,"idle",2008-04-20 22:38:54 CEST,1/105,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(2611)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.142 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,68,"idle",2008-04-20 22:38:54 CEST,1/106,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(2612)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.143 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,69,"idle",2008-04-20 22:38:54 CEST,1/107,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(2613)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.143 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,70,"idle",2008-04-20 22:38:54 CEST,1/108,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(2614)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.144 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,71,"idle",2008-04-20 22:38:54 CEST,1/109,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(2615)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.145 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,72,"idle",2008-04-20 22:38:54 CEST,1/110,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(2616)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.145 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,73,"idle",2008-04-20 22:38:54 CEST,1/111,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(2617)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.147 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,74,"idle",2008-04-20 22:38:54 CEST,1/112,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(2753)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.171 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,75,"idle",2008-04-20 22:38:54 CEST,1/113,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(1136)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.176 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,76,"idle",2008-04-20 22:38:54 CEST,1/114,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(1255)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.178 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,77,"idle",2008-04-20 22:38:54 CEST,1/115,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(2618)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.191 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,78,"idle",2008-04-20 22:38:54 CEST,1/116,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(1214)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.206 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,79,"idle",2008-04-20 22:38:54 CEST,1/117,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(2396)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.213 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,80,"idle",2008-04-20 22:38:54 CEST,1/118,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(2619)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.230 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,81,"idle",2008-04-20 22:38:54 CEST,1/119,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(1213)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.230 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,82,"idle",2008-04-20 22:38:54 CEST,1/120,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(11431)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.231 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,83,"idle",2008-04-20 22:38:54 CEST,1/121,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(11436)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.232 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,84,"idle",2008-04-20 22:38:54 CEST,1/122,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(11441)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.232 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,85,"idle",2008-04-20 22:38:54 CEST,1/123,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(11446)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.233 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,86,"idle",2008-04-20 22:38:54 CEST,1/124,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(11451)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.233 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,87,"idle",2008-04-20 22:38:54 CEST,1/125,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(11456)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.234 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,88,"idle",2008-04-20 22:38:54 CEST,1/126,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(11461)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.234 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,89,"idle",2008-04-20 22:38:54 CEST,1/127,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(2836)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.235 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,90,"idle",2008-04-20 22:38:54 CEST,1/128,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(2842)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.236 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,91,"idle",2008-04-20 22:38:54 CEST,1/129,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(2844)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.236 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,92,"idle",2008-04-20 22:38:54 CEST,1/130,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(18058)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.237 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,93,"idle",2008-04-20 22:38:54 CEST,1/131,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(18189)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.237 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,94,"idle",2008-04-20 22:38:54 CEST,1/132,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(2846)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.238 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,95,"idle",2008-04-20 22:38:54 CEST,1/133,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(2830)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.238 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,96,"idle",2008-04-20 22:38:54 CEST,1/134,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(2832)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.239 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,97,"idle",2008-04-20 22:38:54 CEST,1/135,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(2834)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.240 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,98,"idle",2008-04-20 22:38:54 CEST,1/136,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(2838)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.281 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,99,"idle",2008-04-20 22:38:54 CEST,1/137,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(2840)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.281 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,100,"idle",2008-04-20 22:38:54 CEST,1/138,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(2620)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.282 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,101,"idle",2008-04-20 22:38:54 CEST,1/139,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(3602)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.283 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,102,"idle",2008-04-20 22:38:54 CEST,1/140,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(3603)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.290 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,103,"idle",2008-04-20 22:38:54 CEST,1/141,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(3600)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.294 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,104,"idle",2008-04-20 22:38:54 CEST,1/142,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(3601)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.308 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,105,"idle",2008-04-20 22:38:54 CEST,1/143,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(3764)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.315 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,106,"idle",2008-04-20 22:38:54 CEST,1/144,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(1247)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.316 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,107,"idle",2008-04-20 22:38:54 CEST,1/145,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(18171)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.379 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,108,"idle",2008-04-20 22:38:54 CEST,1/146,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(11429)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.381 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,109,"idle",2008-04-20 22:38:54 CEST,1/147,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(11434)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.390 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,110,"idle",2008-04-20 22:38:54 CEST,1/148,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(11439)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.391 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,111,"idle",2008-04-20 22:38:54 CEST,1/149,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(11444)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.395 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,112,"idle",2008-04-20 22:38:54 CEST,1/150,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(11449)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.402 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,113,"idle",2008-04-20 22:38:54 CEST,1/151,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(11454)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.403 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,114,"idle",2008-04-20 22:38:54 CEST,1/152,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(11459)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.404 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,115,"idle",2008-04-20 22:38:54 CEST,1/153,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(18183)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.405 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,116,"idle",2008-04-20 22:38:54 CEST,1/154,0,LOG,00000,"instruction : SELECT
table_len,
tuple_count,
tuple_len,
tuple_percent,
dead_tuple_count,
dead_tuple_len,
dead_tuple_percent,
free_space,
free_percent
FROM pgstattuple(18194)
WHERE table_len>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.449 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,117,"idle",2008-04-20 22:38:54 CEST,1/155,0,LOG,00000,"instruction : SELECT
rolname AS owner,
relname,
pg_relation_size(pg_class.oid) as size
FROM pg_class, pg_roles
WHERE
relkind='r'
AND relhaspkey IS false
AND relowner = pg_roles.oid
ORDER BY relowner, relname",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.472 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,118,"idle",2008-04-20 22:38:54 CEST,1/156,0,LOG,00000,"instruction : SELECT
schemaname || '.' || tablename AS tbl,
count(*) as total
FROM pg_indexes
GROUP BY 1
HAVING count(*)>=5
ORDER BY 1",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.530 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,119,"idle",2008-04-20 22:38:54 CEST,1/157,0,LOG,00000,"instruction : SELECT
rolname AS tableowner,
relname AS tablename,
conname,
pg_get_constraintdef(pg_constraint.oid, true) as condef
FROM pg_constraint, pg_class, pg_roles
WHERE conrelid=pg_class.oid
AND relowner=pg_roles.oid
AND contype = 'f'
ORDER BY 1, 2, 3",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.544 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,120,"idle",2008-04-20 22:38:54 CEST,1/158,0,LOG,00000,"instruction : SELECT
relname,
nspname AS schema,
rolname AS owner,
relam,
relfilenode,
(select spcname from pg_tablespace where oid=reltablespace) as tablespace,
relpages,
reltuples,
reltoastrelid,
reltoastidxid,
relhasindex,
relisshared,
reltype,
relnatts,
relchecks,
reltriggers,
relukeys,
relfkeys,
relrefs,
relhasoids,
relhaspkey,
relhasrules,
relhassubclass,
relfrozenxid,
relacl,
reloptions,
pg_size_pretty(pg_relation_size(pg_class.oid)) AS size
FROM pg_class, pg_roles, pg_namespace
WHERE relkind = 'v'
AND relowner = pg_roles.oid
AND relnamespace = pg_namespace.oid
AND nspname <> 'pg_catalog'
AND nspname !~ '^pg_toast'
AND pg_table_is_visible(pg_class.oid)
ORDER BY relname",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.559 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,121,"idle",2008-04-20 22:38:54 CEST,1/159,0,LOG,00000,"instruction : SELECT
relname,
nspname AS schema,
rolname AS owner,
relam,
relfilenode,
(select spcname from pg_tablespace where oid=reltablespace) as tablespace,
relpages,
reltuples,
reltoastrelid,
reltoastidxid,
relhasindex,
relisshared,
reltype,
relnatts,
relchecks,
reltriggers,
relukeys,
relfkeys,
relrefs,
relhasoids,
relhaspkey,
relhasrules,
relhassubclass,
relfrozenxid,
relacl,
reloptions,
pg_size_pretty(pg_relation_size(pg_class.oid)) AS size
FROM pg_class, pg_roles, pg_namespace
WHERE relkind = 'S'
AND relowner = pg_roles.oid
AND relnamespace = pg_namespace.oid
AND nspname <> 'pg_catalog'
AND nspname !~ '^pg_toast'
AND pg_table_is_visible(pg_class.oid)
ORDER BY relname",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.583 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,122,"idle",2008-04-20 22:38:54 CEST,1/160,0,LOG,00000,"instruction : SELECT
relname,
nspname AS schema,
rolname AS owner,
relam,
relfilenode,
(select spcname from pg_tablespace where oid=reltablespace) as tablespace,
relpages,
reltuples,
reltoastrelid,
reltoastidxid,
relhasindex,
relisshared,
reltype,
relnatts,
relchecks,
reltriggers,
relukeys,
relfkeys,
relrefs,
relhasoids,
relhaspkey,
relhasrules,
relhassubclass,
relfrozenxid,
relacl,
reloptions,
pg_size_pretty(pg_relation_size(pg_class.oid)) AS size
FROM pg_class, pg_roles, pg_namespace
WHERE relkind = 'i'
AND relowner = pg_roles.oid
AND relnamespace = pg_namespace.oid
AND nspname <> 'pg_catalog'
AND nspname !~ '^pg_toast'
AND pg_table_is_visible(pg_class.oid)
ORDER BY relname",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.594 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,123,"idle",2008-04-20 22:38:54 CEST,1/161,0,LOG,00000,"instruction : SELECT nspname, relname
FROM pg_class, pg_namespace
WHERE relkind = 'i' and relnamespace=pg_namespace.oid and relam=403
ORDER BY relname",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.596 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,124,"idle",2008-04-20 22:38:54 CEST,1/162,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('public.actor_pkey')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.616 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,125,"idle",2008-04-20 22:38:54 CEST,1/163,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('public.address_pkey')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.621 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,126,"idle",2008-04-20 22:38:54 CEST,1/164,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('public.category_pkey')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.632 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,127,"idle",2008-04-20 22:38:54 CEST,1/165,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('public.city_pkey')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.642 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,128,"idle",2008-04-20 22:38:54 CEST,1/166,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('public.country_pkey')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.656 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,129,"idle",2008-04-20 22:38:54 CEST,1/167,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('public.customer_pkey')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.662 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,130,"idle",2008-04-20 22:38:54 CEST,1/168,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('public.film_actor_pkey')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.678 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,131,"idle",2008-04-20 22:38:54 CEST,1/169,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('public.film_category_pkey')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.680 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,132,"idle",2008-04-20 22:38:54 CEST,1/170,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('public.film_pkey')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.681 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,133,"idle",2008-04-20 22:38:54 CEST,1/171,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('public.idx_actor_last_name')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.709 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,134,"idle",2008-04-20 22:38:54 CEST,1/172,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('public.idx_fk_address_id')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.722 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,135,"idle",2008-04-20 22:38:54 CEST,1/173,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('public.idx_fk_city_id')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.725 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,136,"idle",2008-04-20 22:38:54 CEST,1/174,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('public.idx_fk_country_id')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.740 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,137,"idle",2008-04-20 22:38:54 CEST,1/175,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('public.idx_fk_customer_id')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.741 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,138,"idle",2008-04-20 22:38:54 CEST,1/176,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('public.idx_fk_film_id')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.753 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,139,"idle",2008-04-20 22:38:54 CEST,1/177,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('public.idx_fk_inventory_id')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.776 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,140,"idle",2008-04-20 22:38:54 CEST,1/178,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('public.idx_fk_language_id')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.782 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,141,"idle",2008-04-20 22:38:54 CEST,1/179,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('public.idx_fk_original_language_id')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.784 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,142,"idle",2008-04-20 22:38:54 CEST,1/180,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('public.idx_fk_payment_p2007_01_customer_id')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.786 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,143,"idle",2008-04-20 22:38:54 CEST,1/181,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('public.idx_fk_payment_p2007_01_staff_id')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.805 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,144,"idle",2008-04-20 22:38:54 CEST,1/182,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('public.idx_fk_payment_p2007_02_customer_id')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.820 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,145,"idle",2008-04-20 22:38:54 CEST,1/183,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('public.idx_fk_payment_p2007_02_staff_id')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.866 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,146,"idle",2008-04-20 22:38:54 CEST,1/184,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('public.idx_fk_payment_p2007_03_customer_id')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.880 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,147,"idle",2008-04-20 22:38:54 CEST,1/185,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('public.idx_fk_payment_p2007_03_staff_id')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.890 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,148,"idle",2008-04-20 22:38:54 CEST,1/186,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('public.idx_fk_payment_p2007_04_customer_id')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.904 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,149,"idle",2008-04-20 22:38:54 CEST,1/187,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('public.idx_fk_payment_p2007_04_staff_id')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.917 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,150,"idle",2008-04-20 22:38:54 CEST,1/188,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('public.idx_fk_payment_p2007_05_customer_id')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.918 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,151,"idle",2008-04-20 22:38:54 CEST,1/189,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('public.idx_fk_payment_p2007_05_staff_id')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.919 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,152,"idle",2008-04-20 22:38:54 CEST,1/190,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('public.idx_fk_payment_p2007_06_customer_id')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.927 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,153,"idle",2008-04-20 22:38:54 CEST,1/191,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('public.idx_fk_payment_p2007_06_staff_id')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.935 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,154,"idle",2008-04-20 22:38:54 CEST,1/192,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('public.idx_fk_staff_id')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.945 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,155,"idle",2008-04-20 22:38:54 CEST,1/193,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('public.idx_fk_store_id')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.951 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,156,"idle",2008-04-20 22:38:54 CEST,1/194,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('public.idx_last_name')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.953 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,157,"idle",2008-04-20 22:38:54 CEST,1/195,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('public.idx_store_id_film_id')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.966 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,158,"idle",2008-04-20 22:38:54 CEST,1/196,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('public.idx_title')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.968 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,159,"idle",2008-04-20 22:38:54 CEST,1/197,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('public.idx_unq_manager_staff_id')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:55.981 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,160,"idle",2008-04-20 22:38:54 CEST,1/198,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('public.idx_unq_rental_rental_date_inventory_id_customer_id')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.012 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,161,"idle",2008-04-20 22:38:54 CEST,1/199,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('public.inventory_pkey')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.021 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,162,"idle",2008-04-20 22:38:54 CEST,1/200,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('public.language_pkey')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.023 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,163,"idle",2008-04-20 22:38:54 CEST,1/201,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('public.payment_pkey')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.024 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,164,"idle",2008-04-20 22:38:54 CEST,1/202,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_aggregate_fnoid_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.025 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,165,"idle",2008-04-20 22:38:54 CEST,1/203,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_am_name_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.033 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,166,"idle",2008-04-20 22:38:54 CEST,1/204,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_am_oid_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.037 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,167,"idle",2008-04-20 22:38:54 CEST,1/205,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_amop_fam_strat_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.038 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,168,"idle",2008-04-20 22:38:54 CEST,1/206,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_amop_oid_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.039 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,169,"idle",2008-04-20 22:38:54 CEST,1/207,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_amop_opr_fam_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.040 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,170,"idle",2008-04-20 22:38:54 CEST,1/208,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_amproc_fam_proc_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.041 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,171,"idle",2008-04-20 22:38:54 CEST,1/209,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_amproc_oid_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.048 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,172,"idle",2008-04-20 22:38:54 CEST,1/210,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_attrdef_adrelid_adnum_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.049 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,173,"idle",2008-04-20 22:38:54 CEST,1/211,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_attrdef_oid_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.056 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,174,"idle",2008-04-20 22:38:54 CEST,1/212,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_attribute_relid_attnam_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.066 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,175,"idle",2008-04-20 22:38:54 CEST,1/213,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_attribute_relid_attnum_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.067 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,176,"idle",2008-04-20 22:38:54 CEST,1/214,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_auth_members_member_role_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.079 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,177,"idle",2008-04-20 22:38:54 CEST,1/215,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_auth_members_role_member_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.080 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,178,"idle",2008-04-20 22:38:54 CEST,1/216,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_authid_oid_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.081 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,179,"idle",2008-04-20 22:38:54 CEST,1/217,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_authid_rolname_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.081 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,180,"idle",2008-04-20 22:38:54 CEST,1/218,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_autovacuum_vacrelid_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.082 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,181,"idle",2008-04-20 22:38:54 CEST,1/219,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_cast_oid_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.092 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,182,"idle",2008-04-20 22:38:54 CEST,1/220,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_cast_source_target_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.093 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,183,"idle",2008-04-20 22:38:54 CEST,1/221,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_class_oid_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.094 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,184,"idle",2008-04-20 22:38:54 CEST,1/222,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_class_relname_nsp_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.095 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,185,"idle",2008-04-20 22:38:54 CEST,1/223,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_constraint_conname_nsp_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.096 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,186,"idle",2008-04-20 22:38:54 CEST,1/224,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_constraint_conrelid_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.097 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,187,"idle",2008-04-20 22:38:54 CEST,1/225,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_constraint_contypid_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.110 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,188,"idle",2008-04-20 22:38:54 CEST,1/226,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_constraint_oid_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.111 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,189,"idle",2008-04-20 22:38:54 CEST,1/227,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_conversion_default_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.113 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,190,"idle",2008-04-20 22:38:54 CEST,1/228,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_conversion_name_nsp_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.123 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,191,"idle",2008-04-20 22:38:54 CEST,1/229,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_conversion_oid_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.136 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,192,"idle",2008-04-20 22:38:54 CEST,1/230,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_database_datname_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.136 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,193,"idle",2008-04-20 22:38:54 CEST,1/231,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_database_oid_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.137 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,194,"idle",2008-04-20 22:38:54 CEST,1/232,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_depend_depender_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.152 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,195,"idle",2008-04-20 22:38:54 CEST,1/233,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_depend_reference_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.163 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,196,"idle",2008-04-20 22:38:54 CEST,1/234,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_description_o_c_o_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.166 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,197,"idle",2008-04-20 22:38:54 CEST,1/235,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_enum_oid_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.171 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,198,"idle",2008-04-20 22:38:54 CEST,1/236,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_enum_typid_label_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.185 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,199,"idle",2008-04-20 22:38:54 CEST,1/237,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_index_indexrelid_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.186 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,200,"idle",2008-04-20 22:38:54 CEST,1/238,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_index_indrelid_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.187 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,201,"idle",2008-04-20 22:38:54 CEST,1/239,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_inherits_relid_seqno_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.188 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,202,"idle",2008-04-20 22:38:54 CEST,1/240,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_language_name_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.192 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,203,"idle",2008-04-20 22:38:54 CEST,1/241,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_language_oid_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.197 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,204,"idle",2008-04-20 22:38:54 CEST,1/242,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_largeobject_loid_pn_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.198 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,205,"idle",2008-04-20 22:38:54 CEST,1/243,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_namespace_nspname_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.198 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,206,"idle",2008-04-20 22:38:54 CEST,1/244,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_namespace_oid_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.199 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,207,"idle",2008-04-20 22:38:54 CEST,1/245,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_opclass_am_name_nsp_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.200 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,208,"idle",2008-04-20 22:38:54 CEST,1/246,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_opclass_oid_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.201 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,209,"idle",2008-04-20 22:38:54 CEST,1/247,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_operator_oid_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.201 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,210,"idle",2008-04-20 22:38:54 CEST,1/248,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_operator_oprname_l_r_n_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.202 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,211,"idle",2008-04-20 22:38:54 CEST,1/249,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_opfamily_am_name_nsp_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.206 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,212,"idle",2008-04-20 22:38:54 CEST,1/250,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_opfamily_oid_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.207 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,213,"idle",2008-04-20 22:38:54 CEST,1/251,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_pltemplate_name_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.209 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,214,"idle",2008-04-20 22:38:54 CEST,1/252,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_proc_oid_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.209 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,215,"idle",2008-04-20 22:38:54 CEST,1/253,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_proc_proname_args_nsp_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.225 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,216,"idle",2008-04-20 22:38:54 CEST,1/254,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_rewrite_oid_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.227 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,217,"idle",2008-04-20 22:38:54 CEST,1/255,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_rewrite_rel_rulename_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.228 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,218,"idle",2008-04-20 22:38:54 CEST,1/256,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_shdepend_depender_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.229 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,219,"idle",2008-04-20 22:38:54 CEST,1/257,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_shdepend_reference_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.230 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,220,"idle",2008-04-20 22:38:54 CEST,1/258,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_shdescription_o_c_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.242 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,221,"idle",2008-04-20 22:38:54 CEST,1/259,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_statistic_relid_att_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.243 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,222,"idle",2008-04-20 22:38:54 CEST,1/260,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_tablespace_oid_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.246 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,223,"idle",2008-04-20 22:38:54 CEST,1/261,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_tablespace_spcname_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.247 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,224,"idle",2008-04-20 22:38:54 CEST,1/262,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_toast.pg_toast_11429_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.258 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,225,"idle",2008-04-20 22:38:54 CEST,1/263,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_toast.pg_toast_11434_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.259 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,226,"idle",2008-04-20 22:38:54 CEST,1/264,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_toast.pg_toast_11439_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.260 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,227,"idle",2008-04-20 22:38:54 CEST,1/265,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_toast.pg_toast_11444_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.261 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,228,"idle",2008-04-20 22:38:54 CEST,1/266,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_toast.pg_toast_11449_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.269 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,229,"idle",2008-04-20 22:38:54 CEST,1/267,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_toast.pg_toast_11454_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.279 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,230,"idle",2008-04-20 22:38:54 CEST,1/268,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_toast.pg_toast_11459_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.292 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,231,"idle",2008-04-20 22:38:54 CEST,1/269,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_toast.pg_toast_1255_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.294 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,232,"idle",2008-04-20 22:38:54 CEST,1/270,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_toast.pg_toast_1260_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.295 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,233,"idle",2008-04-20 22:38:54 CEST,1/271,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_toast.pg_toast_1262_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.305 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,234,"idle",2008-04-20 22:38:54 CEST,1/272,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_toast.pg_toast_18049_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.316 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,235,"idle",2008-04-20 22:38:54 CEST,1/273,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_toast.pg_toast_18183_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.324 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,236,"idle",2008-04-20 22:38:54 CEST,1/274,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_toast.pg_toast_2396_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.325 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,237,"idle",2008-04-20 22:38:54 CEST,1/275,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_toast.pg_toast_2604_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.326 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,238,"idle",2008-04-20 22:38:54 CEST,1/276,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_toast.pg_toast_2606_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.327 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,239,"idle",2008-04-20 22:38:54 CEST,1/277,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_toast.pg_toast_2609_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.328 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,240,"idle",2008-04-20 22:38:54 CEST,1/278,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_toast.pg_toast_2618_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.329 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,241,"idle",2008-04-20 22:38:54 CEST,1/279,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_toast.pg_toast_2619_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.329 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,242,"idle",2008-04-20 22:38:54 CEST,1/280,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_trigger_oid_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.331 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,243,"idle",2008-04-20 22:38:54 CEST,1/281,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_trigger_tgconstrname_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.353 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,244,"idle",2008-04-20 22:38:54 CEST,1/282,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_trigger_tgrelid_tgname_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.354 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,245,"idle",2008-04-20 22:38:54 CEST,1/283,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_ts_config_cfgname_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.359 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,246,"idle",2008-04-20 22:38:54 CEST,1/284,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_ts_config_map_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.371 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,247,"idle",2008-04-20 22:38:54 CEST,1/285,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_ts_config_oid_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.375 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,248,"idle",2008-04-20 22:38:54 CEST,1/286,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_ts_dict_dictname_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.376 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,249,"idle",2008-04-20 22:38:54 CEST,1/287,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_ts_dict_oid_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.377 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,250,"idle",2008-04-20 22:38:54 CEST,1/288,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_ts_parser_oid_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.390 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,251,"idle",2008-04-20 22:38:54 CEST,1/289,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_ts_parser_prsname_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.391 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,252,"idle",2008-04-20 22:38:54 CEST,1/290,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_ts_template_oid_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.392 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,253,"idle",2008-04-20 22:38:54 CEST,1/291,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_ts_template_tmplname_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.393 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,254,"idle",2008-04-20 22:38:54 CEST,1/292,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_type_oid_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.394 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,255,"idle",2008-04-20 22:38:54 CEST,1/293,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('pg_catalog.pg_type_typname_nsp_index')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.395 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,256,"idle",2008-04-20 22:38:54 CEST,1/294,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('public.rental_pkey')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.419 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,257,"idle",2008-04-20 22:38:54 CEST,1/295,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('public.staff_pkey')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.420 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,258,"idle",2008-04-20 22:38:54 CEST,1/296,0,LOG,00000,"instruction : SELECT
version,
tree_level,
index_size,
root_block_no,
internal_pages,
leaf_pages,
empty_pages,
deleted_pages,
avg_leaf_density,
leaf_fragmentation
FROM pgstatindex('public.store_pkey')
WHERE index_size>0",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.461 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,259,"idle",2008-04-20 22:38:54 CEST,1/297,0,LOG,00000,"instruction : SELECT lanname,
rolname AS owner,
lanispl,
lanpltrusted,
lanacl
FROM pg_language, pg_roles
WHERE lanowner = pg_roles.oid
ORDER BY lanname",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.464 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,260,"idle",2008-04-20 22:38:54 CEST,1/298,0,LOG,00000,"instruction : SELECT
datname,
procpid,
client_addr,
usename,
current_query,
waiting,
xact_start,
query_start,
backend_start
FROM pg_stat_activity
ORDER BY datname, procpid",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.467 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,261,"idle",2008-04-20 22:38:54 CEST,1/299,0,LOG,00000,"instruction : SELECT
locktype,
database::regclass as database,
relation::regclass as relation,
page,
tuple,
virtualxid,
transactionid,
classid,
objid,
objsubid,
virtualtransaction,
pid,
mode,
granted
FROM pg_locks",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.471 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,262,"idle",2008-04-20 22:38:54 CEST,1/300,0,LOG,00000,"instruction : SELECT
name,
statement,
is_holdable,
is_binary,
is_scrollable,
creation_time
FROM pg_cursors
ORDER BY name",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.473 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,263,"idle",2008-04-20 22:38:54 CEST,1/301,0,LOG,00000,"instruction : SELECT
name,
statement,
prepare_time,
from_sql
FROM pg_prepared_statements
ORDER BY name",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.475 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,264,"idle",2008-04-20 22:38:54 CEST,1/302,0,LOG,00000,"instruction : SELECT
transaction,
gid,
prepared,
owner,
database
FROM pg_prepared_xacts
ORDER BY owner, database",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.478 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,265,"idle",2008-04-20 22:38:54 CEST,1/303,0,LOG,00000,"instruction : SELECT
checkpoints_timed,
checkpoints_req,
buffers_checkpoint,
buffers_clean,
maxwritten_clean,
buffers_backend,
buffers_alloc
FROM pg_stat_bgwriter",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.480 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,266,"idle",2008-04-20 22:38:54 CEST,1/304,0,LOG,00000,"instruction : SELECT datname,
blks_read,
blks_hit,
blks_hit::float/(blks_read+blks_hit+1)*100 as cachehitratio
FROM pg_stat_database
ORDER BY datname, cachehitratio",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.484 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,267,"idle",2008-04-20 22:38:54 CEST,1/305,0,LOG,00000,"instruction : SELECT
datname,
numbackends,
xact_commit,
xact_rollback,
blks_read,
blks_hit,
tup_returned,
tup_fetched,
tup_inserted,
tup_updated,
tup_deleted
FROM pg_stat_database
ORDER BY datname",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.487 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,268,"idle",2008-04-20 22:38:54 CEST,1/306,0,LOG,00000,"instruction : SELECT
schemaname,
relname,
seq_scan,
seq_tup_read,
idx_scan,
idx_tup_fetch,
n_tup_ins,
n_tup_upd,
n_tup_del,
n_tup_hot_upd,
n_live_tup,
n_dead_tup,
last_vacuum,
last_autovacuum,
last_analyze,
last_autoanalyze
FROM pg_stat_all_tables
ORDER BY schemaname, relname",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.501 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,269,"idle",2008-04-20 22:38:54 CEST,1/307,0,LOG,00000,"instruction : SELECT
schemaname,
relname,
max(greatest(last_vacuum, last_autovacuum)) as lastvac
FROM pg_stat_all_tables
WHERE
last_vacuum IS NOT NULL OR last_autovacuum IS NOT NULL
GROUP BY 1, 2
ORDER BY 3 DESC",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.505 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,270,"idle",2008-04-20 22:38:54 CEST,1/308,0,LOG,00000,"instruction : SELECT
schemaname,
relname,
max(greatest(last_analyze, last_autoanalyze)) as lastanalyze
FROM pg_stat_all_tables
WHERE
last_analyze IS NOT NULL OR last_autoanalyze IS NOT NULL
GROUP BY 1, 2
ORDER BY 3 DESC",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.510 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,271,"idle",2008-04-20 22:38:54 CEST,1/309,0,LOG,00000,"instruction : SELECT
schemaname,
relname,
indexrelname,
idx_scan,
idx_tup_read,
idx_tup_fetch
FROM pg_stat_all_indexes
ORDER BY schemaname, relname",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:38:56.531 CEST,"guillaume","pagila",10089,"127.0.0.1:38030",480ba9de.2769,272,"idle",2008-04-20 22:38:54 CEST,,0,LOG,00000,"déconnexion : durée de la session : 0:00:02.213
utilisateur=guillaume base=pagila hôte=127.0.0.1 port=38030",,,,,,,,"log_disconnections, postgres.c:3982"
2008-04-20 22:39:52.194 CEST,,,10192,"",480baa18.27d0,1,"/opt/postgresql-8.3/bin/postgres",2008-04-20 22:39:52 CEST,,0,LOG,00000,"connexion reçue : hôte=127.0.0.1 port=38032",,,,,,,,"BackendInitialize, postmaster.c:3027"
2008-04-20 22:39:52.194 CEST,"postgres","postgres",10192,"127.0.0.1:38032",480baa18.27d0,2,"authentication",2008-04-20 22:39:52 CEST,,0,LOG,00000,"connexion autorisée : utilisateur=postgres, base de données=postgres",,,,,,,,"BackendInitialize, postmaster.c:3097"
2008-04-20 22:39:52.215 CEST,"postgres","postgres",10192,"127.0.0.1:38032",480baa18.27d0,3,"idle",2008-04-20 22:39:52 CEST,1/321,0,LOG,00000,"instruction : SELECT COUNT(*), (SELECT setting FROM pg_settings WHERE name = 'max_connections'), datname FROM pg_stat_activity GROUP BY 2,3",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:39:52.348 CEST,"postgres","postgres",10192,"127.0.0.1:38032",480baa18.27d0,4,"idle",2008-04-20 22:39:52 CEST,,0,LOG,00000,"déconnexion : durée de la session : 0:00:00.155
utilisateur=postgres base=postgres hôte=127.0.0.1 port=38032",,,,,,,,"log_disconnections, postgres.c:3982"
2008-04-20 22:42:49.891 CEST,,,10429,"",480baac9.28bd,1,"/opt/postgresql-8.3/bin/postgres",2008-04-20 22:42:49 CEST,,0,LOG,00000,"connexion reçue : hôte=127.0.0.1 port=60630",,,,,,,,"BackendInitialize, postmaster.c:3027"
2008-04-20 22:42:49.892 CEST,"guillaume","pagila",10429,"127.0.0.1:60630",480baac9.28bd,2,"authentication",2008-04-20 22:42:49 CEST,,0,LOG,00000,"connexion autorisée : utilisateur=guillaume, base de données=pagila",,,,,,,,"BackendInitialize, postmaster.c:3097"
2008-04-20 22:42:49.898 CEST,"guillaume","pagila",10429,"127.0.0.1:60630",480baac9.28bd,3,"idle",2008-04-20 22:42:49 CEST,1/363,0,LOG,00000,"instruction : SHOW server_version",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:42:49.901 CEST,"guillaume","pagila",10429,"127.0.0.1:60630",480baac9.28bd,4,"idle",2008-04-20 22:42:49 CEST,1/364,0,LOG,00000,"instruction : SELECT 1 FROM pg_proc WHERE proname LIKE '%buffercache%'",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:42:49.905 CEST,"guillaume","pagila",10429,"127.0.0.1:60630",480baac9.28bd,5,"idle",2008-04-20 22:42:49 CEST,1/365,0,LOG,00000,"instruction : SELECT 1 FROM pg_proc WHERE proname LIKE '%stattuple%'",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:42:49.906 CEST,"guillaume","pagila",10429,"127.0.0.1:60630",480baac9.28bd,6,"idle",2008-04-20 22:42:49 CEST,1/366,0,LOG,00000,"instruction : SELECT 1 FROM pg_proc WHERE proname LIKE '%statindex%'",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:42:49.908 CEST,"guillaume","pagila",10429,"127.0.0.1:60630",480baac9.28bd,7,"idle",2008-04-20 22:42:49 CEST,1/367,0,LOG,00000,"instruction : show pool_status",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:42:49.908 CEST,"guillaume","pagila",10429,"127.0.0.1:60630",480baac9.28bd,8,"SHOW",2008-04-20 22:42:49 CEST,1/367,0,ERREUR,42704,"paramètre de configuration « pool_status » non reconnu",,,,,,"show pool_status",,"GetConfigOptionByName, guc.c:5499"
2008-04-20 22:42:49.909 CEST,"guillaume","pagila",10429,"127.0.0.1:60630",480baac9.28bd,9,"idle",2008-04-20 22:42:49 CEST,1/368,0,LOG,00000,"instruction : SELECT name, setting FROM pg_settings",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:42:49.914 CEST,"guillaume","pagila",10429,"127.0.0.1:60630",480baac9.28bd,10,"idle",2008-04-20 22:42:49 CEST,1/369,0,LOG,00000,"instruction : SHOW server_version",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:42:49.917 CEST,"guillaume","pagila",10429,"127.0.0.1:60630",480baac9.28bd,11,"idle",2008-04-20 22:42:49 CEST,1/370,0,LOG,00000,"instruction : SELECT 'PostgreSQL' AS product, version() AS version;",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:42:49.919 CEST,"guillaume","pagila",10429,"127.0.0.1:60630",480baac9.28bd,12,"idle",2008-04-20 22:42:49 CEST,1/371,0,LOG,00000,"instruction : SELECT name, setting FROM pg_settings
WHERE name IN ('max_connections', 'autovacuum_max_workers');",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:42:49.921 CEST,"guillaume","pagila",10429,"127.0.0.1:60630",480baac9.28bd,13,"idle",2008-04-20 22:42:49 CEST,1/372,0,LOG,00000,"instruction : SELECT COUNT(*) FROM pg_stat_activity",,,,,,,,"exec_simple_query, postgres.c:845"
2008-04-20 22:42:49.939 CEST,"guillaume","pagila",10429,"127.0.0.1:60630",480baac9.28bd,14,"idle",2008-04-20 22:42:49