Re: [pgAdmin4][RM#2950] Add marker to dashboard queries

From: Dave Page <dpage(at)pgadmin(dot)org>
To: Joao De Almeida Pereira <jdealmeidapereira(at)pivotal(dot)io>
Cc: Murtuza Zabuawala <murtuza(dot)zabuawala(at)enterprisedb(dot)com>, pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: [pgAdmin4][RM#2950] Add marker to dashboard queries
Date: 2018-02-19 11:17:59
Message-ID: CA+OCxoyyymycVZFnh8PRz49nYGFd_d=M1JdZh-V8AuVJothuqg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Thanks, patch applied.

On Thu, Feb 15, 2018 at 4:23 PM, Joao De Almeida Pereira <
jdealmeidapereira(at)pivotal(dot)io> wrote:

> Hello Murtuza,
> Looks like I missread the Issue then.
> In that case I think it might be the solution that we can implement.
> Unless anyone in the list as a different idea.
>
> Thanks
> Joao
>
> On Thu, Feb 15, 2018 at 11:12 AM Murtuza Zabuawala <murtuza.zabuawala@
> enterprisedb.com> wrote:
>
>> Hi Joao,
>>
>> It was mainly intended for PostgreSQL database logs and not pgAdmin4 logs
>> :)
>>
>>
>> --
>> Regards,
>> Murtuza Zabuawala
>> EnterpriseDB: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>>
>> On Thu, Feb 15, 2018 at 8:03 PM, Joao De Almeida Pereira <
>> jdealmeidapereira(at)pivotal(dot)io> wrote:
>>
>>> Hello Murtuza,
>>> I was looking into the Issue information and the solution that was
>>> provided there needs some polish. With the solution that was asked, the log
>>> will still be generated, but eventually will not show up in a log monitor,
>>> but nevertheless will be there.
>>>
>>> After some digging around the code I saw that we are using Logging Level
>>> 25 for all SQL queries what if we give 24 for the dashboard logs?
>>> Another option, that I didn't look into very much was the possibility of
>>> passing a logger into the execution functions or even somehow tag them so
>>> we can have more control over the logs that we generate. It would be nice
>>> if we could somehow ignore all the logs from the Dashboard. (
>>> http://flask.pocoo.org/docs/dev/logging/#other-libraries)
>>>
>>> What do you think about the suggestion?
>>>
>>> Thanks
>>> Joao
>>>
>>> On Thu, Feb 15, 2018 at 8:51 AM Murtuza Zabuawala <murtuza.zabuawala@
>>> enterprisedb.com> wrote:
>>>
>>>> Hi,
>>>>
>>>> PFA patch to add marker in dashboard queries, it will allow to user to
>>>> filter out those queries from database logs if required.
>>>>
>>>> --
>>>> Regards,
>>>> Murtuza Zabuawala
>>>> EnterpriseDB: http://www.enterprisedb.com
>>>> The Enterprise PostgreSQL Company
>>>>
>>>>
>>

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Browse pgadmin-hackers by date

  From Date Subject
Next Message pgAdmin 4 Jenkins 2018-02-19 11:21:08 Jenkins build is back to normal : pgadmin4-master-python26 #608
Previous Message Dave Page 2018-02-19 11:17:46 pgAdmin 4 commit: Add a marker (/*pga4dash*/) to the dashboard queries