> Source: [sk102660](https://support.checkpoint.com/results/sk/sk102660)

# sk102660 - 'postgres' process on SmartEvent server consumes CPU at high level

| Property | Value |
|----------|-------|
| Solution ID | sk102660 |
| Date Created | 2014-09-22 |
| Last Modified | 2018-06-21 |
| Technical Level | Advanced |
| Products | Security Management Server |
| Versions | R82.10, R82, R81.20, R82.20 |
| Platform | Smart-1 |

## Symptoms

- * *postgres* process on SmartEvent server consumes CPU at high level.

  The following command can be used in expert mode to view the Postgres Processes resources usage: # ps -C postgres -o %cpu,%mem,cmd
* postgres debug shows:

  ```
  
  ERROR: deadlock detected
  DETAIL: Process <PID1> waits for ShareLock on transaction XXX; blocked by process <PID2>.
  Process <PID2> waits for ShareLock on transaction XXX; blocked by process <PID1>. 
  STATEMENT: Update Source set hostname='HOSTNAME' where (EventID >= NNN) AND (IP = [IP Address]) AND (hostname IS NULL) 
  ERROR: current transaction is aborted, commands ignored until end of transaction block
  ```

## Solution

This solution requires authentication. Please log in to view the full solution.

---

# Agent Instructions

This content is from the Check Point Support Center (https://support.checkpoint.com), the official knowledge base for Check Point cybersecurity products.

## Navigating This Knowledge Base

- **Complete index**: [llms.txt](https://support.checkpoint.com/llms.txt)
- **All SK articles**: [SecureKnowledge Sitemap](https://support.checkpoint.com/sitemaps/secureknowledge-sitemap-index.xml)
- **SK article URL pattern**: `https://support.checkpoint.com/results/sk/{skId}`
- **Markdown responses**: AI bot User-Agents automatically receive `text/markdown` content