teste_carga/test.sql at master · sharkguto/teste_carga · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
create schema test;


CREATE TABLE test.COMPANY(
   ID INT PRIMARY KEY     NOT NULL,
   NAME           TEXT    NOT NULL,
   AGE            INT     NOT NULL,
   ADDRESS        CHAR(50),
   SALARY         REAL
);


select * from test.company;

insert into test.company values(10,'b',2,'n',2.1);
insert into test.company values(9,'b',2,'n',2.1);
insert into test.company values(8,'b',2,'n',2.1);
insert into test.company values(7,'b',2,'n',2.1);
insert into test.company values(6,'b',2,'n',2.1);
insert into test.company values(5,'b',2,'n',2.1);
insert into test.company values(4,'b',2,'n',2.1);
insert into test.company values(3,'b',2,'n',2.1);
insert into test.company values(2,'b',2,'n',2.1);
insert into test.company values(1,'b',2,'n',2.1);


select count(*) from pg_catalog.pg_stat_activity;

select * from pg_catalog.pg_stat_activity;