Neil Conway wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > I am timing small queries, and found that a PREPARE/EXECUTE of > > "SELECT 1" takes about 1.2ms on my machine. A normal SELECT doesn't > > take much longer, so I am wondering why a simpler query isn't > > faster. > > log_executor_stats output isn't really too helpful -- if you can get > some gprof or oprofile output, we might have a better chance of seeing > if there is anything we can improve.
The problem with gprof is that I am going to see all the backend startup stuff too, no? Is there a way to get a dump just the run of the query? -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
