Re: Request - repeat value of \pset title during \watch interations - Mailing list pgsql-general

From David G. Johnston
Subject Re: Request - repeat value of \pset title during \watch interations
Date
Msg-id CAKFQuwZWcBSB56Ub5rtp8R-09gsamNWDHBME29b0fXYy3X8Suw@mail.gmail.com
Whole thread Raw
In response to Re: Request - repeat value of \pset title during \watch interations  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Request - repeat value of \pset title during \watch interations
List pgsql-general
On Mon, Jan 11, 2016 at 8:14 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Michael Paquier <michael.paquier@gmail.com> writes:
> On Mon, Jan 11, 2016 at 3:36 AM, David G. Johnston
> <david.g.johnston@gmail.com> wrote:
>> When executing a query using \watch in psql the first execution of the query
>> includes "Title is [...]" when \pset title is in use.  Subsequent executions
>> do not.  Once that first display goes off-screen the information in the
>> title is no longer readily accessible.  If using \watch for a long-running
>> monitoring query it can be helpful to incorporate some context information
>> into the title.

> Yeah, this sounds like a good idea to show it at each iteration if the
> title is set.

Perhaps we should replace the "Watch every Ns" text by the user-given
title if a title has been set?  That would conserve screen space.

​The extra line doesn't both me and given the length of the timestamp I suspect many titles would cause the combined line length to exceed terminal width and cause wrapping anyway.  In my specific case it would though I am using an abnormally narrow width.

David J.
 

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Request - repeat value of \pset title during \watch interations
Next
From: "David G. Johnston"
Date:
Subject: Re: Request - repeat value of \pset title during \watch interations