|
Postgres затыкается на простых запросах и больше не обслуживает пользователей
#34691453
Ссылка:
Ссылка на сообщение:
Ссылка с названием темы:
|
|
|
|
Сегодня опять :(
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.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
datid | datname | procpid | usesysid | usename | current_query | query_start | backend_start | client_addr | client_port
-------+-----------+---------+----------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------+-------------------------------+-------------+-------------
10793 | postgres | 71497 | 16384 | root | select * from pg_stat_activity; | 2007 - 07 - 30 09 : 09 : 28 . 554893 + 08 | 2007 - 07 - 30 09 : 09 : 14 . 326757 + 08 | | - 1
16562 | database | 70783 | 16561 | database | select id,title from cars_models where id_brand= 7 order by title asc | 2007 - 07 - 30 09 : 09 : 23 . 10946 + 08 | 2007 - 07 - 30 09 : 07 : 44 . 779032 + 08 | | - 1
16562 | database | 70720 | 16561 | database | select id,title from cars_models where id_brand= 6 order by title asc | 2007 - 07 - 30 09 : 09 : 19 . 529939 + 08 | 2007 - 07 - 30 09 : 07 : 35 . 936703 + 08 | | - 1
16562 | database | 69751 | 16561 | database | select distinct id_model, model_title from board_cars where id_brand= 11 order by 2 asc | 2007 - 07 - 30 09 : 09 : 28 . 613301 + 08 | 2007 - 07 - 30 09 : 05 : 38 . 6378 + 08 | | - 1
16562 | database | 67023 | 16561 | database | select id, title from cars_bodies where exists ( select id_body from board_cars where cars_bodies.id=id_body) order by 2 ; | 2007 - 07 - 30 09 : 08 : 30 . 585364 + 08 | 2007 - 07 - 30 09 : 01 : 52 . 147763 + 08 | | - 1
16562 | database | 68323 | 16561 | database | select distinct id_model, model_title from board_cars where id_brand= 11 order by 2 asc | 2007 - 07 - 30 09 : 09 : 27 . 851871 + 08 | 2007 - 07 - 30 09 : 04 : 41 . 482836 + 08 | | - 1
16562 | database | 70379 | 16561 | database | select count(id) from cars_models where active='y' and id_brand= 13 | 2007 - 07 - 30 09 : 09 : 28 . 622586 + 08 | 2007 - 07 - 30 09 : 06 : 47 . 854659 + 08 | | - 1
16562 | database | 67694 | 16561 | database | select distinct id_model, model_title from board_cars where id_brand= 23 order by 2 asc | 2007 - 07 - 30 09 : 09 : 22 . 020963 + 08 | 2007 - 07 - 30 09 : 03 : 15 . 867698 + 08 | | - 1
16562 | database | 67945 | 16561 | database | select id, title from cars_bodies where exists ( select id_body from board_cars where cars_bodies.id=id_body) order by 2 ; | 2007 - 07 - 30 09 : 09 : 08 . 555391 + 08 | 2007 - 07 - 30 09 : 03 : 49 . 675045 + 08 | | - 1
16562 | database | 67490 | 16561 | database | select id, title from cars_bodies where exists ( select id_body from board_cars where cars_bodies.id=id_body) order by 2 ; | 2007 - 07 - 30 09 : 08 : 42 . 704733 + 08 | 2007 - 07 - 30 09 : 02 : 49 . 383571 + 08 | | - 1
16562 | database | 67243 | 16561 | database | select id, title from cars_bodies where exists ( select id_body from board_cars where cars_bodies.id=id_body) order by 2 ; | 2007 - 07 - 30 09 : 08 : 41 . 053169 + 08 | 2007 - 07 - 30 09 : 02 : 27 . 545679 + 08 | | - 1
16562 | database | 70785 | 16561 | database | select distinct id_model, model_title from board_cars where id_brand= 42 order by 2 asc | 2007 - 07 - 30 09 : 09 : 28 . 503582 + 08 | 2007 - 07 - 30 09 : 07 : 45 . 10076 + 08 | | - 1
16562 | database | 71481 | 16561 | database | select id,description,name,email,phones,to_char(add_date, 'DD'),to_char(add_date, 'MM'),to_char(add_date, 'YY'),type from board_parts order by add_date desc LIMIT 20 OFFSET 0 | 2007 - 07 - 30 09 : 09 : 20 . 508752 + 08 | 2007 - 07 - 30 09 : 09 : 13 . 195697 + 08 | | - 1
16562 | database | 71126 | 16561 | database | select count(id) from cars_models where active='y' and id_brand= 6 | 2007 - 07 - 30 09 : 09 : 22 . 103774 + 08 | 2007 - 07 - 30 09 : 08 : 39 . 044957 + 08 | | - 1
16562 | database | 67129 | 16561 | database | select count(id) from board_cars where sell='1' and id_brand= 23 and id_model= 187 | 2007 - 07 - 30 09 : 09 : 19 . 469907 + 08 | 2007 - 07 - 30 09 : 02 : 05 . 444332 + 08 | | - 1
16562 | database | 70812 | 16561 | database | select id,title from cars_models where id_brand= 6 order by title asc | 2007 - 07 - 30 09 : 09 : 26 . 711821 + 08 | 2007 - 07 - 30 09 : 07 : 51 . 87566 + 08 | | - 1
16562 | database | 67257 | 16561 | database | select count(id) from board_cars where sell='1' | 2007 - 07 - 30 09 : 09 : 27 . 557614 + 08 | 2007 - 07 - 30 09 : 02 : 28 . 972683 + 08 | | - 1
16562 | database | 70295 | 16561 | database | select id,title from cars_models where id_brand= 12 order by title asc | 2007 - 07 - 30 09 : 09 : 23 . 731943 + 08 | 2007 - 07 - 30 09 : 06 : 42 . 165051 + 08 | | - 1
16562 | database | 68873 | 16561 | database | select id,title from cars_models where id_brand= 30 order by title asc | 2007 - 07 - 30 09 : 09 : 27 . 930204 + 08 | 2007 - 07 - 30 09 : 05 : 21 . 85349 + 08 | | - 1
16562 | database | 71387 | 16561 | database | select count(id) from board_cars where sell='1' | 2007 - 07 - 30 09 : 09 : 04 . 217326 + 08 | 2007 - 07 - 30 09 : 09 : 03 . 674688 + 08 | | - 1
16562 | database | 68033 | 16561 | database | select id, title from cars_bodies where exists ( select id_body from board_cars where cars_bodies.id=id_body) order by 2 ; | 2007 - 07 - 30 09 : 09 : 16 . 973336 + 08 | 2007 - 07 - 30 09 : 04 : 00 . 903024 + 08 | | - 1
16562 | database | 68077 | 16561 | database | select id, title from cars_bodies where exists ( select id_body from board_cars where cars_bodies.id=id_body) order by 2 ; | 2007 - 07 - 30 09 : 08 : 32 . 909953 + 08 | 2007 - 07 - 30 09 : 04 : 04 . 710974 + 08 | | - 1
16562 | database | 68375 | 16561 | database | select year from board_cars_year order by 1 | 2007 - 07 - 30 09 : 09 : 27 . 687034 + 08 | 2007 - 07 - 30 09 : 04 : 52 . 06626 + 08 | | - 1
16562 | database | 70684 | 16561 | database | select id,title from cars_models where id_brand= 32 order by title asc | 2007 - 07 - 30 09 : 09 : 26 . 391181 + 08 | 2007 - 07 - 30 09 : 07 : 28 . 855325 + 08 | | - 1
16562 | database | 69048 | 16561 | database | select id,title from cars_models where id_brand= 26 order by title asc | 2007 - 07 - 30 09 : 09 : 28 . 135588 + 08 | 2007 - 07 - 30 09 : 05 : 26 . 333964 + 08 | | - 1
16562 | database | 70833 | 16561 | database | select id,title from cars_models where id_brand= 6 order by title asc | 2007 - 07 - 30 09 : 09 : 21 . 640123 + 08 | 2007 - 07 - 30 09 : 07 : 54 . 104982 + 08 | | - 1
16562 | database | 71457 | 16561 | database | select count(id) from cars_models where active='1' and id_brand= 26 | 2007 - 07 - 30 09 : 09 : 09 . 040081 + 08 | 2007 - 07 - 30 09 : 09 : 08 . 603107 + 08 | | - 1
16562 | database | 67611 | 16561 | database | select distinct id_model, model_title from board_cars where id_brand= 39 order by 2 asc | 2007 - 07 - 30 09 : 09 : 27 . 150196 + 08 | 2007 - 07 - 30 09 : 03 : 02 . 262152 + 08 | | - 1
16562 | database | 70041 | 16561 | database | select id,title from cars_models where id_brand= 39 order by title asc | 2007 - 07 - 30 09 : 09 : 28 . 165206 + 08 | 2007 - 07 - 30 09 : 06 : 02 . 604398 + 08 | | - 1
16562 | database | 68335 | 16561 | database | select id, title from cars_bodies where exists ( select id_body from board_cars where cars_bodies.id=id_body) order by 2 ; | 2007 - 07 - 30 09 : 09 : 17 . 559839 + 08 | 2007 - 07 - 30 09 : 04 : 43 . 213554 + 08 | | - 1
16562 | database | 66766 | 16561 | database | select distinct id_model, model_title from board_cars where id_brand= 23 order by 2 asc | 2007 - 07 - 30 09 : 08 : 54 . 174932 + 08 | 2007 - 07 - 30 09 : 01 : 11 . 258945 + 08 | | - 1
16562 | database | 68401 | 16561 | database | select year from board_cars_year order by 1 | 2007 - 07 - 30 09 : 09 : 25 . 863289 + 08 | 2007 - 07 - 30 09 : 04 : 56 . 657046 + 08 | | - 1
16562 | database | 70659 | 16561 | database | select id,title from cars_models where id_brand= 15 order by title asc | 2007 - 07 - 30 09 : 09 : 26 . 174194 + 08 | 2007 - 07 - 30 09 : 07 : 25 . 341217 + 08 | | - 1
16562 | database | 67637 | 16561 | database | select id, title from cars_bodies where exists ( select id_body from board_cars where cars_bodies.id=id_body) order by 2 ; | 2007 - 07 - 30 09 : 09 : 16 . 973016 + 08 | 2007 - 07 - 30 09 : 03 : 08 . 06336 + 08 | | - 1
16562 | database | 68552 | 16561 | database | select id,title from cars_models where id_brand= 23 order by title asc | 2007 - 07 - 30 09 : 09 : 18 . 163459 + 08 | 2007 - 07 - 30 09 : 05 : 07 . 509757 + 08 | | - 1
16562 | database | 67787 | 16561 | database | select distinct id_model, model_title from board_cars where id_brand= 18 order by 2 asc | 2007 - 07 - 30 09 : 09 : 25 . 171361 + 08 | 2007 - 07 - 30 09 : 03 : 27 . 125859 + 08 | | - 1
16562 | database | 69415 | 16561 | database | select id,title from cars_models where id_brand= 23 order by title asc | 2007 - 07 - 30 09 : 09 : 21 . 743914 + 08 | 2007 - 07 - 30 09 : 05 : 33 . 80364 + 08 | | - 1
16562 | database | 70070 | 16561 | database | select count(id) from cars_models where active='y' and id_brand= 22 | 2007 - 07 - 30 09 : 09 : 28 . 384534 + 08 | 2007 - 07 - 30 09 : 06 : 08 . 802248 + 08 | | - 1
16562 | database | 71153 | 16561 | database | select count(id) from cars_models where active='1' and id_brand= 28 | 2007 - 07 - 30 09 : 09 : 28 . 197292 + 08 | 2007 - 07 - 30 09 : 08 : 43 . 098676 + 08 | | - 1
16562 | database | 71371 | 16561 | database | select count(id) from board_cars where sell='1' and top='1' and add_date > now() - interval '7 day' | 2007 - 07 - 30 09 : 09 : 03 . 184541 + 08 | 2007 - 07 - 30 09 : 09 : 02 . 774856 + 08 | | - 1
16562 | database | 68341 | 16561 | database | select id, title from cars_wheels where exists ( select idw from cars_models_wheels where idw = cars_wheels.id and exists ( select id from cars_models where cars_models.id = idm and id_brand = 14 ) ) | 2007 - 07 - 30 09 : 09 : 23 . 573539 + 08 | 2007 - 07 - 30 09 : 04 : 46 . 024986 + 08 | | - 1
16562 | database | 70002 | 16561 | database | select id,title from cars_models where id_brand= 23 order by title asc | 2007 - 07 - 30 09 : 09 : 00 . 634458 + 08 | 2007 - 07 - 30 09 : 05 : 57 . 376287 + 08 | | - 1
16562 | database | 70087 | 16561 | database | select id,title from cars_models where id_brand= 53 order by title asc | 2007 - 07 - 30 09 : 09 : 28 . 499811 + 08 | 2007 - 07 - 30 09 : 06 : 09 . 842263 + 08 | | - 1
16562 | database | 66926 | 16561 | database | select count(id) from board_cars where sell='1' | 2007 - 07 - 30 09 : 08 : 34 . 994509 + 08 | 2007 - 07 - 30 09 : 01 : 41 . 419419 + 08 | | - 1
16562 | database | 71223 | 16561 | database | select board_cars.id, cars_brands.title, model_title, year, price, id_currency from board_cars, cars_brands where cars_brands.id = id_brand and sell='1' and top='1' and add_date > now() - interval '7 day' order by random() LIMIT 5 | 2007 - 07 - 30 09 : 09 : 20 . 122611 + 08 | 2007 - 07 - 30 09 : 08 : 53 . 022618 + 08 | | - 1
16562 | database | 71234 | 16561 | database | select count(id) from board_cars where sell='1' and top='1' and add_date > now() - interval '7 day' | 2007 - 07 - 30 09 : 08 : 53 . 578171 + 08 | 2007 - 07 - 30 09 : 08 : 53 . 529702 + 08 | | - 1
16562 | database | 71045 | 16561 | database | select count(id) from cars_models where active='y' and id_brand= 35 | 2007 - 07 - 30 09 : 09 : 26 . 202511 + 08 | 2007 - 07 - 30 09 : 08 : 28 . 203696 + 08 | | - 1
17431 | info | 43379 | 17430 | info | <IDLE> in transaction | 2007 - 07 - 28 12 : 16 : 42 . 703791 + 08 | 2007 - 07 - 27 10 : 22 : 22 . 372861 + 08 | 127 . 0 . 0 . 1 | 4836
( 48 rows)
|
|
|
