Sergey Anikeyev sanikeev

sanikeev / postgres_queries_and_commands.sql

Created February 5, 2020 11:06 — forked from rgreenjr/postgres_queries_and_commands.sql

Useful PostgreSQL Queries and Commands

	-- show running queries (pre 9.2)
	SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
	FROM pg_stat_activity
	WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
	ORDER BY query_start desc;

	-- show running queries (9.2)
	SELECT pid, age(clock_timestamp(), query_start), usename, query
	FROM pg_stat_activity
	WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'

sanikeev / Таблицы в базе данных fl.ru

Last active August 29, 2015 14:26 — forked from mimoprohodil/Таблицы в базе данных fl.ru

	_log_pskb(date_created,link_id,logname,log)
	account(id,uid,sum)
	account_attach(account_id,file_id,name,orig_name)
	account_transaction(user_id,yd)
	activate_service(code,email,data)
	admin_log_users(user_id,log_id,last_comment_view)
	annoy(ip,last_req)
	articles(title,short,msgtext,sign,logo,link)
	articles_comments(from_id,parent_id,from_ip,created_time,article_id,msgtext,youtube_link)
	articles_comments_files(comment_id,file_id,small,inline,temp)

sanikeev / knockout-example.phtml

Created July 25, 2013 12:15

	<!doctype html>
	<html>
	<head><title>User Info</title></head>
	<body>

	<div id="#user" class="user">
	<div class="name">
	<label>User Name</label>
	<input type="text" data-bind="value: name">
	</div>