relname     | locktype | database | relation  | page | tuple | transactionid | classid | objid | objsubid | transaction | pid  |       mode       | granted 
-----------------+----------+----------+-----------+------+-------+---------------+---------+-------+----------+-------------+------+------------------+---------
 topoarea_idx2   | relation |    17403 | 444162126 |      |       |               |         |       |          |     2237875 | 9331 | RowExclusiveLock | t
 pg_locks        | relation |    17403 |     10342 |      |       |               |         |       |          |     2237900 | 9418 | AccessShareLock  | t
 topoarea_idx2   | extend   |    17403 | 444162126 |      |       |               |         |       |          |     2237816 | 9403 | ExclusiveLock    | t
 topographicarea | relation |    17403 | 444162093 |      |       |               |         |       |          |     2237875 | 9331 | RowExclusiveLock | t
 topographicarea | relation |    17403 | 444162093 |      |       |               |         |       |          |     2237816 | 9403 | RowExclusiveLock | t
 pg_class        | relation |    17403 |      1259 |      |       |               |         |       |          |     2237900 | 9418 | AccessShareLock  | t
 topoarea_idx2   | extend   |    17403 | 444162126 |      |       |               |         |       |          |     2237875 | 9331 | ExclusiveLock    | f
 topoarea_idx1   | relation |    17403 | 444162120 |      |       |               |         |       |          |     2237875 | 9331 | RowExclusiveLock | t
 topoarea_idx2   | relation |    17403 | 444162126 |      |       |               |         |       |          |     2237816 | 9403 | RowExclusiveLock | t
 topoarea_idx1   | relation |    17403 | 444162120 |      |       |               |         |       |          |     2237816 | 9403 | RowExclusiveLock | t
(10 rows)


postgres 20180     1  0 08:32 pts/1    00:00:05 /usr/local/pgsql/bin/postmaster -i
postgres  9185 20180  0 15:08 pts/1    00:00:00 postgres: writer process
postgres  9186 20180  0 15:08 pts/1    00:00:00 postgres: stats buffer process
postgres  9187  9186  0 15:08 pts/1    00:00:00 postgres: stats collector process
postgres  9212 20180  0 15:09 pts/1    00:00:00 postgres: mastermap mastermap 192.168.89.2(44790) idle
postgres  9225 20180  0 15:09 pts/1    00:00:00 postgres: mastermap mastermap 192.168.89.3(52559) idle
postgres  9331 20180  1 15:10 pts/1    00:00:08 postgres: mastermap mastermap 192.168.89.3(52568) INSERT waiting
postgres  9332 20180  0 15:10 pts/1    00:00:01 postgres: mastermap mastermap 192.168.89.3(52569) idle
postgres  9333 20180  0 15:10 pts/1    00:00:00 postgres: mastermap mastermap 192.168.89.3(52570) idle
postgres  9334 20180  0 15:10 pts/1    00:00:00 postgres: mastermap mastermap 192.168.89.3(52571) idle
postgres  9403 20180  0 15:11 pts/1    00:00:00 postgres: mastermap mastermap 192.168.89.2(44962) INSERT
postgres  9404 20180  0 15:11 pts/1    00:00:00 postgres: mastermap mastermap 192.168.89.2(44963) idle
postgres  9405 20180  0 15:11 pts/1    00:00:00 postgres: mastermap mastermap 192.168.89.2(44964) idle
postgres  9406 20180  0 15:11 pts/1    00:00:00 postgres: mastermap mastermap 192.168.89.2(44965) idle
boris     9422 17187  0 15:22 pts/1    00:00:00 ps -Aef