open:postgresql [EL]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

# Postgresql


- [[postgresql could not connect to server]]
- [[cast to integer]]
- [[timestamp with timezone]]
- [[postgresql-random]]
- [[PostGIS]]
- [[postgresql_function]]
- [[pg_hba.conf]]
- [[Postgresql 기간 조회]]
- [[ERD 작성]]


## 실행 쿼리 확인

```sql
-- 컬럼 타입 확인
SELECT column_name, data_type
FROM   information_schema.columns
WHERE  table_name = 'rank_product'
ORDER  BY ordinal_position;

-- 실행중 쿼리 확인
SELECT * FROM pg_stat_activity ORDER BY query_start ASC;

-- 쿼리 취소
SELECT pg_cancel_backend(5045);

-- 쿼리 종료
SELECT pg_terminate_backend(8486)

-- 3분 이상 지난 쿼리 확인
select pid, query_start, query from pg_stat_activity where pid in (select distinct pid from pg_locks) and  current_timestamp - query_start > interval '180' second;
```