Skip site navigation (1) Skip section navigation (2)

syslog output from explain looks weird...

From: Larry Rosenman <ler(at)lerctr(dot)org>
To: PostgreSQL Hackers List <pgsql-hackers(at)postgresql(dot)org>
Subject: syslog output from explain looks weird...
Date: 2000-11-22 21:02:04
Message-ID: 20001122150203.A4022@lerami.lerctr.org (view raw or flat)
Thread:
Lists: pgsql-hackers
Just playing with the syslog functionality on 7.1devel, and the
explain output looks weird to me:

Nov 22 14:58:44 lerami pg-test[4005]: [2] DEBUG:  MoveOfflineLogs:
skip 0000000000000006
Nov 22 14:58:44 lerami pg-test[4005]: [3] DEBUG:  MoveOfflineLogs:
skip 0000000000000005
Nov 22 14:59:09 lerami pg-test[4005]: [4] NOTICE:  QUERY PLAN:
Nov 22 14:59:0 lerami Nov 22 14:59:09Index Scan using upslog_index on
upslog  (cost=0.00..88.65 rows=165 width=28)

seems like it should be better. 

The output at the client looks fine:
ler=# explain select * from upslog where upslogdate >='2000-11-01';
NOTICE:  QUERY PLAN:

Index Scan using upslog_index on upslog  (cost=0.00..88.65 rows=165
width=28)

EXPLAIN
ler=# 


-- 
Larry Rosenman                      http://www.lerctr.org/~ler
Phone: +1 972-414-9812 (voice) Internet: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

Responses

pgsql-hackers by date

Next:From: Larry RosenmanDate: 2000-11-22 21:24:50
Subject: Re: syslog output from explain looks weird...
Previous:From: Tom LaneDate: 2000-11-22 20:11:37
Subject: Talkative initdb, elog message levels

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group