āĻāĻā§āĻāĻŋāĻ¨āĻŋāĻ¯āĻŧāĻžāĻ° - āĻ˛ā§āĻ¯āĻžāĻāĻŋāĻ¨ āĻĨā§āĻā§ āĻ
āĻ¨ā§āĻŦāĻžāĻĻ - āĻ
āĻ¨ā§āĻĒā§āĻ°āĻžāĻŖāĻŋāĻ¤āĨ¤
āĻāĻāĻāĻ¨ āĻĒā§āĻ°āĻā§āĻļāĻ˛ā§ āĻ¸āĻŦāĻāĻŋāĻā§ āĻāĻ°āĻ¤ā§ āĻĒāĻžāĻ°ā§āĻ¨āĨ¤ (c) āĻāĻ°. āĻĄāĻŋāĻā§āĻ˛āĨ¤
āĻāĻĒāĻŋāĻā§āĻ°āĻžāĻĢāĨ¤
āĻ
āĻĨāĻŦāĻž āĻā§āĻ¨ āĻāĻāĻāĻ¨ āĻĄāĻžāĻāĻžāĻŦā§āĻ¸ āĻ
ā§āĻ¯āĻžāĻĄāĻŽāĻŋāĻ¨āĻŋāĻ¸ā§āĻā§āĻ°ā§āĻāĻ°āĻā§ āĻ¤āĻžāĻ° āĻĒā§āĻ°ā§āĻā§āĻ°āĻžāĻŽāĻŋāĻ āĻ
āĻ¤ā§āĻ¤ āĻŽāĻ¨ā§ āĻ°āĻžāĻāĻ¤ā§ āĻšāĻŦā§ āĻ¸ā§ āĻ¸āĻŽā§āĻĒāĻ°ā§āĻā§ āĻāĻāĻāĻŋ āĻāĻ˛ā§āĻĒāĨ¤
āĻā§āĻŽāĻŋāĻāĻž
āĻ¸āĻŽāĻ¸ā§āĻ¤ āĻ¨āĻžāĻŽ āĻĒāĻ°āĻŋāĻŦāĻ°ā§āĻ¤āĻ¨ āĻāĻ°āĻž āĻšāĻ¯āĻŧā§āĻā§āĨ¤ āĻŽā§āĻ¯āĻžāĻāĻā§āĻ˛ā§ āĻāĻ˛ā§āĻŽā§āĻ˛ā§āĨ¤ āĻāĻĒāĻžāĻĻāĻžāĻ¨ āĻļā§āĻ§ā§āĻŽāĻžāĻ¤ā§āĻ° āĻ˛ā§āĻāĻā§āĻ° āĻŦā§āĻ¯āĻā§āĻ¤āĻŋāĻāĻ¤ āĻŽāĻ¤āĻžāĻŽāĻ¤.
āĻāĻ¯āĻŧāĻžāĻ°ā§āĻ¨ā§āĻāĻŋāĻ° āĻĻāĻžāĻŦāĻŋāĻ¤ā§āĻ¯āĻžāĻ: āĻĒā§āĻ°āĻŦāĻ¨ā§āĻ§ā§āĻ° āĻĒāĻ°āĻŋāĻāĻ˛ā§āĻĒāĻŋāĻ¤ āĻ¸āĻŋāĻ°āĻŋāĻā§ āĻŦā§āĻ¯āĻŦāĻšā§āĻ¤ āĻā§āĻŦāĻŋāĻ˛ āĻāĻŦāĻ āĻ¸ā§āĻā§āĻ°āĻŋāĻĒā§āĻāĻā§āĻ˛āĻŋāĻ° āĻā§āĻ¨ āĻŦāĻŋāĻ¸ā§āĻ¤āĻžāĻ°āĻŋāĻ¤ āĻāĻŦāĻ āĻ¸āĻ āĻŋāĻ āĻŦāĻ°ā§āĻŖāĻ¨āĻž āĻĨāĻžāĻāĻŦā§ āĻ¨āĻžāĨ¤ āĻāĻĒāĻžāĻĻāĻžāĻ¨ āĻ āĻŦāĻŋāĻ˛āĻŽā§āĻŦā§ "AS IS" āĻŦā§āĻ¯āĻŦāĻšāĻžāĻ° āĻāĻ°āĻž āĻ¯āĻžāĻŦā§ āĻ¨āĻž.
āĻĒā§āĻ°āĻĨāĻŽāĻ¤, āĻĒā§āĻ°āĻā§āĻ° āĻĒāĻ°āĻŋāĻŽāĻžāĻŖā§ āĻāĻĒāĻžāĻĻāĻžāĻ¨ā§āĻ° āĻāĻžāĻ°āĻŖā§,
āĻĻā§āĻŦāĻŋāĻ¤ā§āĻ¯āĻŧāĻ¤, āĻĒā§āĻ°āĻā§āĻ¤ āĻā§āĻ°āĻžāĻšāĻā§āĻ° āĻā§āĻĒāĻžāĻĻāĻ¨ āĻāĻŋāĻ¤ā§āĻ¤āĻŋāĻ° āĻ¸āĻžāĻĨā§ āĻ¤ā§āĻā§āĻˇā§āĻŖāĻ¤āĻžāĻ° āĻāĻžāĻ°āĻŖā§āĨ¤
āĻ āĻ¤āĻāĻŦ, āĻ¨āĻŋāĻŦāĻ¨ā§āĻ§āĻā§āĻ˛āĻŋāĻ¤ā§ āĻā§āĻŦāĻ˛āĻŽāĻžāĻ¤ā§āĻ° āĻ¸āĻžāĻ§āĻžāĻ°āĻŖ āĻāĻāĻžāĻ°ā§ āĻ§āĻžāĻ°āĻŖāĻž āĻāĻŦāĻ āĻŦāĻ°ā§āĻŖāĻ¨āĻž āĻĻā§āĻāĻ¯āĻŧāĻž āĻšāĻŦā§āĨ¤
āĻšāĻ¯āĻŧāĻ¤ā§ āĻāĻŦāĻŋāĻˇā§āĻ¯āĻ¤ā§ āĻ¸āĻŋāĻ¸ā§āĻā§āĻŽāĻāĻŋ āĻāĻŋāĻāĻšāĻžāĻŦā§ āĻĒā§āĻ¸ā§āĻ āĻāĻ°āĻžāĻ° āĻ¸ā§āĻ¤āĻ°ā§ āĻŦāĻžāĻĄāĻŧāĻŦā§, āĻŦāĻž āĻ¨āĻžāĻ āĻšāĻ¤ā§ āĻĒāĻžāĻ°ā§āĨ¤ āĻ¸āĻŽāĻ¯āĻŧ āĻĒā§āĻ°āĻĻāĻ°ā§āĻļāĻ¨ āĻāĻ°āĻž āĻšāĻŦā§.
āĻāĻ˛ā§āĻĒā§āĻ° āĻļā§āĻ°ā§-
āĻĢāĻ˛āĻ¸ā§āĻŦāĻ°ā§āĻĒ āĻ¯āĻž āĻāĻā§āĻā§, āĻ¸āĻŦāĻā§āĻ¯āĻŧā§ āĻ¸āĻžāĻ§āĻžāĻ°āĻŖ āĻĒāĻĻā§ - "
āĻā§āĻ¨ āĻāĻŽāĻŋ āĻāĻ āĻ¸āĻŦ āĻĒā§āĻ°āĻ¯āĻŧā§āĻāĻ¨?
āĻāĻžāĻ˛, āĻĒā§āĻ°āĻĨāĻŽāĻ¤, āĻ¯āĻžāĻ¤ā§ āĻ¨āĻŋāĻā§āĻā§ āĻā§āĻ˛ā§ āĻ¨āĻž āĻ¯āĻžāĻ¯āĻŧ, āĻ
āĻŦāĻ¸āĻ°ā§āĻ° āĻā§āĻ°āĻŦāĻŽāĻ¯āĻŧ āĻĻāĻŋāĻ¨āĻā§āĻ˛āĻŋ āĻŽāĻ¨ā§ āĻāĻ°ā§āĨ¤
āĻĻā§āĻŦāĻŋāĻ¤ā§āĻ¯āĻŧāĻ¤, āĻ¯āĻž āĻ˛ā§āĻāĻž āĻšāĻ¯āĻŧā§āĻā§ āĻ¤āĻž āĻĒāĻĻā§āĻ§āĻ¤āĻŋāĻāĻ¤ āĻāĻ°āĻžāĨ¤ āĻāĻ¤āĻŋāĻŽāĻ§ā§āĻ¯ā§ āĻ¨āĻŋāĻā§āĻ° āĻāĻ¨ā§āĻ¯, āĻāĻāĻ¨āĻ āĻāĻāĻ¨āĻ āĻāĻŽāĻŋ āĻŦāĻŋāĻā§āĻ°āĻžāĻ¨ā§āĻ¤ āĻšāĻ¤ā§ āĻļā§āĻ°ā§ āĻāĻ°āĻŋ āĻāĻŦāĻ āĻĒā§āĻĨāĻ āĻ
āĻāĻļāĻā§āĻ˛āĻŋ āĻā§āĻ˛ā§ āĻ¯āĻžāĻāĨ¤
āĻāĻžāĻ˛, āĻāĻŦāĻ āĻ¸āĻŦāĻā§āĻ¯āĻŧā§ āĻā§āĻ°ā§āĻ¤ā§āĻŦāĻĒā§āĻ°ā§āĻŖāĻāĻžāĻŦā§ - āĻšāĻ āĻžā§ āĻāĻāĻŋ āĻāĻžāĻ°āĻ āĻĒāĻā§āĻˇā§ āĻāĻžāĻ°ā§āĻ¯āĻāĻ° āĻšāĻ¤ā§ āĻĒāĻžāĻ°ā§ āĻāĻŦāĻ āĻāĻžāĻāĻžāĻāĻŋ āĻĒā§āĻ¨āĻ°āĻžāĻ¯āĻŧ āĻāĻĻā§āĻāĻžāĻŦāĻ¨ āĻ¨āĻž āĻāĻ°āĻ¤ā§ āĻāĻŦāĻ āĻ°ā§āĻ āĻ¸āĻāĻā§āĻ°āĻš āĻ¨āĻž āĻāĻ°āĻ¤ā§ āĻ¸āĻšāĻžāĻ¯āĻŧāĻ¤āĻž āĻāĻ°āĻ¤ā§ āĻĒāĻžāĻ°ā§āĨ¤ āĻ āĻ¨ā§āĻ¯ āĻāĻĨāĻžāĻ¯āĻŧ, āĻāĻĒāĻ¨āĻžāĻ° āĻāĻ°ā§āĻŽāĻĢāĻ˛ āĻāĻ¨ā§āĻ¨āĻ¤ āĻāĻ°ā§āĻ¨ (āĻāĻŦāĻ°āĻāĻ¸ā§āĻāĻŋ āĻ¨āĻ¯āĻŧ)āĨ¤ āĻāĻ āĻĒā§āĻĨāĻŋāĻŦā§āĻ¤ā§ āĻ¸āĻŦāĻā§āĻ¯āĻŧā§ āĻŽā§āĻ˛ā§āĻ¯āĻŦāĻžāĻ¨ āĻāĻŋāĻ¨āĻŋāĻ¸ āĻšāĻ˛ āĻ§āĻžāĻ°āĻŖāĻž. āĻĒā§āĻ°āĻ§āĻžāĻ¨ āĻāĻŋāĻ¨āĻŋāĻ¸ āĻāĻāĻāĻŋ āĻ§āĻžāĻ°āĻŖāĻž āĻā§āĻāĻā§ āĻŦā§āĻ° āĻāĻ°āĻž āĻšāĻ¯āĻŧāĨ¤ āĻāĻŦāĻ āĻ§āĻžāĻ°āĻŖāĻžāĻāĻŋāĻā§ āĻŦāĻžāĻ¸ā§āĻ¤āĻŦā§ āĻ°ā§āĻĒāĻžāĻ¨ā§āĻ¤āĻ° āĻāĻ°āĻž āĻāĻ¤āĻŋāĻŽāĻ§ā§āĻ¯ā§āĻ āĻāĻāĻāĻŋ āĻ¸āĻŽā§āĻĒā§āĻ°ā§āĻŖ āĻĒā§āĻ°āĻ¯ā§āĻā§āĻ¤āĻŋāĻāĻ¤ āĻ¸āĻŽāĻ¸ā§āĻ¯āĻžāĨ¤
āĻ¤āĻžāĻ āĻāĻ¸ā§āĻ¤ā§ āĻāĻ¸ā§āĻ¤ā§ āĻļā§āĻ°ā§ āĻāĻ°āĻž āĻ¯āĻžāĻ...
āĻ¸āĻŽāĻ¸ā§āĻ¯āĻž āĻĒā§āĻ°āĻŖāĻ¯āĻŧāĻ¨.
āĻāĻĒāĻ˛āĻŦā§āĻ§:
PostgreSQL(10.5), āĻŽāĻŋāĻļā§āĻ° āĻ˛ā§āĻĄ (OLTP+DSS), āĻŽāĻžāĻāĻžāĻ°āĻŋ āĻĨā§āĻā§ āĻšāĻžāĻ˛āĻāĻž āĻ˛ā§āĻĄ, AWS āĻā§āĻ˛āĻžāĻāĻĄā§ āĻšā§āĻ¸ā§āĻ āĻāĻ°āĻž āĻšāĻ¯āĻŧā§āĻā§āĨ¤
āĻā§āĻ¨ āĻĄāĻžāĻāĻžāĻŦā§āĻ¸ āĻĒāĻ°ā§āĻ¯āĻŦā§āĻā§āĻˇāĻŖ āĻ¨ā§āĻ, āĻ
āĻŦāĻāĻžāĻ āĻžāĻŽā§ āĻĒāĻ°ā§āĻ¯āĻŦā§āĻā§āĻˇāĻŖ āĻāĻāĻāĻŋ āĻ¨ā§āĻ¯ā§āĻ¨āĻ¤āĻŽ āĻāĻ¨āĻĢāĻŋāĻāĻžāĻ°ā§āĻļāĻ¨ā§ āĻ¸ā§āĻā§āĻ¯āĻžāĻ¨ā§āĻĄāĻžāĻ°ā§āĻĄ AWS āĻ¸āĻ°āĻā§āĻāĻžāĻŽ āĻšāĻŋāĻ¸āĻžāĻŦā§ āĻāĻĒāĻ¸ā§āĻĨāĻžāĻĒāĻ¨ āĻāĻ°āĻž āĻšāĻ¯āĻŧāĨ¤
āĻĒā§āĻ°āĻ¯āĻŧā§āĻāĻ¨:
āĻĄāĻžāĻāĻžāĻŦā§āĻ¸ā§āĻ° āĻāĻ°ā§āĻŽāĻā§āĻˇāĻŽāĻ¤āĻž āĻāĻŦāĻ āĻ¸ā§āĻĨāĻŋāĻ¤āĻŋ āĻ¨āĻŋāĻ°ā§āĻā§āĻˇāĻŖ āĻāĻ°ā§āĻ¨, āĻāĻžāĻ°ā§ āĻĄāĻžāĻāĻžāĻŦā§āĻ¸ āĻĒā§āĻ°āĻļā§āĻ¨āĻā§āĻ˛āĻŋ āĻ
āĻĒā§āĻāĻŋāĻŽāĻžāĻāĻ āĻāĻ°āĻžāĻ° āĻāĻ¨ā§āĻ¯ āĻĒā§āĻ°āĻžāĻĨāĻŽāĻŋāĻ āĻ¤āĻĨā§āĻ¯ āĻā§āĻāĻā§āĻ¨ āĻāĻŦāĻ āĻāĻā§āĨ¤
āĻ¸āĻŽāĻžāĻ§āĻžāĻ¨ā§āĻ° āĻ¸āĻāĻā§āĻˇāĻŋāĻĒā§āĻ¤ āĻā§āĻŽāĻŋāĻāĻž āĻŦāĻž āĻŦāĻŋāĻļā§āĻ˛ā§āĻˇāĻŖ
āĻļā§āĻ°ā§ āĻāĻ°āĻžāĻ° āĻāĻ¨ā§āĻ¯, āĻāĻ¸ā§āĻ¨ āĻĒā§āĻ°āĻā§āĻļāĻ˛ā§āĻ° āĻ¸ā§āĻŦāĻŋāĻ§āĻž āĻāĻŦāĻ āĻ¸āĻŽāĻ¸ā§āĻ¯āĻžāĻā§āĻ˛āĻŋāĻ° āĻ¤ā§āĻ˛āĻ¨āĻžāĻŽā§āĻ˛āĻ āĻŦāĻŋāĻļā§āĻ˛ā§āĻˇāĻŖā§āĻ° āĻĻā§āĻˇā§āĻāĻŋāĻā§āĻŖ āĻĨā§āĻā§ āĻ¸āĻŽāĻ¸ā§āĻ¯āĻž āĻ¸āĻŽāĻžāĻ§āĻžāĻ¨ā§āĻ° āĻŦāĻŋāĻāĻ˛ā§āĻĒāĻā§āĻ˛āĻŋ āĻŦāĻŋāĻļā§āĻ˛ā§āĻˇāĻŖ āĻāĻ°āĻžāĻ° āĻā§āĻˇā§āĻāĻž āĻāĻ°āĻŋ āĻāĻŦāĻ āĻ¯āĻžāĻ°āĻž āĻāĻ°ā§āĻŽā§āĻĻā§āĻ° āĻ¤āĻžāĻ˛āĻŋāĻāĻžāĻ¯āĻŧ āĻĨāĻžāĻāĻžāĻ° āĻāĻĨāĻž āĻ¤āĻžāĻĻā§āĻ° āĻ¸ā§āĻŦāĻŋāĻ§āĻž āĻāĻŦāĻ āĻā§āĻˇāĻ¤āĻŋāĻ° āĻ¸āĻžāĻĨā§ āĻŽā§āĻāĻžāĻŦāĻŋāĻ˛āĻž āĻāĻ°āĻ¤ā§ āĻĻāĻŋāĻ¨āĨ¤ āĻŦā§āĻ¯āĻŦāĻ¸ā§āĻĨāĻžāĻĒāĻ¨āĻžāĻ°
āĻŦāĻŋāĻāĻ˛ā§āĻĒ 1 - "āĻāĻžāĻšāĻŋāĻĻāĻž āĻ āĻ¨ā§āĻ¯āĻžāĻ¯āĻŧā§ āĻāĻžāĻ āĻāĻ°āĻž"
āĻāĻŽāĻ°āĻž āĻ¸āĻŦāĻāĻŋāĻā§ āĻ¯ā§āĻŽāĻ¨ āĻāĻā§ āĻ°ā§āĻā§ āĻĻāĻŋāĻāĨ¤ āĻ¯āĻĻāĻŋ āĻā§āĻ°āĻžāĻšāĻ āĻ¸ā§āĻŦāĻžāĻ¸ā§āĻĨā§āĻ¯, āĻĄāĻžāĻāĻžāĻŦā§āĻ¸ āĻŦāĻž āĻ
ā§āĻ¯āĻžāĻĒā§āĻ˛āĻŋāĻā§āĻļāĻ¨ā§āĻ° āĻāĻžāĻ°ā§āĻ¯āĻāĻžāĻ°āĻŋāĻ¤āĻž āĻ¸āĻŽā§āĻĒāĻ°ā§āĻā§ āĻ¸āĻ¨ā§āĻ¤ā§āĻˇā§āĻ āĻ¨āĻž āĻšāĻ¨ āĻ¤āĻŦā§ āĻ¤āĻŋāĻ¨āĻŋ āĻ-āĻŽā§āĻāĻ˛ā§āĻ° āĻŽāĻžāĻ§ā§āĻ¯āĻŽā§ āĻŦāĻž āĻāĻŋāĻāĻŋāĻ āĻŦāĻžāĻā§āĻ¸ā§ āĻāĻāĻāĻŋ āĻāĻāĻ¨āĻž āĻ¤ā§āĻ°āĻŋ āĻāĻ°ā§ āĻĄāĻŋāĻŦāĻŋāĻ āĻāĻā§āĻāĻŋāĻ¨āĻŋāĻ¯āĻŧāĻžāĻ°āĻĻā§āĻ° āĻ
āĻŦāĻšāĻŋāĻ¤ āĻāĻ°āĻŦā§āĻ¨āĨ¤
āĻāĻāĻāĻ¨ āĻĒā§āĻ°āĻā§āĻļāĻ˛ā§, āĻāĻāĻāĻŋ āĻŦāĻŋāĻā§āĻāĻĒā§āĻ¤āĻŋ āĻĒāĻžāĻāĻ¯āĻŧāĻžāĻ° āĻĒāĻ°, āĻ¸āĻŽāĻ¸ā§āĻ¯āĻžāĻāĻŋ āĻŦā§āĻāĻŦā§āĻ¨, āĻāĻāĻāĻŋ āĻ¸āĻŽāĻžāĻ§āĻžāĻ¨ āĻ
āĻĢāĻžāĻ° āĻāĻ°āĻŦā§āĻ¨ āĻŦāĻž āĻ¸āĻŽāĻ¸ā§āĻ¯āĻžāĻāĻŋ āĻ¸āĻŽāĻžāĻ§āĻžāĻ¨ āĻāĻ°āĻŦā§āĻ¨, āĻāĻ āĻāĻļāĻžāĻ¯āĻŧ āĻ¯ā§ āĻ¸āĻŦāĻāĻŋāĻā§ āĻ¨āĻŋāĻā§āĻ āĻ¸āĻŽāĻžāĻ§āĻžāĻ¨ āĻšāĻŦā§ āĻāĻŦāĻ āĻ¯āĻžāĻāĻšā§āĻ, āĻ¸āĻŦāĻāĻŋāĻā§ āĻļā§āĻā§āĻ°āĻ āĻā§āĻ˛ā§ āĻ¯āĻžāĻŦā§āĨ¤
āĻāĻŋāĻā§āĻāĻžāĻ°āĻŦā§āĻ°ā§āĻĄ āĻāĻŦāĻ āĻĄā§āĻ¨āĻžāĻāĻ¸, āĻā§āĻˇāĻ¤ āĻāĻŦāĻ āĻŦāĻžāĻŽā§āĻĒāĻ¸āĻāĻŋāĻā§āĻāĻžāĻ°āĻŦā§āĻ°ā§āĻĄ āĻāĻŦāĻ āĻĄā§āĻ¨āĻžāĻāĻ¸:
1. āĻ
āĻ¤āĻŋāĻ°āĻŋāĻā§āĻ¤ āĻāĻŋāĻā§ āĻāĻ°āĻžāĻ° āĻ¨ā§āĻ
2. āĻ¸āĻŦāĻ¸āĻŽāĻ¯āĻŧ āĻŦāĻžāĻāĻ°ā§ āĻŦā§āĻ° āĻšāĻ¯āĻŧā§ āĻ¨ā§āĻāĻ°āĻž āĻāĻ°āĻžāĻ° āĻ¸ā§āĻ¯ā§āĻ āĻĨāĻžāĻā§āĨ¤
3. āĻ
āĻ¨ā§āĻ āĻ¸āĻŽāĻ¯āĻŧ āĻ¯āĻž āĻāĻĒāĻ¨āĻŋ āĻ¨āĻŋāĻā§āĻ° āĻāĻ¨ā§āĻ¯ āĻŦā§āĻ¯āĻ¯āĻŧ āĻāĻ°āĻ¤ā§ āĻĒāĻžāĻ°ā§āĻ¨āĨ¤
āĻā§āĻˇāĻ¤ āĻāĻŦāĻ āĻŦāĻžāĻ§āĻž:
1. āĻļā§āĻā§āĻ°āĻ āĻŦāĻž āĻĒāĻ°ā§, āĻā§āĻ°āĻžāĻšāĻ āĻāĻ āĻĒā§āĻĨāĻŋāĻŦā§āĻ¤ā§ āĻ¸āĻ¤ā§āĻ¤āĻž āĻāĻŦāĻ āĻ¸āĻ°ā§āĻŦāĻāĻ¨ā§āĻ¨ āĻ¨ā§āĻ¯āĻžāĻ¯āĻŧāĻŦāĻŋāĻāĻžāĻ°ā§āĻ° āĻ¸āĻžāĻ°āĻŽāĻ°ā§āĻŽ āĻ¸āĻŽā§āĻĒāĻ°ā§āĻā§ āĻāĻŋāĻ¨ā§āĻ¤āĻž āĻāĻ°āĻŦā§āĻ¨ āĻāĻŦāĻ āĻ¨āĻŋāĻā§āĻā§ āĻāĻŦāĻžāĻ° āĻĒā§āĻ°āĻļā§āĻ¨ āĻāĻ°āĻŦā§āĻ¨ - āĻā§āĻ¨ āĻāĻŽāĻŋ āĻ¤āĻžāĻĻā§āĻ° āĻāĻŽāĻžāĻ° āĻ
āĻ°ā§āĻĨ āĻĒā§āĻ°āĻĻāĻžāĻ¨ āĻāĻ°āĻāĻŋ? āĻĢāĻ˛āĻžāĻĢāĻ˛ āĻ¸āĻ°ā§āĻŦāĻĻāĻž āĻāĻāĻ - āĻāĻāĻŽāĻžāĻ¤ā§āĻ° āĻĒā§āĻ°āĻļā§āĻ¨ āĻ¯āĻāĻ¨ āĻā§āĻ°āĻžāĻšāĻ āĻŦāĻŋāĻ°āĻā§āĻ¤ āĻšāĻ¯āĻŧ āĻāĻŦāĻ āĻŦāĻŋāĻĻāĻžāĻ¯āĻŧ āĻ¨ā§āĻŦā§āĨ¤ āĻāĻ° āĻĢāĻŋāĻĄāĻžāĻ° āĻāĻžāĻ˛āĻŋāĨ¤ āĻāĻāĻž āĻĻā§āĻāĻāĻāĻ¨āĻ.
2. āĻāĻāĻāĻ¨ āĻĒā§āĻ°āĻā§āĻļāĻ˛ā§āĻ° āĻŦāĻŋāĻāĻžāĻļ āĻļā§āĻ¨ā§āĻ¯āĨ¤
3. āĻāĻžāĻ āĻāĻŦāĻ āĻ˛ā§āĻĄ āĻāĻ°āĻžāĻ° āĻ¸āĻŽāĻ¯āĻŧ āĻ¨āĻŋāĻ°ā§āĻ§āĻžāĻ°āĻŖā§ āĻ
āĻ¸ā§āĻŦāĻŋāĻ§āĻž
āĻŦāĻŋāĻāĻ˛ā§āĻĒ 2 - "āĻāĻā§āĻāĻŋāĻ° āĻ¸āĻžāĻĨā§ āĻ¨āĻžāĻ, āĻā§āĻ¤āĻž āĻĒāĻ°ā§ āĻāĻŦāĻ āĻĒāĻ°ā§āĻ¨"
āĻ
āĻ¨ā§āĻā§āĻā§āĻĻ 1-āĻā§āĻ¨ āĻāĻŽāĻ°āĻž āĻāĻāĻāĻŋ āĻŽāĻ¨āĻŋāĻāĻ°āĻŋāĻ āĻ¸āĻŋāĻ¸ā§āĻā§āĻŽ āĻĒā§āĻ°āĻ¯āĻŧā§āĻāĻ¨, āĻāĻŽāĻ°āĻž āĻ¸āĻŦ āĻ
āĻ¨ā§āĻ°ā§āĻ§ āĻā§āĻ°āĻšāĻŖ āĻāĻ°āĻž āĻšāĻŦā§. āĻāĻŽāĻ°āĻž āĻĄā§āĻāĻž āĻ
āĻāĻŋāĻ§āĻžāĻ¨ āĻāĻŦāĻ āĻāĻ¤āĻŋāĻļā§āĻ˛ āĻĻā§āĻļā§āĻ¯āĻā§āĻ˛āĻŋāĻ¤ā§ āĻ¸āĻŽāĻ¸ā§āĻ¤ āĻ§āĻ°āĻŖā§āĻ° āĻĒā§āĻ°āĻļā§āĻ¨ā§āĻ° āĻāĻāĻāĻŋ āĻā§āĻā§āĻ āĻāĻžāĻ˛ā§ āĻāĻ°āĻŋ, āĻ¸āĻŽāĻ¸ā§āĻ¤ āĻ§āĻ°āĻŖā§āĻ° āĻāĻžāĻāĻ¨ā§āĻāĻžāĻ° āĻāĻžāĻ˛ā§ āĻāĻ°āĻŋ, āĻ¸āĻŦāĻāĻŋāĻā§āĻā§ āĻā§āĻŦāĻŋāĻ˛ā§ āĻ¨āĻŋāĻ¯āĻŧā§ āĻāĻ¸āĻŋ, āĻĒāĻ°ā§āĻ¯āĻžāĻ¯āĻŧāĻā§āĻ°āĻŽā§ āĻ¤āĻžāĻ˛āĻŋāĻāĻž āĻāĻŦāĻ āĻā§āĻŦāĻŋāĻ˛ āĻŦāĻŋāĻļā§āĻ˛ā§āĻˇāĻŖ āĻāĻ°āĻŋ, āĻ¯ā§āĻŽāĻ¨āĻāĻŋ āĻāĻŋāĻ˛āĨ¤ āĻĢāĻ˛āĻ¸ā§āĻŦāĻ°ā§āĻĒ, āĻāĻŽāĻžāĻĻā§āĻ° āĻāĻžāĻā§ āĻ¸ā§āĻ¨ā§āĻĻāĻ° āĻŦāĻž āĻā§āĻŦ āĻŦā§āĻļāĻŋ āĻā§āĻ°āĻžāĻĢ, āĻā§āĻŦāĻŋāĻ˛, āĻ°āĻŋāĻĒā§āĻ°ā§āĻ āĻ¨ā§āĻāĨ¤ āĻĒā§āĻ°āĻ§āĻžāĻ¨ āĻāĻŋāĻ¨āĻŋāĻ¸ - āĻ¯ā§ āĻāĻ°ā§, āĻāĻ°ā§ āĻšāĻŦā§.
āĻ
āĻ¨ā§āĻā§āĻā§āĻĻ 2- āĻāĻžāĻ°ā§āĻ¯āĻāĻ˛āĻžāĻĒ āĻ¤ā§āĻ°āĻŋ āĻāĻ°ā§āĻ¨ - āĻāĻ āĻ¸āĻŽāĻ¸ā§āĻ¤ āĻŦāĻŋāĻļā§āĻ˛ā§āĻˇāĻŖ āĻāĻžāĻ˛āĻžāĻ¨āĨ¤
āĻ
āĻ¨ā§āĻā§āĻā§āĻĻ 3-āĻāĻŽāĻ°āĻž āĻāĻāĻāĻŋ āĻ¨āĻŋāĻ°ā§āĻĻāĻŋāĻˇā§āĻ āĻ¨āĻĨāĻŋ āĻĒā§āĻ°āĻ¸ā§āĻ¤ā§āĻ¤ āĻāĻ°āĻāĻŋ, āĻāĻŽāĻ°āĻž āĻāĻ āĻ¨āĻĨāĻŋāĻāĻŋāĻā§ āĻŦāĻ˛āĻŋ, āĻ¸āĻšāĻāĻāĻžāĻŦā§ - "āĻāĻŽāĻ°āĻž āĻā§āĻāĻžāĻŦā§ āĻĄāĻžāĻāĻžāĻŦā§āĻ¸ āĻ¸āĻā§āĻāĻŋāĻ¤ āĻāĻ°āĻŦāĨ¤"
āĻ
āĻ¨ā§āĻā§āĻā§āĻĻ 4- āĻā§āĻ°āĻžāĻšāĻ, āĻā§āĻ°āĻžāĻĢ āĻāĻŦāĻ āĻĒāĻ°āĻŋāĻ¸āĻāĻā§āĻ¯āĻžāĻ¨ā§āĻ° āĻāĻ āĻ¸āĻŽāĻ¸ā§āĻ¤ āĻŽāĻšāĻŋāĻŽāĻž āĻĻā§āĻā§, āĻāĻāĻāĻŋ āĻļāĻŋāĻļā§āĻ¸ā§āĻ˛āĻ āĻ¨āĻŋāĻ°ā§āĻŦā§āĻ§ āĻāĻ¤ā§āĻŽāĻŦāĻŋāĻļā§āĻŦāĻžāĻ¸ā§ - āĻāĻāĻ¨ āĻ¸āĻŦāĻāĻŋāĻā§āĻ āĻāĻŽāĻžāĻĻā§āĻ° āĻāĻ¨ā§āĻ¯ āĻāĻžāĻ āĻāĻ°āĻŦā§, āĻļā§āĻā§āĻ°āĻāĨ¤ āĻāĻŦāĻ, āĻ¸āĻšāĻā§ āĻāĻŦāĻ āĻŦā§āĻ¯āĻĨāĻžāĻšā§āĻ¨āĻāĻžāĻŦā§ āĻ¤āĻžāĻĻā§āĻ° āĻāĻ°ā§āĻĨāĻŋāĻ āĻ¸āĻāĻ¸ā§āĻĨāĻžāĻ¨āĻā§āĻ˛āĻŋāĻ° āĻ¸āĻžāĻĨā§ āĻ
āĻāĻļ āĻ¨āĻŋāĻ¨āĨ¤ āĻŦā§āĻ¯āĻŦāĻ¸ā§āĻĨāĻžāĻĒāĻ¨āĻžāĻ āĻ¨āĻŋāĻļā§āĻāĻŋāĻ¤ āĻ¯ā§ āĻāĻŽāĻžāĻĻā§āĻ° āĻĒā§āĻ°āĻā§āĻļāĻ˛ā§āĻ°āĻž āĻāĻ ā§āĻ° āĻĒāĻ°āĻŋāĻļā§āĻ°āĻŽ āĻāĻ°āĻā§āĻ¨āĨ¤ āĻ¸āĻ°ā§āĻŦā§āĻā§āĻ āĻ˛ā§āĻĄ āĻšāĻā§āĻā§āĨ¤
āĻ
āĻ¨ā§āĻā§āĻā§āĻĻ 5- āĻ¨āĻŋāĻ¯āĻŧāĻŽāĻŋāĻ¤ āĻ§āĻžāĻĒ 1 āĻĒā§āĻ¨āĻ°āĻžāĻŦā§āĻ¤ā§āĻ¤āĻŋ āĻāĻ°ā§āĻ¨.
āĻāĻŋāĻā§āĻāĻžāĻ°āĻŦā§āĻ°ā§āĻĄ āĻāĻŦāĻ āĻĄā§āĻ¨āĻžāĻāĻ¸, āĻā§āĻˇāĻ¤ āĻāĻŦāĻ āĻŦāĻžāĻŽā§āĻĒāĻ¸āĻāĻŋāĻā§āĻāĻžāĻ°āĻŦā§āĻ°ā§āĻĄ āĻāĻŦāĻ āĻĄā§āĻ¨āĻžāĻāĻ¸:
1. āĻŽā§āĻ¯āĻžāĻ¨ā§āĻāĻžāĻ° āĻāĻŦāĻ āĻāĻā§āĻāĻŋāĻ¨āĻŋāĻ¯āĻŧāĻžāĻ°āĻĻā§āĻ° āĻā§āĻŦāĻ¨ āĻ¸āĻšāĻ, āĻ
āĻ¨ā§āĻŽāĻžāĻ¨āĻ¯ā§āĻā§āĻ¯ āĻāĻŦāĻ āĻāĻžāĻ°ā§āĻ¯āĻāĻ˛āĻžāĻĒā§ āĻĒāĻ°āĻŋāĻĒā§āĻ°ā§āĻŖāĨ¤ āĻ¸āĻŦāĻ āĻā§āĻā§āĻāĻ¨, āĻ¸āĻŦāĻžāĻ āĻŦā§āĻ¯āĻ¸ā§āĻ¤āĨ¤
2. āĻā§āĻ°āĻžāĻšāĻā§āĻ° āĻā§āĻŦāĻ¨āĻ āĻāĻžāĻ°āĻžāĻĒ āĻ¨āĻ¯āĻŧ - āĻ¤āĻŋāĻ¨āĻŋ āĻ¸āĻ°ā§āĻŦāĻĻāĻž āĻ¨āĻŋāĻļā§āĻāĻŋāĻ¤ āĻ¯ā§ āĻāĻĒāĻ¨āĻžāĻā§ āĻāĻāĻā§ āĻ§ā§āĻ°ā§āĻ¯ āĻ§āĻ°āĻ¤ā§ āĻšāĻŦā§ āĻāĻŦāĻ āĻ¸āĻŦāĻāĻŋāĻā§ āĻāĻžāĻ°ā§āĻ¯āĻāĻ° āĻšāĻŦā§āĨ¤ āĻāĻāĻŋ āĻāĻžāĻ˛ āĻšāĻā§āĻā§ āĻ¨āĻž, āĻāĻžāĻ˛, āĻāĻžāĻ˛ - āĻāĻ āĻĒā§āĻĨāĻŋāĻŦā§ āĻ
āĻ¨ā§āĻ¯āĻžāĻ¯āĻŧ, āĻĒāĻ°āĻŦāĻ°ā§āĻ¤ā§ āĻā§āĻŦāĻ¨ā§ - āĻāĻĒāĻ¨āĻŋ āĻāĻžāĻā§āĻ¯āĻŦāĻžāĻ¨ āĻšāĻŦā§āĻ¨āĨ¤
āĻā§āĻˇāĻ¤ āĻāĻŦāĻ āĻŦāĻžāĻ§āĻž:
1. āĻļā§āĻā§āĻ°āĻ āĻŦāĻž āĻĒāĻ°ā§, āĻāĻāĻāĻŋ āĻ
āĻ¨ā§āĻ°ā§āĻĒ āĻĒāĻ°āĻŋāĻˇā§āĻŦāĻžāĻ° āĻāĻāĻāĻŋ āĻ¸ā§āĻŽāĻžāĻ°ā§āĻ āĻĒā§āĻ°āĻĻāĻžāĻ¨āĻāĻžāĻ°ā§ āĻĨāĻžāĻāĻŦā§ āĻ¯ā§ āĻāĻāĻ āĻāĻŋāĻ¨āĻŋāĻ¸ āĻāĻ°āĻŦā§, āĻāĻŋāĻ¨ā§āĻ¤ā§ āĻāĻāĻā§ āĻ¸āĻ¸ā§āĻ¤āĻžāĨ¤ āĻāĻ° āĻ°ā§āĻāĻžāĻ˛ā§āĻ āĻāĻāĻ āĻšāĻ˛ā§ āĻā§āĻ¨ āĻŦā§āĻļāĻŋ āĻĻāĻŋāĻ¤ā§ āĻšāĻŦā§āĨ¤ āĻ¯āĻž āĻāĻŦāĻžāĻ° āĻĢāĻŋāĻĄāĻžāĻ°ā§āĻ° āĻ
āĻ¨ā§āĻ¤āĻ°ā§āĻ§āĻžāĻ¨ā§āĻ° āĻĻāĻŋāĻā§ āĻ¨āĻŋāĻ¯āĻŧā§ āĻ¯āĻžāĻŦā§āĨ¤
2. āĻāĻāĻž āĻŦāĻŋāĻ°āĻā§āĻ¤āĻŋāĻāĻ°. āĻā§āĻ¨ āĻ¸āĻžāĻŽāĻžāĻ¨ā§āĻ¯ āĻ
āĻ°ā§āĻĨāĻĒā§āĻ°ā§āĻŖ āĻāĻžāĻ°ā§āĻ¯āĻāĻ˛āĻžāĻĒ āĻā§āĻŽāĻ¨ āĻŦāĻŋāĻ°āĻā§āĻ¤āĻŋāĻāĻ°āĨ¤
3. āĻāĻā§āĻ° āĻ¸āĻāĻ¸ā§āĻāĻ°āĻŖā§āĻ° āĻŽāĻ¤ā§ - āĻā§āĻ¨ āĻāĻ¨ā§āĻ¨āĻ¯āĻŧāĻ¨ āĻ¨ā§āĻāĨ¤ āĻāĻŋāĻ¨ā§āĻ¤ā§ āĻāĻāĻāĻ¨ āĻāĻā§āĻāĻŋāĻ¨āĻŋāĻ¯āĻŧāĻžāĻ°ā§āĻ° āĻāĻ¨ā§āĻ¯, āĻŦāĻŋāĻ¯āĻŧā§āĻ āĻšāĻ˛ āĻĒā§āĻ°āĻĨāĻŽ āĻŦāĻŋāĻāĻ˛ā§āĻĒā§āĻ° āĻŦāĻŋāĻĒāĻ°ā§āĻ¤ā§, āĻāĻāĻžāĻ¨ā§ āĻāĻĒāĻ¨āĻžāĻā§ āĻā§āĻ°āĻŽāĻžāĻāĻ¤ āĻāĻāĻāĻŋ IDB āĻ¤ā§āĻ°āĻŋ āĻāĻ°āĻ¤ā§ āĻšāĻŦā§āĨ¤ āĻāĻŦāĻ āĻ¯ā§ āĻ¸āĻŽāĻ¯āĻŧ āĻ˛āĻžāĻā§. āĻ¯āĻž āĻāĻĒāĻ¨āĻžāĻ° āĻĒā§āĻ°āĻŋāĻ¯āĻŧāĻāĻ¨ā§āĻ° āĻāĻĒāĻāĻžāĻ°ā§ āĻŦā§āĻ¯āĻ¯āĻŧ āĻāĻ°āĻž āĻ¯ā§āĻ¤ā§ āĻĒāĻžāĻ°ā§āĨ¤ āĻāĻžāĻ°āĻŖ āĻāĻĒāĻ¨āĻŋ āĻ¨āĻŋāĻā§āĻ° āĻ¯āĻ¤ā§āĻ¨ āĻ¨āĻŋāĻ¤ā§ āĻĒāĻžāĻ°āĻŦā§āĻ¨ āĻ¨āĻž, āĻ¸āĻŦāĻžāĻ āĻāĻĒāĻ¨āĻžāĻ° āĻ¯āĻ¤ā§āĻ¨ āĻ¨ā§āĻ¯āĻŧāĨ¤
āĻŦāĻŋāĻāĻ˛ā§āĻĒ 3- āĻāĻāĻāĻŋ āĻ¸āĻžāĻāĻā§āĻ˛ āĻāĻĻā§āĻāĻžāĻŦāĻ¨ā§āĻ° āĻĒā§āĻ°āĻ¯āĻŧā§āĻāĻ¨ āĻ¨ā§āĻ, āĻāĻĒāĻ¨āĻžāĻā§ āĻāĻāĻŋ āĻāĻŋāĻ¨āĻ¤ā§ āĻšāĻŦā§ āĻāĻŦāĻ āĻāĻāĻŋ āĻāĻžāĻ˛āĻžāĻ¤ā§ āĻšāĻŦā§āĨ¤
āĻ
āĻ¨ā§āĻ¯āĻžāĻ¨ā§āĻ¯ āĻā§āĻŽā§āĻĒāĻžāĻ¨āĻŋāĻ° āĻĒā§āĻ°āĻā§āĻļāĻ˛ā§āĻ°āĻž āĻā§āĻ¨ā§āĻļā§āĻ¨ā§ āĻŦāĻŋāĻ¯āĻŧāĻžāĻ°ā§āĻ° āĻ¸āĻžāĻĨā§ āĻĒāĻŋā§āĻāĻž āĻāĻžāĻ¨ (āĻāĻš, 90 āĻāĻ° āĻĻāĻļāĻā§ āĻ¸ā§āĻ¨ā§āĻ āĻĒāĻŋāĻāĻžāĻ°ā§āĻ¸āĻŦāĻžāĻ°ā§āĻā§āĻ° āĻāĻžāĻ˛ āĻ¸āĻŽāĻ¯āĻŧ)āĨ¤ āĻāĻ¸ā§āĻ¨ āĻŽāĻ¨āĻŋāĻāĻ°āĻŋāĻ āĻ¸āĻŋāĻ¸ā§āĻā§āĻŽāĻā§āĻ˛āĻŋ āĻŦā§āĻ¯āĻŦāĻšāĻžāĻ° āĻāĻ°āĻŋ āĻ¯ā§āĻā§āĻ˛āĻŋ āĻ¤ā§āĻ°āĻŋ, āĻĄāĻŋāĻŦāĻžāĻ āĻāĻ°āĻž āĻāĻŦāĻ āĻāĻžāĻ āĻāĻ°ā§ āĻāĻŦāĻ āĻ¸āĻžāĻ§āĻžāĻ°āĻŖāĻ¤ āĻĻāĻ°āĻāĻžāĻ°ā§ (āĻāĻžāĻ˛, āĻ
āĻ¨ā§āĻ¤āĻ¤ āĻ¤āĻžāĻĻā§āĻ° āĻ¨āĻŋāĻ°ā§āĻŽāĻžāĻ¤āĻžāĻĻā§āĻ° āĻāĻ¨ā§āĻ¯)āĨ¤
āĻāĻŋāĻā§āĻāĻžāĻ°āĻŦā§āĻ°ā§āĻĄ āĻāĻŦāĻ āĻĄā§āĻ¨āĻžāĻāĻ¸, āĻā§āĻˇāĻ¤ āĻāĻŦāĻ āĻŦāĻžāĻŽā§āĻĒāĻ¸āĻāĻŋāĻā§āĻāĻžāĻ°āĻŦā§āĻ°ā§āĻĄ āĻāĻŦāĻ āĻĄā§āĻ¨āĻžāĻāĻ¸:
1. āĻāĻ¤āĻŋāĻŽāĻ§ā§āĻ¯ā§ āĻ¯āĻž āĻāĻĻā§āĻāĻžāĻŦāĻŋāĻ¤ āĻšāĻ¯āĻŧā§āĻā§ āĻ¤āĻž āĻāĻŦāĻŋāĻˇā§āĻāĻžāĻ° āĻāĻ°āĻ¤ā§ āĻ¸āĻŽāĻ¯āĻŧ āĻ¨āĻˇā§āĻ āĻāĻ°āĻžāĻ° āĻĻāĻ°āĻāĻžāĻ° āĻ¨ā§āĻāĨ¤ āĻ¨āĻŋāĻ¨ āĻāĻŦāĻ āĻŦā§āĻ¯āĻŦāĻšāĻžāĻ° āĻāĻ°ā§āĻ¨āĨ¤
2. āĻŽāĻ¨āĻŋāĻāĻ°āĻŋāĻ āĻ¸āĻŋāĻ¸ā§āĻā§āĻŽ āĻŦā§āĻāĻžāĻĻā§āĻ° āĻĻā§āĻŦāĻžāĻ°āĻž āĻ˛ā§āĻāĻž āĻšāĻ¯āĻŧ āĻ¨āĻž, āĻāĻŦāĻ āĻ
āĻŦāĻļā§āĻ¯āĻ āĻ¤āĻžāĻ°āĻž āĻĻāĻ°āĻāĻžāĻ°ā§āĨ¤
3. āĻāĻ°ā§āĻŽāĻ°āĻ¤ āĻĒāĻ°ā§āĻ¯āĻŦā§āĻā§āĻˇāĻŖ āĻ¸āĻŋāĻ¸ā§āĻā§āĻŽ āĻ¸āĻžāĻ§āĻžāĻ°āĻŖāĻ¤ āĻĻāĻ°āĻāĻžāĻ°ā§ āĻĢāĻŋāĻ˛ā§āĻāĻžāĻ° āĻāĻ°āĻž āĻ¤āĻĨā§āĻ¯ āĻĒā§āĻ°āĻĻāĻžāĻ¨ āĻāĻ°ā§āĨ¤
āĻā§āĻˇāĻ¤ āĻāĻŦāĻ āĻŦāĻžāĻ§āĻž:
1. āĻāĻ āĻā§āĻˇā§āĻ¤ā§āĻ°ā§ āĻĒā§āĻ°āĻā§āĻļāĻ˛ā§ āĻāĻāĻāĻ¨ āĻĒā§āĻ°āĻā§āĻļāĻ˛ā§ āĻ¨āĻ¯āĻŧ, āĻļā§āĻ§ā§āĻŽāĻžāĻ¤ā§āĻ° āĻ
āĻ¨ā§āĻ¯ āĻāĻžāĻ°ā§ āĻĒāĻŖā§āĻ¯ā§āĻ° āĻāĻāĻāĻ¨ āĻŦā§āĻ¯āĻŦāĻšāĻžāĻ°āĻāĻžāĻ°ā§ āĻŦāĻž āĻāĻāĻāĻ¨ āĻŦā§āĻ¯āĻŦāĻšāĻžāĻ°āĻāĻžāĻ°ā§āĨ¤
2. āĻā§āĻ°āĻžāĻšāĻāĻā§ āĻ
āĻŦāĻļā§āĻ¯āĻ āĻāĻŽāĻ¨ āĻāĻŋāĻā§ āĻā§āĻ¨āĻžāĻ° āĻĒā§āĻ°āĻ¯āĻŧā§āĻāĻ¨ā§āĻ¯āĻŧāĻ¤āĻž āĻ¸āĻŽā§āĻĒāĻ°ā§āĻā§ āĻ¨āĻŋāĻļā§āĻāĻŋāĻ¤ āĻšāĻ¤ā§ āĻšāĻŦā§ āĻ¯āĻž āĻ¸ā§ āĻ¸āĻžāĻ§āĻžāĻ°āĻŖāĻ¤ āĻŦā§āĻāĻ¤ā§ āĻāĻžāĻ¯āĻŧ āĻ¨āĻž āĻāĻŦāĻ āĻ¤āĻžāĻ° āĻāĻāĻŋāĻ¤ āĻ¨āĻ¯āĻŧ āĻāĻŦāĻ āĻ¸āĻžāĻ§āĻžāĻ°āĻŖāĻāĻžāĻŦā§ āĻŦāĻāĻ°ā§āĻ° āĻāĻ¨ā§āĻ¯ āĻŦāĻžāĻā§āĻ āĻ
āĻ¨ā§āĻŽā§āĻĻāĻŋāĻ¤ āĻšāĻ¯āĻŧā§āĻā§ āĻāĻŦāĻ āĻĒāĻ°āĻŋāĻŦāĻ°ā§āĻ¤āĻ¨ āĻšāĻŦā§ āĻ¨āĻžāĨ¤ āĻ¤āĻžāĻ°āĻĒāĻ°ā§ āĻāĻĒāĻ¨āĻžāĻā§ āĻāĻāĻāĻŋ āĻĒā§āĻĨāĻ āĻ¸āĻāĻ¸ā§āĻĨāĻžāĻ¨ āĻŦāĻ°āĻžāĻĻā§āĻĻ āĻāĻ°āĻ¤ā§ āĻšāĻŦā§, āĻāĻāĻŋ āĻāĻāĻāĻŋ āĻ¨āĻŋāĻ°ā§āĻĻāĻŋāĻˇā§āĻ āĻ¸āĻŋāĻ¸ā§āĻā§āĻŽā§āĻ° āĻāĻ¨ā§āĻ¯ āĻāĻ¨āĻĢāĻŋāĻāĻžāĻ° āĻāĻ°āĻ¤ā§ āĻšāĻŦā§āĨ¤ āĻ¸ā§āĻā§āĻ˛ā§. āĻĒā§āĻ°āĻĨāĻŽā§ āĻāĻĒāĻ¨āĻžāĻā§ āĻ
āĻ°ā§āĻĨāĻĒā§āĻ°āĻĻāĻžāĻ¨ āĻāĻ°āĻ¤ā§ āĻšāĻŦā§, āĻĒāĻ°āĻŋāĻļā§āĻ§ āĻāĻ°āĻ¤ā§ āĻšāĻŦā§ āĻāĻŦāĻ āĻāĻŦāĻžāĻ° āĻ
āĻ°ā§āĻĨ āĻĒā§āĻ°āĻĻāĻžāĻ¨ āĻāĻ°āĻ¤ā§ āĻšāĻŦā§āĨ¤ āĻāĻ° āĻā§āĻ°āĻžāĻšāĻ āĻā§āĻĒāĻŖāĨ¤ āĻāĻāĻžāĻ āĻāĻ āĻā§āĻŦāĻ¨ā§āĻ° āĻāĻĻāĻ°ā§āĻļāĨ¤
āĻāĻŋ āĻāĻ°āĻ¤ā§ āĻšāĻŦā§, Chernyshevsky? āĻāĻĒāĻ¨āĻžāĻ° āĻĒā§āĻ°āĻļā§āĻ¨ āĻā§āĻŦ āĻĒā§āĻ°āĻžāĻ¸āĻā§āĻāĻŋāĻ. (āĻ¸āĻā§āĻā§)
āĻāĻ āĻŦāĻŋāĻļā§āĻˇ āĻā§āĻˇā§āĻ¤ā§āĻ°ā§ āĻāĻŦāĻ āĻŦāĻ°ā§āĻ¤āĻŽāĻžāĻ¨ āĻĒāĻ°āĻŋāĻ¸ā§āĻĨāĻŋāĻ¤āĻŋāĻ¤ā§, āĻāĻĒāĻ¨āĻŋ āĻāĻāĻā§ āĻāĻŋāĻ¨ā§āĻ¨āĻāĻžāĻŦā§ āĻāĻ°āĻ¤ā§ āĻĒāĻžāĻ°ā§āĻ¨ - āĻāĻ¸ā§āĻ¨ āĻāĻŽāĻžāĻĻā§āĻ° āĻ¨āĻŋāĻāĻ¸ā§āĻŦ āĻŽāĻ¨āĻŋāĻāĻ°āĻŋāĻ āĻ¸āĻŋāĻ¸ā§āĻā§āĻŽ āĻ¤ā§āĻ°āĻŋ āĻāĻ°āĻŋāĨ¤
āĻ āĻŋāĻ āĻāĻā§, āĻāĻāĻāĻŋ āĻ¸āĻŋāĻ¸ā§āĻā§āĻŽ āĻ¨āĻ¯āĻŧ, āĻ
āĻŦāĻļā§āĻ¯āĻ, āĻļāĻŦā§āĻĻā§āĻ° āĻ¸āĻŽā§āĻĒā§āĻ°ā§āĻŖ āĻ
āĻ°ā§āĻĨā§, āĻāĻāĻŋ āĻā§āĻŦ āĻā§āĻ°ā§ āĻāĻŦāĻ āĻ
āĻāĻŋāĻŽāĻžāĻ¨ā§, āĻ¤āĻŦā§ āĻ
āĻ¨ā§āĻ¤āĻ¤ āĻā§āĻ¨āĻāĻāĻžāĻŦā§ āĻāĻāĻŋ āĻ¨āĻŋāĻā§āĻ° āĻāĻ¨ā§āĻ¯ āĻ¸āĻšāĻ āĻāĻ°ā§ āĻ¤ā§āĻ˛ā§āĻ¨ āĻāĻŦāĻ āĻāĻ°ā§āĻŽāĻā§āĻˇāĻŽāĻ¤āĻž āĻāĻāĻ¨āĻžāĻā§āĻ˛āĻŋ āĻ¸āĻŽāĻžāĻ§āĻžāĻ¨ āĻāĻ°āĻžāĻ° āĻāĻ¨ā§āĻ¯ āĻāĻ°āĻ āĻ¤āĻĨā§āĻ¯ āĻ¸āĻāĻā§āĻ°āĻš āĻāĻ°ā§āĻ¨āĨ¤ āĻ¨āĻŋāĻā§āĻā§ āĻāĻŽāĻ¨ āĻĒāĻ°āĻŋāĻ¸ā§āĻĨāĻŋāĻ¤āĻŋāĻ¤ā§ āĻā§āĻāĻā§ āĻ¨āĻž āĻĒāĻžāĻāĻ¯āĻŧāĻžāĻ° āĻāĻ¨ā§āĻ¯ - "āĻ¸ā§āĻāĻžāĻ¨ā§ āĻ¯āĻžāĻ¨, āĻāĻŽāĻŋ āĻā§āĻĨāĻžāĻ¯āĻŧ āĻāĻžāĻ¨āĻŋ āĻ¨āĻž, āĻāĻāĻŋ āĻā§āĻāĻā§ āĻĒāĻžāĻ, āĻāĻŽāĻŋ āĻā§ āĻāĻžāĻ¨āĻŋ āĻ¨āĻžāĨ¤"
āĻāĻ āĻŦāĻŋāĻāĻ˛ā§āĻĒā§āĻ° āĻ¸ā§āĻŦāĻŋāĻ§āĻž āĻāĻŦāĻ āĻ āĻ¸ā§āĻŦāĻŋāĻ§āĻž āĻāĻŋ:
āĻĒā§āĻļāĻžāĻĻāĻžāĻ°āĻ°āĻž:
1. āĻāĻāĻž āĻāĻāĻ°ā§āĻˇāĻŖā§āĻ¯āĻŧ. āĻ āĻŋāĻ āĻāĻā§, āĻ§ā§āĻ°ā§āĻŦāĻ "āĻ¸āĻā§āĻā§āĻāĻŋāĻ¤ āĻĄā§āĻāĻžāĻĢāĻžāĻāĻ˛, āĻā§āĻŦāĻŋāĻ˛āĻ¸ā§āĻĒā§āĻ¸ āĻĒāĻ°āĻŋāĻŦāĻ°ā§āĻ¤āĻ¨ āĻāĻ¤ā§āĻ¯āĻžāĻĻāĻŋ" āĻāĻ° āĻā§āĻ¯āĻŧā§ āĻ
āĻ¨ā§āĻ¤āĻ¤ āĻāĻ°āĻ āĻāĻāĻ°ā§āĻˇāĻŖā§āĻ¯āĻŧāĨ¤
2. āĻāĻā§āĻ˛āĻŋ āĻšāĻ˛ āĻ¨āĻ¤ā§āĻ¨ āĻĻāĻā§āĻˇāĻ¤āĻž āĻāĻŦāĻ āĻ¨āĻ¤ā§āĻ¨ āĻŦāĻŋāĻāĻžāĻļāĨ¤ āĻ¯āĻž āĻāĻŦāĻŋāĻˇā§āĻ¯āĻ¤ā§, āĻļā§āĻā§āĻ°āĻ āĻŦāĻž āĻĒāĻ°ā§, āĻāĻžāĻ˛ āĻĒā§āĻ°āĻžāĻĒā§āĻ¯ āĻāĻŋāĻā§āĻāĻžāĻ°āĻŦā§āĻ°ā§āĻĄ āĻāĻŦāĻ āĻĄā§āĻ¨āĻžāĻ āĻĻā§āĻŦā§āĨ¤
āĻāĻ¨āĻ¸:
1. āĻāĻžāĻ āĻāĻ°āĻ¤ā§ āĻšāĻŦā§āĨ¤ āĻ
āĻ¨ā§āĻ āĻāĻžāĻ āĻāĻ°.
2. āĻāĻĒāĻ¨āĻžāĻā§ āĻ¨āĻŋāĻ¯āĻŧāĻŽāĻŋāĻ¤āĻāĻžāĻŦā§ āĻ¸āĻŽāĻ¸ā§āĻ¤ āĻāĻžāĻ°ā§āĻ¯āĻāĻ˛āĻžāĻĒā§āĻ° āĻ
āĻ°ā§āĻĨ āĻāĻŦāĻ āĻĻā§āĻˇā§āĻāĻŋāĻāĻā§āĻāĻŋ āĻŦā§āĻ¯āĻžāĻā§āĻ¯āĻž āĻāĻ°āĻ¤ā§ āĻšāĻŦā§āĨ¤
3. āĻāĻŋāĻā§ āĻ¤ā§āĻ¯āĻžāĻ āĻāĻ°āĻ¤ā§ āĻšāĻŦā§, āĻāĻžāĻ°āĻŖ āĻāĻā§āĻāĻŋāĻ¨āĻŋāĻ¯āĻŧāĻžāĻ°ā§āĻ° āĻāĻžāĻā§ āĻāĻĒāĻ˛āĻŦā§āĻ§ āĻāĻāĻŽāĻžāĻ¤ā§āĻ° āĻ¸āĻŽā§āĻĒāĻĻ - āĻ¸āĻŽāĻ¯āĻŧ - āĻŽāĻšāĻžāĻŦāĻŋāĻļā§āĻŦ āĻĻā§āĻŦāĻžāĻ°āĻž āĻ¸ā§āĻŽāĻŋāĻ¤āĨ¤
4. āĻ¸āĻŦāĻā§āĻ¯āĻŧā§ āĻāĻžāĻ°āĻžāĻĒ āĻāĻŦāĻ āĻ¸āĻŦāĻā§āĻ¯āĻŧā§ āĻ
āĻĒā§āĻ°ā§āĻ¤āĻŋāĻāĻ° - āĻĢāĻ˛āĻ¸ā§āĻŦāĻ°ā§āĻĒ, "āĻāĻāĻāĻŋ āĻāĻāĻĻā§āĻ° āĻ¨āĻ¯āĻŧ, āĻāĻāĻāĻŋ āĻŦā§āĻ¯āĻžāĻ āĻ¨āĻ¯āĻŧ, āĻ¤āĻŦā§ āĻāĻāĻāĻŋ āĻ
āĻāĻžāĻ¨āĻž āĻā§āĻ āĻĒā§āĻ°āĻžāĻŖā§" āĻāĻ° āĻŽāĻ¤ā§ āĻāĻŦāĻ°ā§āĻāĻ¨āĻž āĻŦā§āĻ°āĻŋāĻ¯āĻŧā§ āĻāĻ¸āĻ¤ā§ āĻĒāĻžāĻ°ā§āĨ¤
āĻā§ āĻāĻŋāĻā§ āĻā§āĻāĻāĻŋ āĻ¨āĻž āĻļā§āĻ¯āĻžāĻŽā§āĻĒā§āĻ¨ āĻĒāĻžāĻ¨ āĻ¨āĻž.
āĻ¸ā§āĻ¤āĻ°āĻžāĻ, āĻŽāĻāĻž āĻļā§āĻ°ā§ āĻšāĻ¯āĻŧ.
āĻ¸āĻžāĻ§āĻžāĻ°āĻŖ āĻ§āĻžāĻ°āĻŖāĻž - āĻĒāĻ°āĻŋāĻāĻ˛ā§āĻĒāĻŋāĻ¤
(āĻāĻ°ā§āĻāĻŋāĻā§āĻ˛ āĻĨā§āĻā§ āĻ¨ā§āĻāĻ¯āĻŧāĻž āĻāĻŋāĻ¤ā§āĻ° ÂĢ
āĻŦā§āĻ¯āĻžāĻā§āĻ¯āĻž:
- āĻ˛āĻā§āĻˇā§āĻ¯ āĻĄāĻžāĻāĻžāĻŦā§āĻ¸ āĻ¸ā§āĻā§āĻ¯āĻžāĻ¨ā§āĻĄāĻžāĻ°ā§āĻĄ PostgreSQL āĻāĻā§āĻ¸āĻā§āĻ¨āĻļāĻ¨ "pg_stat_statements" āĻāĻ° āĻ¸āĻžāĻĨā§ āĻāĻ¨āĻ¸ā§āĻāĻ˛ āĻāĻ°āĻž āĻāĻā§āĨ¤
- āĻŽāĻ¨āĻŋāĻāĻ°āĻŋāĻ āĻĄāĻžāĻāĻžāĻŦā§āĻ¸ā§, āĻāĻŽāĻ°āĻž āĻĒā§āĻ°āĻžāĻĨāĻŽāĻŋāĻ āĻĒāĻ°ā§āĻ¯āĻžāĻ¯āĻŧā§ pg_stat_statements āĻāĻ¤āĻŋāĻšāĻžāĻ¸ āĻ¸āĻāĻ°āĻā§āĻˇāĻŖ āĻāĻ°āĻ¤ā§ āĻāĻŦāĻ āĻāĻŦāĻŋāĻˇā§āĻ¯āĻ¤ā§ āĻŽā§āĻā§āĻ°āĻŋāĻā§āĻ¸ āĻāĻŦāĻ āĻŽāĻ¨āĻŋāĻāĻ°āĻŋāĻ āĻāĻ¨āĻĢāĻŋāĻāĻžāĻ° āĻāĻ°āĻ¤ā§ āĻĒāĻ°āĻŋāĻˇā§āĻŦāĻž āĻā§āĻŦāĻŋāĻ˛ā§āĻ° āĻāĻāĻāĻŋ āĻ¸ā§āĻ āĻ¤ā§āĻ°āĻŋ āĻāĻ°āĻŋ
- āĻŽāĻ¨āĻŋāĻāĻ°āĻŋāĻ āĻšā§āĻ¸ā§āĻā§, āĻāĻŽāĻ°āĻž āĻŦā§āĻ¯āĻžāĻļ āĻ¸ā§āĻā§āĻ°āĻŋāĻĒā§āĻā§āĻ° āĻāĻāĻāĻŋ āĻ¸ā§āĻ āĻ¤ā§āĻ°āĻŋ āĻāĻ°āĻŋ, āĻ¯āĻžāĻ° āĻŽāĻ§ā§āĻ¯ā§ āĻāĻŋāĻāĻŋāĻ āĻ¸āĻŋāĻ¸ā§āĻā§āĻŽā§ āĻāĻāĻ¨āĻž āĻ¤ā§āĻ°āĻŋ āĻāĻ°āĻžāĻ° āĻāĻ¨ā§āĻ¯āĻ āĻ°āĻ¯āĻŧā§āĻā§āĨ¤
āĻ¸ā§āĻŦāĻž āĻā§āĻŦāĻŋāĻ˛
āĻļā§āĻ°ā§āĻ¤ā§, āĻāĻāĻāĻŋ āĻĒāĻ°āĻŋāĻāĻ˛ā§āĻĒāĻŋāĻ¤āĻāĻžāĻŦā§ āĻ¸āĻ°āĻ˛ā§āĻā§āĻ¤ ERD, āĻļā§āĻˇ āĻĒāĻ°ā§āĻ¯āĻ¨ā§āĻ¤ āĻā§ āĻšāĻ¯āĻŧā§āĻāĻŋāĻ˛:
āĻā§āĻŦāĻŋāĻ˛ā§āĻ° āĻ¸āĻāĻā§āĻˇāĻŋāĻĒā§āĻ¤ āĻŦāĻŋāĻŦāĻ°āĻŖāĻļā§āĻˇāĻŦāĻŋāĻ¨ā§āĻĻā§ - āĻšā§āĻ¸ā§āĻ, āĻāĻĻāĻžāĻšāĻ°āĻŖā§āĻ° āĻ¸āĻāĻ¯ā§āĻ āĻŦāĻŋāĻ¨ā§āĻĻā§
āĻĄāĻžāĻāĻžāĻŦā§āĻ - āĻĄāĻžāĻāĻžāĻŦā§āĻ¸ āĻŦāĻŋāĻāĻ˛ā§āĻĒ
pg_stat_history - āĻ˛āĻā§āĻˇā§āĻ¯ āĻĄāĻžāĻāĻžāĻŦā§āĻ¸ā§āĻ° pg_stat_statements āĻĻā§āĻļā§āĻ¯ā§āĻ° āĻ
āĻ¸ā§āĻĨāĻžāĻ¯āĻŧā§ āĻ¸ā§āĻ¨ā§āĻ¯āĻžāĻĒāĻļāĻ āĻ¸āĻāĻ°āĻā§āĻˇāĻŖā§āĻ° āĻāĻ¨ā§āĻ¯ āĻāĻāĻāĻŋ āĻāĻ¤āĻŋāĻšāĻžāĻ¸āĻŋāĻ āĻā§āĻŦāĻŋāĻ˛
metric_glossary - āĻāĻ°ā§āĻŽāĻā§āĻˇāĻŽāĻ¤āĻž āĻŽā§āĻā§āĻ°āĻŋāĻā§āĻ¸ā§āĻ° āĻ
āĻāĻŋāĻ§āĻžāĻ¨
metric_config - āĻ¸ā§āĻŦāĻ¤āĻ¨ā§āĻ¤ā§āĻ° āĻŽā§āĻā§āĻ°āĻŋāĻā§āĻ¸ā§āĻ° āĻāĻ¨āĻĢāĻŋāĻāĻžāĻ°ā§āĻļāĻ¨
āĻāĻ¨ā§āĻĻā§āĻŽāĻ¯āĻŧ - āĻ
āĻ¨ā§āĻ°ā§āĻ§ā§āĻ° āĻāĻ¨ā§āĻ¯ āĻāĻāĻāĻŋ āĻ¨āĻŋāĻ°ā§āĻĻāĻŋāĻˇā§āĻ āĻŽā§āĻā§āĻ°āĻŋāĻ āĻ¯āĻž āĻĒāĻ°ā§āĻ¯āĻŦā§āĻā§āĻˇāĻŖ āĻāĻ°āĻž āĻšāĻā§āĻā§
āĻŽā§āĻā§āĻ°āĻŋāĻ_āĻ¸āĻ¤āĻ°ā§āĻāĻ¤āĻžāĻ°_āĻāĻ¤āĻŋāĻšāĻžāĻ¸ - āĻāĻ°ā§āĻŽāĻā§āĻˇāĻŽāĻ¤āĻž āĻ¸āĻ¤āĻ°ā§āĻāĻ¤āĻžāĻ° āĻāĻ¤āĻŋāĻšāĻžāĻ¸
log_query - AWS āĻĨā§āĻā§ āĻĄāĻžāĻāĻ¨āĻ˛ā§āĻĄ āĻāĻ°āĻž PostgreSQL āĻ˛āĻ āĻĢāĻžāĻāĻ˛ āĻĨā§āĻā§ āĻĒāĻžāĻ°ā§āĻ¸āĻĄ āĻ°ā§āĻāĻ°ā§āĻĄ āĻ¸āĻāĻ°āĻā§āĻˇāĻŖā§āĻ° āĻāĻ¨ā§āĻ¯ āĻĒāĻ°āĻŋāĻˇā§āĻŦāĻž āĻā§āĻŦāĻŋāĻ˛
āĻŦā§āĻ¸āĻ˛āĻžāĻāĻ¨ - āĻŦā§āĻ¸ āĻšāĻŋāĻ¸āĻžāĻŦā§ āĻŦā§āĻ¯āĻŦāĻšā§āĻ¤ āĻ¸āĻŽāĻ¯āĻŧāĻāĻžāĻ˛ā§āĻ° āĻĒāĻ°āĻžāĻŽāĻŋāĻ¤āĻŋ
āĻā§āĻā§āĻĒāĻāĻŖā§āĻ - āĻĄāĻžāĻāĻžāĻŦā§āĻ¸ā§āĻ° āĻ¸ā§āĻĨāĻŋāĻ¤āĻŋ āĻĒāĻ°ā§āĻā§āĻˇāĻž āĻāĻ°āĻžāĻ° āĻāĻ¨ā§āĻ¯ āĻŽā§āĻā§āĻ°āĻŋāĻā§āĻ¸ā§āĻ° āĻāĻ¨āĻĢāĻŋāĻāĻžāĻ°ā§āĻļāĻ¨
āĻā§āĻāĻĒāĻ¯āĻŧā§āĻ¨ā§āĻ_āĻ¸āĻ¤āĻ°ā§āĻāĻ¤āĻž_āĻāĻ¤āĻŋāĻšāĻžāĻ¸ - āĻĄāĻžāĻāĻžāĻŦā§āĻ¸ āĻ¸ā§āĻā§āĻ¯āĻžāĻāĻžāĻ¸ āĻā§āĻ āĻŽā§āĻā§āĻ°āĻŋāĻā§āĻ¸ā§āĻ° āĻ¸āĻ¤āĻ°ā§āĻāĻ¤āĻž āĻāĻ¤āĻŋāĻšāĻžāĻ¸
pg_stat_db_queries - āĻ¸āĻā§āĻ°āĻŋāĻ¯āĻŧ āĻ
āĻ¨ā§āĻ°ā§āĻ§ā§āĻ° āĻĒāĻ°āĻŋāĻˇā§āĻŦāĻž āĻā§āĻŦāĻŋāĻ˛
āĻāĻžāĻ°ā§āĻ¯ āĻŦāĻŋāĻŦāĻ°āĻŖ â āĻāĻžāĻ°ā§āĻ¯āĻāĻ˛āĻžāĻĒ āĻ˛āĻ āĻ¸ā§āĻŦāĻž āĻā§āĻŦāĻŋāĻ˛
trap_oid - āĻĢāĻžāĻāĻĻ āĻāĻ¨āĻĢāĻŋāĻāĻžāĻ°ā§āĻļāĻ¨ āĻĒāĻ°āĻŋāĻˇā§āĻŦāĻž āĻā§āĻŦāĻŋāĻ˛
āĻĒāĻ°ā§āĻ¯āĻžāĻ¯āĻŧ 1 - āĻāĻ°ā§āĻŽāĻā§āĻˇāĻŽāĻ¤āĻž āĻĒāĻ°āĻŋāĻ¸āĻāĻā§āĻ¯āĻžāĻ¨ āĻ¸āĻāĻā§āĻ°āĻš āĻāĻ°ā§āĻ¨ āĻāĻŦāĻ āĻ°āĻŋāĻĒā§āĻ°ā§āĻ āĻĒāĻžāĻ¨
āĻĒāĻ°āĻŋāĻ¸āĻāĻā§āĻ¯āĻžāĻ¨āĻāĻ¤ āĻ¤āĻĨā§āĻ¯ āĻ¸āĻāĻ°āĻā§āĻˇāĻŖ āĻāĻ°āĻ¤ā§ āĻāĻāĻāĻŋ āĻā§āĻŦāĻŋāĻ˛ āĻŦā§āĻ¯āĻŦāĻšāĻžāĻ° āĻāĻ°āĻž āĻšāĻ¯āĻŧāĨ¤ pg_stat_history
pg_stat_history āĻā§āĻŦāĻŋāĻ˛ āĻāĻ āĻ¨
āĻā§āĻŦāĻŋāĻ˛ "public.pg_stat_history" āĻāĻ˛āĻžāĻŽ | āĻĒā§āĻ°āĻāĻžāĻ° | āĻ¸āĻāĻļā§āĻ§āĻ--------------------------------------------------------------- -------------------------------- āĻāĻāĻĄāĻŋ | āĻĒā§āĻ°ā§āĻŖāĻ¸āĻāĻā§āĻ¯āĻž | āĻ¨āĻžāĻ˛ āĻĄāĻŋāĻĢāĻ˛ā§āĻ āĻ¨ā§āĻā§āĻ¸āĻāĻāĻžāĻ˛ āĻ¨āĻ¯āĻŧ('pg_stat_history_id_seq'::regclass) snapshot_timestamp | āĻāĻžāĻāĻŽāĻā§āĻ¨ āĻāĻžāĻĄāĻŧāĻž āĻāĻžāĻāĻŽāĻ¸ā§āĻā§āĻ¯āĻžāĻŽā§āĻĒ | database_id | āĻĒā§āĻ°ā§āĻŖāĻ¸āĻāĻā§āĻ¯āĻž | dbid | oid | userid | oid | queryid | bigint | āĻĒā§āĻ°āĻļā§āĻ¨ | āĻĒāĻžāĻ ā§āĻ¯ | āĻāĻ˛ | bigint | āĻŽā§āĻ_āĻ¸āĻŽāĻ¯āĻŧ | āĻĻā§āĻŦāĻŋāĻā§āĻŖ āĻ¨āĻŋāĻ°ā§āĻā§āĻ˛āĻ¤āĻž | āĻŽāĻŋāĻ¨āĻŋāĻ_āĻ¸āĻŽāĻ¯āĻŧ | āĻĻā§āĻŦāĻŋāĻā§āĻŖ āĻ¨āĻŋāĻ°ā§āĻā§āĻ˛āĻ¤āĻž | āĻ¸āĻ°ā§āĻŦā§āĻā§āĻ_āĻ¸āĻŽāĻ¯āĻŧ | āĻĻā§āĻŦāĻŋāĻā§āĻŖ āĻ¨āĻŋāĻ°ā§āĻā§āĻ˛āĻ¤āĻž | āĻŽāĻžāĻ¨ā§_āĻ¸āĻŽāĻ¯āĻŧ | āĻĻā§āĻŦāĻŋāĻā§āĻŖ āĻ¨āĻŋāĻ°ā§āĻā§āĻ˛āĻ¤āĻž | stddev_time | āĻĻā§āĻŦāĻŋāĻā§āĻŖ āĻ¨āĻŋāĻ°ā§āĻā§āĻ˛āĻ¤āĻž | āĻ¸āĻžāĻ°āĻŋ | bigint | shared_blks_hit | bigint | shared_blks_read | bigint | shared_blks_dirtied | bigint | shared_blks_written | bigint | local_blks_hit | bigint | local_blks_read | bigint | local_blks_dirtied | bigint | local_blks_written | bigint | temp_blks_read | bigint | temp_blks_written | bigint | blk_read_time | āĻĻā§āĻŦāĻŋāĻā§āĻŖ āĻ¨āĻŋāĻ°ā§āĻā§āĻ˛āĻ¤āĻž | blk_write_time | āĻĻā§āĻŦāĻŋāĻā§āĻŖ āĻ¨āĻŋāĻ°ā§āĻā§āĻ˛āĻ¤āĻž | āĻŦā§āĻ¸āĻ˛āĻžāĻāĻ¨_āĻāĻāĻĄāĻŋ | āĻĒā§āĻ°ā§āĻŖāĻ¸āĻāĻā§āĻ¯āĻž | āĻ¸ā§āĻā§āĻā§āĻ˛āĻŋ: "pg_stat_history_pkey" āĻĒā§āĻ°āĻžāĻĨāĻŽāĻŋāĻ āĻā§, btree (id) "database_idx" btree (database_id) "queryid_idx" btree (queryid) "snapshot_timestamp_idx" btree (snapshot_timestamp) "āĻŦāĻŋāĻĻā§āĻļā§-āĻā§: IG_FDASEKEYS" (āĻāĻāĻāĻŋ-āĻāĻāĻĄāĻŋ) āĻāĻ¨āĻ¸ā§āĻā§āĻ°āĻžāĻā§āĻ āĻāĻāĻĄāĻŋ) āĻ°ā§āĻĢāĻžāĻ°ā§āĻ¨ā§āĻ¸ āĻĄāĻžāĻāĻžāĻŦā§āĻ¸ (āĻāĻāĻĄāĻŋ ) āĻĄāĻŋāĻ˛āĻŋāĻ āĻā§āĻ¯āĻžāĻ¸āĻā§āĻĄā§
āĻāĻĒāĻ¨āĻŋ āĻĻā§āĻāĻ¤ā§ āĻĒāĻžāĻā§āĻā§āĻ¨, āĻā§āĻŦāĻŋāĻ˛āĻāĻŋ āĻļā§āĻ§ā§āĻŽāĻžāĻ¤ā§āĻ° āĻāĻāĻāĻŋ āĻā§āĻ°āĻŽāĻŦāĻ°ā§āĻ§āĻŽāĻžāĻ¨ āĻāĻŋāĻ āĻĄā§āĻāĻž pg_stat_statements āĻ˛āĻā§āĻˇā§āĻ¯ āĻĄāĻžāĻāĻžāĻŦā§āĻ¸ā§.
āĻāĻ āĻā§āĻŦāĻŋāĻ˛ā§āĻ° āĻŦā§āĻ¯āĻŦāĻšāĻžāĻ° āĻā§āĻŦāĻ āĻ¸āĻšāĻāĨ¤
pg_stat_history āĻĒā§āĻ°āĻ¤āĻŋāĻāĻŋ āĻāĻ¨ā§āĻāĻžāĻ° āĻāĻ¨ā§āĻ¯ āĻā§āĻ¯ā§āĻ¯āĻŧāĻžāĻ°ā§ āĻāĻā§āĻ¸āĻŋāĻāĻŋāĻāĻļāĻ¨ā§āĻ° āĻ¸āĻā§āĻāĻŋāĻ¤ āĻĒāĻ°āĻŋāĻ¸āĻāĻā§āĻ¯āĻžāĻ¨ āĻāĻĒāĻ¸ā§āĻĨāĻžāĻĒāĻ¨ āĻāĻ°āĻŦā§āĨ¤ āĻĒā§āĻ°āĻ¤āĻŋāĻāĻŋ āĻāĻ¨ā§āĻāĻžāĻ° āĻļā§āĻ°ā§āĻ¤ā§, āĻā§āĻŦāĻŋāĻ˛ā§ āĻĒāĻ°āĻŋāĻ¸āĻāĻā§āĻ¯āĻžāĻ¨ āĻĒā§āĻ°āĻŖ āĻāĻ°āĻžāĻ° āĻĒāĻ°ā§ pg_stat_statements āĻ¸āĻā§āĻā§ āĻ°āĻŋāĻ¸ā§āĻ āĻāĻ°ā§āĻ¨ pg_stat_statements_reset().
āĻĻā§āĻ°āĻˇā§āĻāĻŦā§āĻ¯: 1 āĻ¸ā§āĻā§āĻ¨ā§āĻĄā§āĻ° āĻŦā§āĻļāĻŋ āĻ¸āĻŽāĻ¯āĻŧāĻāĻžāĻ˛ā§āĻ° āĻ
āĻ¨ā§āĻ°ā§āĻ§ā§āĻ° āĻāĻ¨ā§āĻ¯ āĻĒāĻ°āĻŋāĻ¸āĻāĻā§āĻ¯āĻžāĻ¨ āĻ¸āĻāĻā§āĻ°āĻš āĻāĻ°āĻž āĻšāĻ¯āĻŧāĨ¤
pg_stat_history āĻ¸āĻžāĻ°āĻŖāĻŋ āĻĒāĻĒā§āĻ˛ā§āĻ āĻāĻ°āĻž āĻšāĻā§āĻā§
--pg_stat_history.sql
CREATE OR REPLACE FUNCTION pg_stat_history( ) RETURNS boolean AS $$
DECLARE
endpoint_rec record ;
database_rec record ;
pg_stat_snapshot record ;
current_snapshot_timestamp timestamp without time zone;
BEGIN
current_snapshot_timestamp = date_trunc('minute',now());
FOR endpoint_rec IN SELECT * FROM endpoint
LOOP
FOR database_rec IN SELECT * FROM database WHERE endpoint_id = endpoint_rec.id
LOOP
RAISE NOTICE 'NEW SHAPSHOT IS CREATING';
--Connect to the target DB
EXECUTE 'SELECT dblink_connect(''LINK1'',''host='||endpoint_rec.host||' dbname='||database_rec.name||' user=USER password=PASSWORD '')';
RAISE NOTICE 'host % and dbname % ',endpoint_rec.host,database_rec.name;
RAISE NOTICE 'Creating snapshot of pg_stat_statements for database %',database_rec.name;
SELECT
*
INTO
pg_stat_snapshot
FROM dblink('LINK1',
'SELECT
dbid , SUM(calls),SUM(total_time),SUM(rows) ,SUM(shared_blks_hit) ,SUM(shared_blks_read) ,SUM(shared_blks_dirtied) ,SUM(shared_blks_written) ,
SUM(local_blks_hit) , SUM(local_blks_read) , SUM(local_blks_dirtied) , SUM(local_blks_written) , SUM(temp_blks_read) , SUM(temp_blks_written) , SUM(blk_read_time) , SUM(blk_write_time)
FROM pg_stat_statements WHERE dbid=(SELECT oid from pg_database where datname=current_database() )
GROUP BY dbid
'
)
AS t
( dbid oid , calls bigint ,
total_time double precision ,
rows bigint , shared_blks_hit bigint , shared_blks_read bigint ,shared_blks_dirtied bigint ,shared_blks_written bigint ,
local_blks_hit bigint ,local_blks_read bigint , local_blks_dirtied bigint ,local_blks_written bigint ,
temp_blks_read bigint ,temp_blks_written bigint ,
blk_read_time double precision , blk_write_time double precision
);
INSERT INTO pg_stat_history
(
snapshot_timestamp ,database_id ,
dbid , calls ,total_time ,
rows ,shared_blks_hit ,shared_blks_read ,shared_blks_dirtied ,shared_blks_written ,local_blks_hit ,
local_blks_read,local_blks_dirtied,local_blks_written,temp_blks_read,temp_blks_written,
blk_read_time, blk_write_time
)
VALUES
(
current_snapshot_timestamp ,
database_rec.id ,
pg_stat_snapshot.dbid ,pg_stat_snapshot.calls,
pg_stat_snapshot.total_time,
pg_stat_snapshot.rows ,pg_stat_snapshot.shared_blks_hit ,pg_stat_snapshot.shared_blks_read ,pg_stat_snapshot.shared_blks_dirtied ,pg_stat_snapshot.shared_blks_written ,
pg_stat_snapshot.local_blks_hit , pg_stat_snapshot.local_blks_read , pg_stat_snapshot.local_blks_dirtied , pg_stat_snapshot.local_blks_written ,
pg_stat_snapshot.temp_blks_read , pg_stat_snapshot.temp_blks_written , pg_stat_snapshot.blk_read_time , pg_stat_snapshot.blk_write_time
);
RAISE NOTICE 'Creating snapshot of pg_stat_statements for queries with min_time more than 1000ms';
FOR pg_stat_snapshot IN
--All queries with max_time greater than 1000 ms
SELECT
*
FROM dblink('LINK1',
'SELECT
dbid , userid ,queryid,query,calls,total_time,min_time ,max_time,mean_time, stddev_time ,rows ,shared_blks_hit ,
shared_blks_read ,shared_blks_dirtied ,shared_blks_written ,
local_blks_hit , local_blks_read , local_blks_dirtied ,
local_blks_written , temp_blks_read , temp_blks_written , blk_read_time ,
blk_write_time
FROM pg_stat_statements
WHERE dbid=(SELECT oid from pg_database where datname=current_database() AND min_time >= 1000 )
'
)
AS t
( dbid oid , userid oid , queryid bigint ,query text , calls bigint ,
total_time double precision ,min_time double precision ,max_time double precision , mean_time double precision , stddev_time double precision ,
rows bigint , shared_blks_hit bigint , shared_blks_read bigint ,shared_blks_dirtied bigint ,shared_blks_written bigint ,
local_blks_hit bigint ,local_blks_read bigint , local_blks_dirtied bigint ,local_blks_written bigint ,
temp_blks_read bigint ,temp_blks_written bigint ,
blk_read_time double precision , blk_write_time double precision
)
LOOP
INSERT INTO pg_stat_history
(
snapshot_timestamp ,database_id ,
dbid ,userid , queryid , query , calls ,total_time ,min_time ,max_time ,mean_time ,stddev_time ,
rows ,shared_blks_hit ,shared_blks_read ,shared_blks_dirtied ,shared_blks_written ,local_blks_hit ,
local_blks_read,local_blks_dirtied,local_blks_written,temp_blks_read,temp_blks_written,
blk_read_time, blk_write_time
)
VALUES
(
current_snapshot_timestamp ,
database_rec.id ,
pg_stat_snapshot.dbid ,pg_stat_snapshot.userid ,pg_stat_snapshot.queryid,pg_stat_snapshot.query,pg_stat_snapshot.calls,
pg_stat_snapshot.total_time,pg_stat_snapshot.min_time ,pg_stat_snapshot.max_time,pg_stat_snapshot.mean_time, pg_stat_snapshot.stddev_time ,
pg_stat_snapshot.rows ,pg_stat_snapshot.shared_blks_hit ,pg_stat_snapshot.shared_blks_read ,pg_stat_snapshot.shared_blks_dirtied ,pg_stat_snapshot.shared_blks_written ,
pg_stat_snapshot.local_blks_hit , pg_stat_snapshot.local_blks_read , pg_stat_snapshot.local_blks_dirtied , pg_stat_snapshot.local_blks_written ,
pg_stat_snapshot.temp_blks_read , pg_stat_snapshot.temp_blks_written , pg_stat_snapshot.blk_read_time , pg_stat_snapshot.blk_write_time
);
END LOOP;
PERFORM dblink_disconnect('LINK1');
END LOOP ;--FOR database_rec IN SELECT * FROM database WHERE endpoint_id = endpoint_rec.id
END LOOP;
RETURN TRUE;
END
$$ LANGUAGE plpgsql;
āĻĢāĻ˛ā§ āĻā§āĻŦāĻŋāĻ˛ā§ āĻ¨āĻŋāĻ°ā§āĻĻāĻŋāĻˇā§āĻ āĻ¸āĻŽāĻ¯āĻŧ āĻĒāĻ°ā§ pg_stat_history āĻāĻŽāĻžāĻĻā§āĻ° āĻā§āĻŦāĻŋāĻ˛ā§āĻ° āĻŦāĻŋāĻˇāĻ¯āĻŧāĻŦāĻ¸ā§āĻ¤ā§āĻ° āĻ¸ā§āĻ¨ā§āĻ¯āĻžāĻĒāĻļāĻā§āĻ° āĻāĻāĻāĻŋ āĻ¸ā§āĻ āĻĨāĻžāĻāĻŦā§ pg_stat_statements āĻ˛āĻā§āĻˇā§āĻ¯ āĻĄāĻžāĻāĻžāĻŦā§āĻ¸āĨ¤
āĻāĻ¸āĻ˛ā§ āĻ°āĻŋāĻĒā§āĻ°ā§āĻāĻŋāĻ
āĻ¸āĻšāĻ āĻĒā§āĻ°āĻļā§āĻ¨ āĻŦā§āĻ¯āĻŦāĻšāĻžāĻ° āĻāĻ°ā§, āĻāĻĒāĻ¨āĻŋ āĻŦā§āĻļ āĻĻāĻ°āĻāĻžāĻ°ā§ āĻāĻŦāĻ āĻāĻāĻ°ā§āĻˇāĻŖā§āĻ¯āĻŧ āĻĒā§āĻ°āĻ¤āĻŋāĻŦā§āĻĻāĻ¨ āĻĒā§āĻ¤ā§ āĻĒāĻžāĻ°ā§āĻ¨āĨ¤
āĻ¨āĻŋāĻ°ā§āĻĻāĻŋāĻˇā§āĻ āĻ¸āĻŽāĻ¯āĻŧā§āĻ° āĻāĻ¨ā§āĻ¯ āĻāĻāĻ¤ā§āĻ°āĻŋāĻ¤ āĻĄā§āĻāĻž
āĻ¤āĻĻāĻ¨ā§āĻ¤
SELECT
database_id ,
SUM(calls) AS calls ,SUM(total_time) AS total_time ,
SUM(rows) AS rows , SUM(shared_blks_hit) AS shared_blks_hit,
SUM(shared_blks_read) AS shared_blks_read ,
SUM(shared_blks_dirtied) AS shared_blks_dirtied,
SUM(shared_blks_written) AS shared_blks_written ,
SUM(local_blks_hit) AS local_blks_hit ,
SUM(local_blks_read) AS local_blks_read ,
SUM(local_blks_dirtied) AS local_blks_dirtied ,
SUM(local_blks_written) AS local_blks_written,
SUM(temp_blks_read) AS temp_blks_read,
SUM(temp_blks_written) temp_blks_written ,
SUM(blk_read_time) AS blk_read_time ,
SUM(blk_write_time) AS blk_write_time
FROM
pg_stat_history
WHERE
queryid IS NULL AND
database_id = DATABASE_ID AND
snapshot_timestamp BETWEEN BEGIN_TIMEPOINT AND END_TIMEPOINT
GROUP BY database_id ;
āĻĄāĻŋāĻŦāĻŋ āĻ¸āĻŽāĻ¯āĻŧ
to_char(āĻŦā§āĻ¯āĻŦāĻ§āĻžāĻ¨ '1 āĻŽāĻŋāĻ˛āĻŋāĻ¸ā§āĻā§āĻ¨ā§āĻĄ' * pg_total_stat_history_rec.total_time, 'HH24:MI:SS.MS')
I/O āĻ¸āĻŽāĻ¯āĻŧ
to_char(āĻŦā§āĻ¯āĻŦāĻ§āĻžāĻ¨ '1 āĻŽāĻŋāĻ˛āĻŋāĻ¸ā§āĻā§āĻ¨ā§āĻĄ' * ( pg_total_stat_history_rec.blk_read_time + pg_total_stat_history_rec.blk_write_time ), 'HH24:MI:SS.MS')
āĻŽā§āĻ_āĻ¸āĻŽāĻ¯āĻŧ āĻ āĻ¨ā§āĻ¸āĻžāĻ°ā§ TOP10 SQL
āĻ¤āĻĻāĻ¨ā§āĻ¤
SELECT
queryid ,
SUM(calls) AS calls ,
SUM(total_time) AS total_time
FROM
pg_stat_history
WHERE
queryid IS NOT NULL AND
database_id = DATABASE_ID AND
snapshot_timestamp BETWEEN BEGIN_TIMEPOINT AND END_TIMEPOINT
GROUP BY queryid
ORDER BY 3 DESC
LIMIT 10
-------------------------------------------------- -------------------------------------------------- | āĻŽā§āĻ āĻāĻā§āĻ¸āĻŋāĻāĻŋāĻāĻļāĻ¨ āĻ¸āĻŽāĻ¯āĻŧ āĻĻā§āĻŦāĻžāĻ°āĻž āĻ¸ā§āĻ°āĻž 10 SQL | #| queryid| āĻāĻ˛ | āĻāĻ˛ %| āĻŽā§āĻ_āĻ¸āĻŽāĻ¯āĻŧ (āĻāĻŽāĻāĻ¸) | dbtime % +------+------------+------------+----------+------ --------------------+------------ | 1| 821760255| 2| .00001|00:03:23.141( 203141.681 ms.)| 5.42 | 2| 4152624390| 2| .00001|00:03:13.929( 193929.215 ms.)| 5.17 | 3| 1484454471| 4| .00001|00:02:09.129( 129129.057 ms.)| 3.44 | 4| 655729273| 1| .00000|00:02:01.869( 121869.981 ms.)| 3.25 | 5| 2460318461| 1| .00000|00:01:33.113( 93113.835 ms.)| 2.48 | 6| 2194493487| 4| .00001|00:00:17.377( 17377.868 ms.)| .46 | 7| 1053044345| 1| .00000|00:00:06.156( 6156.352 ms.)| .16 | 8| 3644780286| 1| .00000|00:00:01.063( 1063.830 ms.)| .03
āĻŽā§āĻ I/O āĻ¸āĻŽāĻ¯āĻŧ āĻ āĻ¨ā§āĻ¸āĻžāĻ°ā§ TOP10 SQL
āĻ¤āĻĻāĻ¨ā§āĻ¤
SELECT
queryid ,
SUM(calls) AS calls ,
SUM(blk_read_time + blk_write_time) AS io_time
FROM
pg_stat_history
WHERE
queryid IS NOT NULL AND
database_id = DATABASE_ID AND
snapshot_timestamp BETWEEN BEGIN_TIMEPOINT AND END_TIMEPOINT
GROUP BY queryid
ORDER BY 3 DESC
LIMIT 10
-------------------------------------------------- --------------------------------------------------- | āĻŽā§āĻ I/O āĻ¸āĻŽāĻ¯āĻŧ āĻĻā§āĻŦāĻžāĻ°āĻž āĻ¸ā§āĻ°āĻž 10 SQL | #| queryid| āĻāĻ˛ | āĻāĻ˛ %| I/O āĻ¸āĻŽāĻ¯āĻŧ (ms)|db I/O āĻ¸āĻŽāĻ¯āĻŧ % +------+------------+----------+------ ----------------------------------------------------------- -- | 1| 4152624390| 2| .00001|00:08:31.616( 511616.592 ms.)| āĻā§āĻ¨ 31.06 | 2| 821760255| 2| .00001|00:08:27.099( 507099.036 ms.)| 30.78 | 3| 655729273| 1| .00000|00:05:02.209( 302209.137 ms.)| 18.35 | 4| 2460318461| 1| .00000|00:04:05.981( 245981.117 ms.)| 14.93 | 5| 1484454471| 4| .00001|00:00:39.144( 39144.221 ms.)| 2.38 | 6| 2194493487| 4| .00001|00:00:18.182( 18182.816 ms.)| 1.10 | 7| 1053044345| 1| .00000|00:00:16.611(16611.722 ms.)| 1.01 | 8| 3644780286| 1| .00000|00:00:00.436( 436.205 ms.)| .03
āĻ¸āĻ°ā§āĻŦā§āĻā§āĻ 10 āĻāĻ¸āĻāĻŋāĻāĻāĻ˛ āĻāĻžāĻ°ā§āĻ¯āĻāĻ° āĻāĻ°āĻžāĻ° āĻ¸āĻŽāĻ¯āĻŧ
āĻ¤āĻĻāĻ¨ā§āĻ¤
SELECT
id AS snapshotid ,
queryid ,
snapshot_timestamp ,
max_time
FROM
pg_stat_history
WHERE
queryid IS NOT NULL AND
database_id = DATABASE_ID AND
snapshot_timestamp BETWEEN BEGIN_TIMEPOINT AND END_TIMEPOINT
ORDER BY 4 DESC
LIMIT 10
-------------------------------------------------- -------------------------------------------------- | āĻ¸āĻ°ā§āĻŦā§āĻā§āĻ āĻāĻžāĻ°ā§āĻ¯āĻāĻ°ā§ āĻ¸āĻŽāĻ¯āĻŧ āĻĻā§āĻŦāĻžāĻ°āĻž āĻļā§āĻ°ā§āĻˇ 10 SQL | #| āĻ¸ā§āĻ¨ā§āĻ¯āĻžāĻĒāĻļāĻ| āĻ¸ā§āĻ¨ā§āĻ¯āĻžāĻĒāĻļāĻāĻāĻāĻĄāĻŋ| queryid| max_time (ms) +------+-------------------+------------+--------- -------------------------------------------- | 1| 05.04.2019/01/03 4169:655729273| 00| 02| 01.869:121869.981:2( 04.04.2019 ms.) | 17| 00/4153/821760255 00:01| 41.570| 101570.841| 3:04.04.2019:16( 00 ms.) | 4146| 821760255/00/01 41.570:101570.841| 4| 04.04.2019| 16:00:4144( 4152624390 ms.) | 00| 01/36.964/96964.607 5:04.04.2019| 17| 00| 4151:4152624390:00( 01 ms.) | 36.964| 96964.607/6/05.04.2019 10:00| 4188| 1484454471| 00:01:33.452( 93452.150 ms.) | 7| 04.04.2019/17/00 4150:2460318461 | 00| 01| 33.113:93113.835:8( 04.04.2019 ms.) | 15| 00/4140/1484454471 00:00| 11.892| 11892.302| 9:04.04.2019:16( 00 ms.) | 4145| 1484454471/00/00 11.892:11892.302| 10| 04.04.2019| 17:00:4152(1484454471 ms.) | 00| 00/11.892/11892.302 XNUMX:XNUMX| XNUMX| XNUMX| XNUMX:XNUMX:XNUMX(XNUMX ms.) | XNUMX| XNUMX/XNUMX/XNUMX XNUMX:XNUMX| XNUMX| XNUMX| XNUMX:XNUMX:XNUMX (XNUMX ms.)
SHARED āĻŦāĻžāĻĢāĻžāĻ° āĻĻā§āĻŦāĻžāĻ°āĻž TOP10 SQL āĻ°āĻŋāĻĄ/āĻ°āĻžāĻāĻ
āĻ¤āĻĻāĻ¨ā§āĻ¤
SELECT
id AS snapshotid ,
queryid ,
snapshot_timestamp ,
shared_blks_read ,
shared_blks_written
FROM
pg_stat_history
WHERE
queryid IS NOT NULL AND
database_id = DATABASE_ID AND
snapshot_timestamp BETWEEN BEGIN_TIMEPOINT AND END_TIMEPOINT AND
( shared_blks_read > 0 OR shared_blks_written > 0 )
ORDER BY 4 DESC , 5 DESC
LIMIT 10
-------------------------------------------------- -------------------------------------------------- | āĻļā§āĻ¯āĻŧāĻžāĻ° āĻāĻ°āĻž āĻŦāĻžāĻĢāĻžāĻ° āĻĻā§āĻŦāĻžāĻ°āĻž āĻļā§āĻ°ā§āĻˇ 10 SQL āĻ°āĻŋāĻĄ/āĻ°āĻžāĻāĻ | #| āĻ¸ā§āĻ¨ā§āĻ¯āĻžāĻĒāĻļāĻ| āĻ¸ā§āĻ¨ā§āĻ¯āĻžāĻĒāĻļāĻāĻāĻāĻĄāĻŋ| queryid| āĻāĻžāĻ āĻāĻ°āĻž āĻŦā§āĻ˛āĻ āĻĒāĻĄāĻŧāĻž | āĻļā§āĻ¯āĻŧāĻžāĻ°ā§āĻĄ āĻŦā§āĻ˛āĻ āĻ˛āĻŋāĻāĻ¤ā§ +------------------------------------- ------------------------- +---------------------- | 1| 04.04.2019/17/00 4153:821760255| 797308| 0| 2| 04.04.2019 | 16| 00/4146/821760255 797308:0| 3| 05.04.2019| 01| 03 | 4169| 655729273/797158/0 4:04.04.2019| 16| 00| 4144| 4152624390 | 756514| 0/5/04.04.2019 17:00| 4151| 4152624390| 756514| 0 | 6| 04.04.2019/17/00 4150:2460318461| 734117| 0| 7| 04.04.2019 | 17| 00/4155/3644780286 52973:0| 8| 05.04.2019| 01| 03 | 4168| 1053044345/52818/0 9:04.04.2019| 15| 00| 4141| 2194493487 | 52813| 0/10/04.04.2019 16:00| 4147| 2194493487| 52813| 0 | XNUMX| XNUMX/XNUMX/XNUMX XNUMX:XNUMX| XNUMX| XNUMX| XNUMX| XNUMX | XNUMX| XNUMX/XNUMX/XNUMX XNUMX:XNUMX| XNUMX| XNUMX| XNUMX| XNUMX -------------------------------------------------- --------------------------------------------------
āĻ¸āĻ°ā§āĻŦā§āĻā§āĻ āĻāĻžāĻ°ā§āĻ¯āĻāĻ° āĻāĻ°āĻžāĻ° āĻ¸āĻŽāĻ¯āĻŧ āĻĻā§āĻŦāĻžāĻ°āĻž āĻā§āĻ¯ā§āĻ¯āĻŧāĻžāĻ°ā§ āĻŦāĻŋāĻ¤āĻ°āĻŖā§āĻ° āĻšāĻŋāĻ¸ā§āĻā§āĻā§āĻ°āĻžāĻŽ
āĻ āĻ¨ā§āĻ°ā§āĻ§
SELECT
MIN(max_time) AS hist_min ,
MAX(max_time) AS hist_max ,
(( MAX(max_time) - MIN(min_time) ) / hist_columns ) as hist_width
FROM
pg_stat_history
WHERE
queryid IS NOT NULL AND
database_id = DATABASE_ID AND
snapshot_timestamp BETWEEN BEGIN_TIMEPOINT AND END_TIMEPOINT ;
SELECT
SUM(calls) AS calls
FROM
pg_stat_history
WHERE
queryid IS NOT NULL AND
database_id =DATABASE_ID AND
snapshot_timestamp BETWEEN BEGIN_TIMEPOINT AND END_TIMEPOINT AND
( max_time >= hist_current_min AND max_time < hist_current_max ) ;
|------------------------------------------------ ---------------------------------------- | MAX_TIME āĻšāĻŋāĻ¸ā§āĻā§āĻā§āĻ°āĻžāĻŽ | āĻŽā§āĻ āĻāĻ˛: 33851920 | āĻŽāĻŋāĻ¨āĻŋāĻ āĻ¸āĻŽāĻ¯āĻŧ : 00:00:01.063 | āĻ¸āĻ°ā§āĻŦā§āĻā§āĻ āĻ¸āĻŽāĻ¯āĻŧ : 00:02:01.869 ----------------------------------------------------- ----------------------------------------- | āĻ¨ā§āĻ¯ā§āĻ¨āĻ¤āĻŽ āĻ¸āĻŽāĻ¯āĻŧāĻāĻžāĻ˛| āĻ¸āĻ°ā§āĻŦā§āĻā§āĻ āĻ¸āĻŽāĻ¯āĻŧāĻāĻžāĻ˛| āĻāĻ˛ āĻāĻ°ā§ +---------------------------------- ---------------------+------------ | 00:00:01.063( 1063.830 ms.) | 00:00:13.144( 13144.445 ms.) | 9 | 00:00:13.144( 13144.445 ms.) | 00:00:25.225( 25225.060 ms.) | 0 | 00:00:25.225( 25225.060 ms.) | 00:00:37.305( 37305.675 ms.) | 0 | 00:00:37.305( 37305.675 ms.) | 00:00:49.386( 49386.290 ms.) | 0 | 00:00:49.386( 49386.290 ms.) | 00:01:01.466( 61466.906 ms.) | 0 | 00:01:01.466( 61466.906 ms.) | 00:01:13.547( 73547.521 ms.) | 0 | 00:01:13.547( 73547.521 ms.) | 00:01:25.628( 85628.136 ms.) | 0 | 00:01:25.628( 85628.136 ms.) | 00:01:37.708( 97708.751 ms.) | 4 | 00:01:37.708( 97708.751 ms.) | 00:01:49.789( 109789.366 ms.) | 2 | 00:01:49.789( 109789.366 ms.) | 00:02:01.869( 121869.981 ms.) | 0
āĻĒā§āĻ°āĻ¤āĻŋ āĻ¸ā§āĻā§āĻ¨ā§āĻĄā§ āĻā§āĻ¯ā§āĻ¯āĻŧāĻžāĻ°ā§ āĻĻā§āĻŦāĻžāĻ°āĻž TOP10 āĻ¸ā§āĻ¨ā§āĻ¯āĻžāĻĒāĻļāĻ
āĻ āĻ¨ā§āĻ°ā§āĻ§
--pg_qps.sql
--Calculate Query Per Second
CREATE OR REPLACE FUNCTION pg_qps( pg_stat_history_id integer ) RETURNS double precision AS $$
DECLARE
pg_stat_history_rec record ;
prev_pg_stat_history_id integer ;
prev_pg_stat_history_rec record;
total_seconds double precision ;
result double precision;
BEGIN
result = 0 ;
SELECT *
INTO pg_stat_history_rec
FROM
pg_stat_history
WHERE id = pg_stat_history_id ;
IF pg_stat_history_rec.snapshot_timestamp IS NULL
THEN
RAISE EXCEPTION 'ERROR - Not found pg_stat_history for id = %',pg_stat_history_id;
END IF ;
--RAISE NOTICE 'pg_stat_history_id = % , snapshot_timestamp = %', pg_stat_history_id ,
pg_stat_history_rec.snapshot_timestamp ;
SELECT
MAX(id)
INTO
prev_pg_stat_history_id
FROM
pg_stat_history
WHERE
database_id = pg_stat_history_rec.database_id AND
queryid IS NULL AND
id < pg_stat_history_rec.id ;
IF prev_pg_stat_history_id IS NULL
THEN
RAISE NOTICE 'Not found previous pg_stat_history shapshot for id = %',pg_stat_history_id;
RETURN NULL ;
END IF;
SELECT *
INTO prev_pg_stat_history_rec
FROM
pg_stat_history
WHERE id = prev_pg_stat_history_id ;
--RAISE NOTICE 'prev_pg_stat_history_id = % , prev_snapshot_timestamp = %', prev_pg_stat_history_id , prev_pg_stat_history_rec.snapshot_timestamp ;
total_seconds = extract(epoch from ( pg_stat_history_rec.snapshot_timestamp - prev_pg_stat_history_rec.snapshot_timestamp ));
--RAISE NOTICE 'total_seconds = % ', total_seconds ;
--RAISE NOTICE 'calls = % ', pg_stat_history_rec.calls ;
IF total_seconds > 0
THEN
result = pg_stat_history_rec.calls / total_seconds ;
ELSE
result = 0 ;
END IF;
RETURN result ;
END
$$ LANGUAGE plpgsql;
SELECT
id ,
snapshot_timestamp ,
calls ,
total_time ,
( select pg_qps( id )) AS QPS ,
blk_read_time ,
blk_write_time
FROM
pg_stat_history
WHERE
queryid IS NULL AND
database_id = DATABASE_ID AND
snapshot_timestamp BETWEEN BEGIN_TIMEPOINT AND END_TIMEPOINT AND
( select pg_qps( id )) IS NOT NULL
ORDER BY 5 DESC
LIMIT 10
|------------------------------------------------ ---------------------------------------- | QueryPerSeconds āĻ¸āĻāĻā§āĻ¯āĻž āĻĻā§āĻŦāĻžāĻ°āĻž āĻāĻĻā§āĻļāĻā§āĻ¤ āĻ¸ā§āĻ°āĻž 10 āĻ¸ā§āĻ¨ā§āĻ¯āĻžāĻĒāĻļāĻ --------------------------------------------------------- ------------------------------------------------------------------------- -------------------------------------------------------- | #| āĻ¸ā§āĻ¨ā§āĻ¯āĻžāĻĒāĻļāĻ| āĻ¸ā§āĻ¨ā§āĻ¯āĻžāĻĒāĻļāĻāĻāĻāĻĄāĻŋ| āĻāĻ˛ | āĻŽā§āĻ āĻĄāĻŋāĻŦāĻŋāĻāĻžāĻāĻŽ| QPS | I/O āĻ¸āĻŽāĻ¯āĻŧ | I/O āĻ¸āĻŽāĻ¯āĻŧ % +------+---------------------------------- ------------------------------------------- -------------------------------------- +------------ | 1| 04.04.2019/20/04 4161:5758631| 00| 06| 30.513:390513.926:1573.396( 00 ms.)| 00| 01.470:1470.110:376(2 ms.)| .04.04.2019 | 17| 00/4149/3529197 00:11| 48.830| 708830.618| 980.332:00:12( 47.834 ms.)| 767834.052| 108.324:3:04.04.2019( 16 ms.)| 00 | 4143| 3525360/00/10 13.492:613492.351| 979.267| 00| 08:41.396:521396.555( 84.988 ms.)| 4| 04.04.2019:21:03( 4163 ms.)| 2781536 | 00| 03/06.470/186470.979 785.745:00| 00| 00.249| 249.865:134:5( 04.04.2019 ms.)| 19| 03:4159:2890362( 00 ms.)| .03 | 16.784| 196784.755/776.979/00 00:01.441| 1441.386| 732| 6:04.04.2019:14( 00 ms.)| 4137| 2397326:00:04( 43.033 ms.)| .283033.854 | 665.924| 00/00/00.024 24.505:009 | 7| 04.04.2019| 15:00:4139( 2394416 ms.)| 00| 04:51.435:291435.010(665.116 ms.)| .00 | 00| 12.025/12025.895/4.126 8:04.04.2019| 13| 00| 4135:2373043:00( 04 ms.)| 26.791| 266791.988:659.179:00( 00 ms.)| 00.064 | 64.261| 024/9/05.04.2019 01:03| 4167| 4387191| 00:06:51.380( 411380.293 ms.)| 609.332| 00:05:18.847(318847.407 ms.)| .77.507 | 10| 04.04.2019/18/01 4157:1145596| 00| 01| 19.217:79217.372:313.004( 00 ms.)| 00| 01.319:1319.676:1.666( XNUMX ms.)| XNUMX | XNUMX| XNUMX/XNUMX/XNUMX XNUMX:XNUMX| XNUMX| XNUMX| XNUMX:XNUMX:XNUMX( XNUMX ms.)| XNUMX| XNUMX:XNUMX:XNUMX( XNUMX ms.)| XNUMX
QueryPerSeconds āĻāĻŦāĻ I/O āĻāĻžāĻāĻŽ āĻ¸āĻš āĻāĻ¨ā§āĻāĻžāĻ¯āĻŧ āĻāĻā§āĻ¸āĻŋāĻāĻŋāĻāĻļāĻ¨ āĻāĻ¤āĻŋāĻšāĻžāĻ¸
āĻ¤āĻĻāĻ¨ā§āĻ¤
SELECT
id ,
snapshot_timestamp ,
calls ,
total_time ,
( select pg_qps( id )) AS QPS ,
blk_read_time ,
blk_write_time
FROM
pg_stat_history
WHERE
queryid IS NULL AND
database_id = DATABASE_ID AND
snapshot_timestamp BETWEEN BEGIN_TIMEPOINT AND END_TIMEPOINT
ORDER BY 2
|----------------------------------------------------------------------------------------------- | HOURLY EXECUTION HISTORY WITH QueryPerSeconds and I/O Time ----------------------------------------------------------------------------------------------------------------------------------------------- | QUERY PER SECOND HISTORY | #| snapshot| snapshotID| calls| total dbtime| QPS| I/O time| I/O time % +-----+------------------+-----------+-----------+----------------------------------+-----------+----------------------------------+----------- | 1| 04.04.2019 11:00| 4131| 3747| 00:00:00.835( 835.374 ms.)| 1.041| 00:00:00.000( .000 ms.)| .000 | 2| 04.04.2019 12:00| 4133| 1002722| 00:01:52.419( 112419.376 ms.)| 278.534| 00:00:00.149( 149.105 ms.)| .133 | 3| 04.04.2019 13:00| 4135| 2373043| 00:04:26.791( 266791.988 ms.)| 659.179| 00:00:00.064( 64.261 ms.)| .024 | 4| 04.04.2019 14:00| 4137| 2397326| 00:04:43.033( 283033.854 ms.)| 665.924| 00:00:00.024( 24.505 ms.)| .009 | 5| 04.04.2019 15:00| 4139| 2394416| 00:04:51.435( 291435.010 ms.)| 665.116| 00:00:12.025( 12025.895 ms.)| 4.126 | 6| 04.04.2019 16:00| 4143| 3525360| 00:10:13.492( 613492.351 ms.)| 979.267| 00:08:41.396( 521396.555 ms.)| 84.988 | 7| 04.04.2019 17:00| 4149| 3529197| 00:11:48.830( 708830.618 ms.)| 980.332| 00:12:47.834( 767834.052 ms.)| 108.324 | 8| 04.04.2019 18:01| 4157| 1145596| 00:01:19.217( 79217.372 ms.)| 313.004| 00:00:01.319( 1319.676 ms.)| 1.666 | 9| 04.04.2019 19:03| 4159| 2890362| 00:03:16.784( 196784.755 ms.)| 776.979| 00:00:01.441( 1441.386 ms.)| .732 | 10| 04.04.2019 20:04| 4161| 5758631| 00:06:30.513( 390513.926 ms.)| 1573.396| 00:00:01.470( 1470.110 ms.)| .376 | 11| 04.04.2019 21:03| 4163| 2781536| 00:03:06.470( 186470.979 ms.)| 785.745| 00:00:00.249( 249.865 ms.)| .134 | 12| 04.04.2019 23:03| 4165| 1443155| 00:01:34.467( 94467.539 ms.)| 200.438| 00:00:00.015( 15.287 ms.)| .016 | 13| 05.04.2019 01:03| 4167| 4387191| 00:06:51.380( 411380.293 ms.)| 609.332| 00:05:18.847( 318847.407 ms.)| 77.507 | 14| 05.04.2019 02:03| 4171| 189852| 00:00:10.989( 10989.899 ms.)| 52.737| 00:00:00.539( 539.110 ms.)| 4.906 | 15| 05.04.2019 03:01| 4173| 3627| 00:00:00.103( 103.000 ms.)| 1.042| 00:00:00.004( 4.131 ms.)| 4.010 | 16| 05.04.2019 04:00| 4175| 3627| 00:00:00.085( 85.235 ms.)| 1.025| 00:00:00.003( 3.811 ms.)| 4.471 | 17| 05.04.2019 05:00| 4177| 3747| 00:00:00.849( 849.454 ms.)| 1.041| 00:00:00.006( 6.124 ms.)| .721 | 18| 05.04.2019 06:00| 4179| 3747| 00:00:00.849( 849.561 ms.)| 1.041| 00:00:00.000( .051 ms.)| .006 | 19| 05.04.2019 07:00| 4181| 3747| 00:00:00.839( 839.416 ms.)| 1.041| 00:00:00.000( .062 ms.)| .007 | 20| 05.04.2019 08:00| 4183| 3747| 00:00:00.846( 846.382 ms.)| 1.041| 00:00:00.000( .007 ms.)| .001 | 21| 05.04.2019 09:00| 4185| 3747| 00:00:00.855( 855.426 ms.)| 1.041| 00:00:00.000( .065 ms.)| .008 | 22| 05.04.2019 10:00| 4187| 3797| 00:01:40.150( 100150.165 ms.)| 1.055| 00:00:21.845( 21845.217 ms.)| 21.812
āĻ¸āĻŽāĻ¸ā§āĻ¤ SQL āĻāĻ° āĻĒāĻžāĻ ā§āĻ¯ āĻ¨āĻŋāĻ°ā§āĻŦāĻžāĻāĻ¨ āĻāĻ°ā§
āĻ¤āĻĻāĻ¨ā§āĻ¤
SELECT
queryid ,
query
FROM
pg_stat_history
WHERE
queryid IS NOT NULL AND
database_id = DATABASE_ID AND
snapshot_timestamp BETWEEN BEGIN_TIMEPOINT AND END_TIMEPOINT
GROUP BY queryid , query
āĻĢāĻ˛āĻžāĻĢāĻ˛
āĻāĻĒāĻ¨āĻŋ āĻĻā§āĻāĻ¤ā§ āĻĒāĻžāĻā§āĻā§āĻ¨, āĻŽā§āĻāĻžāĻŽā§āĻāĻŋ āĻ¸āĻšāĻ āĻāĻĒāĻžāĻ¯āĻŧā§, āĻāĻĒāĻ¨āĻŋ āĻāĻžāĻā§āĻ° āĻāĻžāĻĒ āĻāĻŦāĻ āĻĄāĻžāĻāĻžāĻŦā§āĻ¸ā§āĻ° āĻ āĻŦāĻ¸ā§āĻĨāĻž āĻ¸āĻŽā§āĻĒāĻ°ā§āĻā§ āĻ āĻ¨ā§āĻ āĻĻāĻ°āĻāĻžāĻ°ā§ āĻ¤āĻĨā§āĻ¯ āĻĒā§āĻ¤ā§ āĻĒāĻžāĻ°ā§āĻ¨āĨ¤
āĻŦāĻŋāĻāĻĻā§āĻ°āĻ:āĻāĻĒāĻ¨āĻŋ āĻ¯āĻĻāĻŋ āĻā§āĻ¯ā§āĻ¯āĻŧāĻžāĻ°ā§āĻ¤ā§ queryid āĻ āĻŋāĻ āĻāĻ°ā§āĻ¨, āĻ¤āĻžāĻšāĻ˛ā§ āĻāĻŽāĻ°āĻž āĻāĻāĻāĻŋ āĻĒā§āĻĨāĻ āĻ āĻ¨ā§āĻ°ā§āĻ§ā§āĻ° āĻāĻ¤āĻŋāĻšāĻžāĻ¸ āĻĒāĻžāĻŦ (āĻ¸ā§āĻĨāĻžāĻ¨ āĻŦāĻžāĻāĻāĻžāĻ¨ā§āĻ° āĻāĻ¨ā§āĻ¯, āĻāĻāĻāĻŋ āĻĒā§āĻĨāĻ āĻ āĻ¨ā§āĻ°ā§āĻ§ā§āĻ° āĻĒā§āĻ°āĻ¤āĻŋāĻŦā§āĻĻāĻ¨ āĻŦāĻžāĻĻ āĻĻā§āĻāĻ¯āĻŧāĻž āĻšāĻ¯āĻŧ)āĨ¤
āĻ¸ā§āĻ¤āĻ°āĻžāĻ, āĻā§āĻ¯āĻŧā§āĻ°āĻŋ āĻĒāĻžāĻ°āĻĢāĻ°āĻŽā§āĻ¯āĻžāĻ¨ā§āĻ¸ā§āĻ° āĻĒāĻ°āĻŋāĻ¸āĻāĻā§āĻ¯āĻžāĻ¨āĻāĻ¤ āĻĄā§āĻāĻž āĻĒāĻžāĻāĻ¯āĻŧāĻž āĻ¯āĻžāĻ¯āĻŧ āĻāĻŦāĻ āĻ¸āĻāĻā§āĻ°āĻš āĻāĻ°āĻž āĻšāĻ¯āĻŧāĨ¤
āĻĒā§āĻ°āĻĨāĻŽ āĻĒāĻ°ā§āĻ¯āĻžāĻ¯āĻŧā§ "āĻĒāĻ°āĻŋāĻ¸āĻāĻā§āĻ¯āĻžāĻ¨āĻāĻ¤ āĻ¤āĻĨā§āĻ¯ āĻ¸āĻāĻā§āĻ°āĻš" āĻ¸āĻŽā§āĻĒāĻ¨ā§āĻ¨ āĻšāĻ¯āĻŧā§āĻā§āĨ¤
āĻāĻĒāĻ¨āĻŋ āĻĻā§āĻŦāĻŋāĻ¤ā§āĻ¯āĻŧ āĻĒāĻ°ā§āĻ¯āĻžāĻ¯āĻŧā§ āĻ¯ā§āĻ¤ā§ āĻĒāĻžāĻ°ā§āĻ¨ - "āĻāĻ°ā§āĻŽāĻā§āĻˇāĻŽāĻ¤āĻž āĻŽā§āĻā§āĻ°āĻŋāĻā§āĻ¸ āĻāĻ¨āĻĢāĻŋāĻāĻžāĻ° āĻāĻ°āĻž"āĨ¤
āĻāĻŋāĻ¨ā§āĻ¤ā§ āĻāĻāĻž āĻ¸āĻŽā§āĻĒā§āĻ°ā§āĻŖ āĻāĻŋāĻ¨ā§āĻ¨ āĻāĻ˛ā§āĻĒāĨ¤
āĻāĻ˛āĻŦā§âĻ
āĻāĻ¤ā§āĻ¸: www.habr.com