Em 10/3/2010 14:17, Leonardo Cezar escreveu:
> On Tue, Mar 9, 2010 at 4:23 PM, "André Ormenese ( Yahoo )"
> <[email protected]> wrote:
>
>> Boa tarde a todos !!!
>>
>> Pessoal instalei o pgfouine mas não consigo ler os logs. Os arquivos
>> html são criados mas sem informações.
>>
>
>> log_line_prefix = '%t [%p]: [%l-1] user=%u,db=%d '
>>
>> Quando tento executar o pgfouine com as seguintes opções :
>>
>> /usr/local/bin/pgfouine -file postgresql-2010-03-09.log -top 40 -report
>> queries.html=overall,bytype,slowest,n-mosttime,n-mostfrequent,n-slowestaverage
>> -report hourly.html=overall,hourly -report
>> errors.html=overall,n-mostfrequenterrors -format html-with-graphs
>> -logtype stderr
>>
>> recebo as seguintes mensagens :
>>
>> Unrecognized LOG or DEBUG line: user=,db= LOG: database system was shut
>> down at 2010-03-09 14:41:05 BRT - log line 1
>> Unrecognized LOG or DEBUG line: user=,db= LOG: database system is ready
>>
> A princípio seu LOG não contém nenhuma linha válida para o filtro que
> vc aplicou overall,hourly, mas tudo não passar de pura adivinhação se
> não tivermos um trecho do seu LOG.
>
> Podes enviar uma amostragem do log que vc está analisando:
> postgresql-2010-03-09.log??
>
> Abraço!
>
> -Leo
>
Segue trecho do log !!! Este é o de hoje ...
Parte do início :
2010-03-10 13:43:00 BRT [59663]: [1-1] user=,db= LOG: database system
is ready to accept connections
2010-03-10 13:43:00 BRT [59668]: [1-1] user=,db= LOG: autovacuum
launcher started
2010-03-10 13:44:18 BRT [59691]: [1-1] user=informatica,db=hemocentro
LOG: statement: SET DateStyle=ISO;SELECT oid,
pg_encoding_to_char(encoding) AS encoding,
datlastsysoid
FROM pg_database WHERE datname='hemocentro'
2010-03-10 13:44:18 BRT [59691]: [2-1] user=informatica,db=hemocentro
LOG: statement: set client_encoding to 'UNICODE'
2010-03-10 13:44:18 BRT [59691]: [3-1] user=informatica,db=hemocentro
LOG: statement: SELECT version();
2010-03-10 13:44:18 BRT [59691]: [4-1] user=informatica,db=hemocentro
LOG: statement: SELECT usecreatedb, usesuper, CASE WHEN usesuper THEN
pg_postmaster_start
_time() ELSE NULL END as upsince
FROM pg_user WHERE usename=current_user
2010-03-10 13:44:18 BRT [59691]: [5-1] user=informatica,db=hemocentro
LOG: statement: SELECT rolcreaterole, rolcreatedb FROM pg_roles WHERE
rolname = current_u
ser;
2010-03-10 13:44:18 BRT [59691]: [6-1] user=informatica,db=hemocentro
LOG: statement: SELECT db.oid, datname, db.dattablespace AS spcoid,
spcname, datallowconn
, datconfig, datacl, pg_encoding_to_char(encoding) AS serverencoding,
pg_get_userbyid(datdba) AS datowner,has_database_privilege(db.oid,
'CREATE') as cancreate,
current_setting('default_tablespace') AS default_tablespace,
descr.description
, db.datconnlimit as connectionlimit, db.datcollate as collate,
db.datctype as ctype FROM pg_database db
LEFT OUTER JOIN pg_tablespace ta ON db.dattablespace=ta.OID
LEFT OUTER JOIN pg_shdescription descr ON db.oid=descr.objoid
ORDER BY datname
2010-03-10 13:44:18 BRT [59691]: [7-1] user=informatica,db=hemocentro
LOG: statement: SELECT ts.oid, spcname, spclocation,
pg_get_userbyid(spcowner) as spcuser
, spcacl, pg_catalog.shobj_description(oid, 'pg_tablespace') AS
description FROM pg_tablespace ts
ORDER BY spcname
2010-03-10 13:44:18 BRT [59691]: [8-1] user=informatica,db=hemocentro
LOG: statement: SELECT cl.oid FROM pg_class cl JOIN pg_namespace ns ON
ns.oid=relnamespac
e
WHERE relname='pga_job' AND nspname='pgagent'
2010-03-10 13:44:18 BRT [59691]: [9-1] user=informatica,db=hemocentro
LOG: statement: SELECT has_table_privilege('pg_authid', 'SELECT')
2010-03-10 13:44:18 BRT [59691]: [10-1] user=informatica,db=hemocentro
LOG: statement: SELECT oid, *, pg_catalog.shobj_description(oid,
'pg_authid') AS des
cription FROM pg_authid WHERE NOT rolcanlogin ORDER BY rolname
2010-03-10 13:44:18 BRT [59691]: [11-1] user=informatica,db=hemocentro
LOG: statement: SELECT has_table_privilege('pg_authid', 'SELECT')
2010-03-10 13:44:18 BRT [59691]: [12-1] user=informatica,db=hemocentro
LOG: statement: SELECT oid, *, pg_catalog.shobj_description(oid,
'pg_authid') AS des
cription FROM pg_authid WHERE rolcanlogin ORDER BY rolname
2010-03-10 13:44:18 BRT [59691]: [13-1] user=informatica,db=hemocentro
LOG: statement: SELECT setting FROM pg_settings WHERE name IN
('autovacuum', 'track_coun
ts')
2010-03-10 13:44:18 BRT [59691]: [14-1] user=informatica,db=hemocentro
LOG: statement: SELECT proname FROM pg_proc WHERE
proname='pg_get_viewdef' AND proargtyp
es[1]=16
2010-03-10 13:44:18 BRT [59691]: [15-1] user=informatica,db=hemocentro
LOG: statement: SHOW search_path
2010-03-10 13:44:18 BRT [59691]: [16-1] user=informatica,db=hemocentro
LOG: statement: SELECT nspname, session_user=nspname AS isuser FROM
pg_namespace2
Agora um pedaço do final do log :
2010-03-10 14:39:15 BRT [59887]: [1430-1] user=fvaliero,db=hemocentro
LOG: statement: BEGIN;Select INC_CTRL('4110069-012','F')
2010-03-10 14:39:15 BRT [59887]: [1431-1] user=fvaliero,db=hemocentro
LOG: statement: SAVEPOINT _EXEC_SVP_03129008
2010-03-10 14:39:15 BRT [59887]: [1432-1] user=fvaliero,db=hemocentro
LOG: statement: SELECT SOR_EX_SOLIC.SOR_COD_EX_SOL as
Exame,SOR_CAD_KIT_CAMINHO_EQP.SOR_
CAMINHO as Caminho,SOR_CAD_KIT_CAMINHO_EQP.SOR_EQUIP as
Equipamento,sor_cad_kit.sor_ensaio_kit_kt as ExameEquipamento From
SOR_EX_SOLIC inner join sor_cad_kit o
n SOR_EX_SOLIC.SOR_COD_EX_SOL = sor_cod_ex_kt inner join
SOR_CAD_KIT_CAMINHO_EQP on SOR_CAD_KIT_CAMINHO_EQP.sor_cod_ex =
sor_cad_kit.sor_ensaio_kit_kt Where SOR
_EX_SOLIC.SOR_NUM_AMOSTRA_SOL = '' ORDER BY
SOR_CAD_KIT_CAMINHO_EQP.SOR_EQUIP,SOR_CAD_KIT_CAMINHO_EQP.SOR_CAMINHO,SOR_EX_SOLIC.SOR_COD_EX_SOL;
2010-03-10 14:39:15 BRT [59887]: [1433-1] user=fvaliero,db=hemocentro
LOG: statement: RELEASE _EXEC_SVP_03129008
2010-03-10 14:39:15 BRT [59887]: [1434-1] user=fvaliero,db=hemocentro
LOG: statement: COMMIT
2010-03-10 14:39:23 BRT [59887]: [1435-1] user=fvaliero,db=hemocentro
LOG: statement: SELECT * From SOR_RECEB WHERE SOR_NUM_AMOSTRA_RECEB =
'4110069-013';
2010-03-10 14:39:23 BRT [59887]: [1436-1] user=fvaliero,db=hemocentro
LOG: statement: SELECT * From SOR_CTRL_TUBO WHERE SOR_NUM_AMOSTRA_TB =
'4110069-013';
2010-03-10 14:39:23 BRT [59887]: [1437-1] user=fvaliero,db=hemocentro
LOG: statement: SELECT * From SOR_CTRL_TUBO WHERE SOR_NUM_AMOSTRA_TB =
'4110069-013' AND
SOR_CTRL_TUBO = 'W';
2010-03-10 14:39:23 BRT [59887]: [1438-1] user=fvaliero,db=hemocentro
LOG: statement: SELECT * From SOR_CTRL_TUBO WHERE SOR_NUM_AMOSTRA_TB =
'4110069-013';
2010-03-10 14:39:23 BRT [59887]: [1439-1] user=fvaliero,db=hemocentro
LOG: statement: SELECT * From SOR_RECEB WHERE SOR_NUM_AMOSTRA_RECEB =
'4110069-013';
2010-03-10 14:39:23 BRT [59887]: [1440-1] user=fvaliero,db=hemocentro
LOG: statement: SELECT SOR_TAB_NUCLEOS.SOR_NOME_NUCLEO_NC as
Desc_Nucleo,SOR_COD_SERV_US_
SV , SOR_NOME_SERV_SV, SOR_SITUACAO_SERV_SV From SOR_TAB_SERVICOS_US,
SOR_TAB_NUCLEOS Where SOR_TAB_SERVICOS_US.SOR_COD_NUCLEO_SV =
SOR_TAB_NUCLEOS.SOR_COD_NUCL
EO_NC AND SOR_TAB_SERVICOS_US.SOR_COD_SERV_US_SV = 41;
2010-03-10 14:39:37 BRT [59887]: [1441-1] user=fvaliero,db=hemocentro
LOG: statement: SELECT * From SOR_CTRL_TUBO WHERE SOR_NUM_AMOSTRA_TB =
'4110069-013' AND
SOR_CTRL_TUBO = 'F';
2010-03-10 14:39:37 BRT [59887]: [1442-1] user=fvaliero,db=hemocentro
LOG: statement: BEGIN;Select INC_CTRL('4110069-013','F')
2010-03-10 14:39:37 BRT [59887]: [1443-1] user=fvaliero,db=hemocentro
LOG: statement: SAVEPOINT _EXEC_SVP_03129008
2010-03-10 14:39:37 BRT [59887]: [1444-1] user=fvaliero,db=hemocentro
LOG: statement: SELECT SOR_EX_SOLIC.SOR_COD_EX_SOL as
Exame,SOR_CAD_KIT_CAMINHO_EQP.SOR_
CAMINHO as Caminho,SOR_CAD_KIT_CAMINHO_EQP.SOR_EQUIP as
Equipamento,sor_cad_kit.sor_ensaio_kit_kt as ExameEquipamento From
SOR_EX_SOLIC inner join sor_cad_kit o
n SOR_EX_SOLIC.SOR_COD_EX_SOL = sor_cod_ex_kt inner join
SOR_CAD_KIT_CAMINHO_EQP on SOR_CAD_KIT_CAMINHO_EQP.sor_cod_ex =
sor_cad_kit.sor_ensaio_kit_kt Where SOR
_EX_SOLIC.SOR_NUM_AMOSTRA_SOL = '' ORDER BY
SOR_CAD_KIT_CAMINHO_EQP.SOR_EQUIP,SOR_CAD_KIT_CAMINHO_EQP.SOR_CAMINHO,SOR_EX_SOLIC.SOR_COD_EX_SOL;
2010-03-10 14:39:37 BRT [59887]: [1445-1] user=fvaliero,db=hemocentro
LOG: statement: RELEASE _EXEC_SVP_03129008
2010-03-10 14:39:37 BRT [59887]: [1446-1] user=fvaliero,db=hemocentro
LOG: statement: COMMIT
2010-03-10 14:39:46 BRT [59887]: [1447-1] user=fvaliero,db=hemocentro
LOG: statement: SELECT * From SOR_RECEB WHERE SOR_NUM_AMOSTRA_RECEB =
'4110069-014';
2010-03-10 14:39:46 BRT [59887]: [1448-1] user=fvaliero,db=hemocentro
LOG: statement: SELECT * From SOR_CTRL_TUBO WHERE SOR_NUM_AMOSTRA_TB =
'4110069-014';
2010-03-10 14:39:46 BRT [59887]: [1449-1] user=fvaliero,db=hemocentro
LOG: statement: SELECT * From SOR_CTRL_TUBO WHERE SOR_NUM_AMOSTRA_TB =
'4110069-014' AND
SOR_CTRL_TUBO = 'W';
2010-03-10 14:39:46 BRT [59887]: [1450-1] user=fvaliero,db=hemocentro
LOG: statement: SELECT * From SOR_CTRL_TUBO WHERE SOR_NUM_AMOSTRA_TB =
'4110069-014';
2010-03-10 14:39:46 BRT [59887]: [1451-1] user=fvaliero,db=hemocentro
LOG: statement: SELECT * From SOR_RECEB WHERE SOR_NUM_AMOSTRA_RECEB =
'4110069-014';
2010-03-10 14:39:46 BRT [59887]: [1452-1] user=fvaliero,db=hemocentro
LOG: statement: SELECT SOR_TAB_NUCLEOS.SOR_NOME_NUCLEO_NC as
Desc_Nucleo,SOR_COD_SERV_US_
SV , SOR_NOME_SERV_SV, SOR_SITUACAO_SERV_SV From SOR_TAB_SERVICOS_US,
SOR_TAB_NUCLEOS Where SOR_TAB_SERVICOS_US.SOR_COD_NUCLEO_SV =
SOR_TAB_NUCLEOS.SOR_COD_NUCL
EO_NC AND SOR_TAB_SERVICOS_US.SOR_COD_SERV_US_SV = 41;
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
