2017-08-31 00:18:54 MSK postgres 127.0.0.1 ERROR:  deadlock detected
2017-08-31 00:18:54 MSK postgres 127.0.0.1 DETAIL:  Process 2143 waits for ShareLock on transaction 13051397; blocked by process 2145.
        Process 2145 waits for ShareLock on transaction 13051396; blocked by process 2143.
        Process 2143: Select процедура('параметр');
        Process 2145: Select процедура('JAN_226');
2017-08-31 00:18:54 MSK postgres 127.0.0.1 HINT:  See server log for query details.
2017-08-31 00:18:54 MSK postgres 127.0.0.1 CONTEXT:  while inserting index tuple (1,2) in relation "таблица1"
        SQL statement "Insert into таблица1 (ключевое_поле, поле1)
               (Select ключевое_поле, поле1
                  From таблица2 r
                 Where r.поле2 = параметр)
             on conflict (ключевое_поле)
             do update set поле1 = EXCLUDED.поле1"
        PL/pgSQL function процедура(character varying) line 6 at SQL statement
2017-08-31 00:18:54 MSK postgres 127.0.0.1 STATEMENT:  Select процедура('параметр');