> On Jan 24, 2022, at 10:02 PM, Michael Harris <harmic@gmail.com> wrote:
>
> My apologies,
>
> After posting this and looking at how it appears I realised that line
> wrapping makes the tables totally illegible.
>
> Here they are again with all unnecessary columns removed and others shortened.
>
> locktype | database | relation | pid | mode |
> granted | waitstart | relation
>
----------+----------+------------+---------+---------------------+---------+-------------------------------+--------------------
> relation | 529986 | 1842228045 | 2130531 | AccessShareLock | f
> | 2022-01-19 00:32:32.626152+01 | st.ctr_table_efr_oa
> relation | 529986 | 1842228045 | 2128603 | AccessExclusiveLock | t
> | | st.ctr_table_efr_oa
> relation | 529986 | 1842231489 | 2128603 | AccessExclusiveLock | f
> | 2022-01-19 00:32:32.924694+01 | st.tpd_oa
> relation | 529986 | 1842231489 | 2130531 | AccessShareLock | t
> | | st.tpd_oa
>
>
> pid | query_start | state_change | wait_event_type |
> wait_event | query
>
---------+--------------------+--------------------+-----------------+------------+-------------------------------------------------------------
> 2128603 | 00:32:32.924413+01 | 00:32:32.924413+01 | Lock |
> relation | DROP TABLE st.tpd_oa_18929
> 2130531 | 00:32:32.625706+01 | 00:32:32.625708+01 | Lock |
> relation | DELETE FROM st.ctr_table_efr_oa_19010 WHERE ropid =
> 44788868
>
> I hope this version is easier to read.
>
> Cheers
> Mike
> On Tue, 25 Jan 2022 at 15:49, Michael Harris <harmic@gmail.com> wrote:
It’s definitely tidier, but on my mac Mail.app and on Thunderbird there is still a line wrap problem. I don’t think
thatwill prevent the experts from helping out. I’m not one of them.
