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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Larry Rosenman | 2000-11-22 21:24:50 | Re: syslog output from explain looks weird... |
Previous Message | Tom Lane | 2000-11-22 20:11:37 | Talkative initdb, elog message levels |