Studio ODIN

PostgreSQL �ł� watch

�ȑO�ALinux �� watch �R�}���h�ɂ‚��������܂����� PostgreSQL �ɂ� 9.3 ���� \watch ���^�R�}���h���lj�����܂����B

  \watch [SEC]           execute query every SEC seconds

psql=# SELECT CURRENT_TIME;

       timetz
--------------------
 23:02:53.492804+09
(1 row)

psql=# \watch 1

Watch every 1s  Mon Oct 17 23:02:57 2016

      timetz
-------------------
 23:02:57.03674+09
(1 row)

Watch every 1s  Mon Oct 17 23:02:58 2016

       timetz
--------------------
 23:02:58.038192+09
(1 row)

���̂悤�� �O�Ɏ��s���� SQL �����Ԋu�Ŏ��s���Ă���܂��B

�I���� [Ctrl]+[c]�ł��B

�f�t�H���g�� watch �R�}���h�Ɠ����悤�� 2�b�Ԋu�̂悤�ł��B

psql=# SELECT CURRENT_TIME;

       timetz
--------------------
 23:01:20.790009+09
(1 row)

psql=# \watch

Watch every 2s  Mon Oct 17 23:01:25 2016

       timetz
--------------------
 23:01:25.005323+09
(1 row)

Watch every 2s  Mon Oct 17 23:01:27 2016

       timetz
--------------------
 23:01:27.007919+09
(1 row)

INSERT �� UPDATE ���J��Ԃ����s�ł��܂��B

psql=# INSERT INTO test_a VALUES ('a', 'b');

INSERT 0 1

psql=# \watch 1

Watch every 1s  Mon Oct 17 23:09:25 2016

INSERT 0 1

Watch every 1s  Mon Oct 17 23:09:26 2016

INSERT 0 1

psql=# UPDATE test_a SET field2 = 'c' WHERE field1 = 'a';

UPDATE 10

psql=# \watch 1

Watch every 1s  Mon Oct 17 23:10:05 2016

UPDATE 10

Watch every 1s  Mon Oct 17 23:10:06 2016

UPDATE 10

�f�[�^�̊Ď��� �����̌J��Ԃ��Ȃǂ� ���p�ł������ł��ˁB