Performance Profiling

Total processing time: 303 ms; Peak memory: 4.164 MB. Show Profiling Timeline

总计7条数据

Time	Duration	Category	Info

15:27:31.165	140.7 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT FROM "a57be577deb434"."tbl_user_action_logs" WHERE ("object_id" IN (SELECT "c"."id" FROM "a57be577deb434"."tbl_clients" "c" LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_client_classes" "cl" ON cl.id = c.client_class LEFT JOIN "a57be577deb434"."tbl_client_address_rels" "car" ON car.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_addresses" "a" ON car.address_id = a.id LEFT JOIN (SELECT "client_id" FROM "a57be577deb434"."tbl_projects" WHERE "project_status"=3 GROUP BY "client_id") "p" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.client_id = c.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN (SELECT extract(epoch from (now() - max(end_at))) / 86400 AS lost_contact_days, max(end_at) as last_contact, client_id FROM "a57be577deb434"."tbl_work_logs" WHERE "is_draft"=FALSE GROUP BY "client_id") "sl" ON sl.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = c.id AND ttr.term_id = 14 LEFT JOIN (SELECT "client_id" FROM "a57be577deb434"."tbl_contacts" WHERE lower(name) LIKE '%%' GROUP BY "client_id") "cc" ON cc.client_id = c.id WHERE (("c"."sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("c"."sales_rep" IS NULL) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))) AND ("deleted"=FALSE) GROUP BY "c"."id" ORDER BY "c"."id")) AND ("object_type"='10') ORDER BY "created_at" DESC) "c"
15:27:31.306	140.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_user_action_logs" WHERE ("object_id" IN (SELECT "c"."id" FROM "a57be577deb434"."tbl_clients" "c" LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_client_classes" "cl" ON cl.id = c.client_class LEFT JOIN "a57be577deb434"."tbl_client_address_rels" "car" ON car.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_addresses" "a" ON car.address_id = a.id LEFT JOIN (SELECT "client_id" FROM "a57be577deb434"."tbl_projects" WHERE "project_status"=3 GROUP BY "client_id") "p" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.client_id = c.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN (SELECT extract(epoch from (now() - max(end_at))) / 86400 AS lost_contact_days, max(end_at) as last_contact, client_id FROM "a57be577deb434"."tbl_work_logs" WHERE "is_draft"=FALSE GROUP BY "client_id") "sl" ON sl.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = c.id AND ttr.term_id = 14 LEFT JOIN (SELECT "client_id" FROM "a57be577deb434"."tbl_contacts" WHERE lower(name) LIKE '%%' GROUP BY "client_id") "cc" ON cc.client_id = c.id WHERE (("c"."sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("c"."sales_rep" IS NULL) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))) AND ("deleted"=FALSE) GROUP BY "c"."id" ORDER BY "c"."id")) AND ("object_type"='10') ORDER BY "created_at" DESC LIMIT 20
15:27:31.452	2.9 ms	yii\db\Command::query	INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/action-log/list', '{"is_all":"0","other_period":"currentfascalyear","Filter":{"name":"created_at","sort":"DESC"},"ClientSearch":{"group":"1","client_class":"","has_contact":"","cooperated":"","client_type":"","company_nature":"","client_industry":"","from_contact_name":"","from_contact":"","state_id":"","created_period":"","created_by":""},"page":"1","object_type":"10","attribute":"","web_access_token":"eLSqRe8hqEgPBX_zWO9QINJWKjv2Vvg4"}', '{"code":2000,"result":{"list":[{"id":171855,"object_id":3461,"object_type":10,"target_id":"","target_object_type":"","act":1,"attribute":"create","old_value":{"cooperated":"","last_contact":"","lost_contact_days":"","keyword":"","from":"","to":"","period":"","unread":0},"new_value":{"cooperated":"","last_contact":"","lost_contact_days":"","keyword":"","from":"","to":"","period":"","unread":0},"users":"{1001}","description":{"d1":"\u5218\u4eba\u8bda","d2":"\u7ed9\u81ea\u5df1\u521b\u5efa\u4e86","d3":"\u5ba2\u6237","d4":[]},"created_by":1001,"created_at":"2026-06-02 15:26:34","is_delete":false,"parent_id":"","client":{"id":3461,"key":3461,"name":"2","logo":"","client_type":1,"client_class":1,"client_industry":57},"need_hidden":true,"created_at_display":"57\u79d2\u524d"},{"id":171854,"object_id":3460,"object_type":10,"target_id":"","target_object_type":"","act":1,"attribute":"create","old_value":{"cooperated":"","last_contact":"","lost_contact_days":"","keyword":"","from":"","to":"","period":"","unread":0},"new_value":{"cooperated":"","last_contact":"","lost_contact_days":"","keyword":"","from":"","to":"","period":"","unread":0},"users":"{1005,1001}","description":{"d1":"\u5218\u4eba\u8bda","d2":"\u7ed9\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09\u521b\u5efa\u4e86","d3":"\u5ba2\u6237","d4":[]},"created_by":1001,"created_at":"2026-06-02 15:25:18","is_delete":false,"parent_id":"","client":{"id":3460,"key":3460,"name":"23","logo":"","client_type":1,"client_class":1,"client_industry":57},"need_hidden":true,"created_at_display":"2\u5206\u949f\u524d"},{"id":171853,"object_id":3459,"object_type":10,"target_id":"","target_object_type":"","act":1,"attribute":"create","old_value":{"cooperated":"","last_contact":"","lost_contact_days":"","keyword":"","from":"","to":"","period":"","unread":0},"new_value":{"cooperated":"","last_contact":"","lost_contact_days":"","keyword":"","from":"","to":"","period":"","unread":0},"users":"{1001}","description":{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u5ba2\u6237 \u5230\u516c\u6d77","d4":[]},"created_by":1001,"created_at":"2026-06-02 15:23:56","is_delete":false,"parent_id":"","client":{"id":3459,"key":3459,"name":"\u6d4b\u8bd5","logo":"","client_type":1,"client_class":80,"client_industry":57},"need_hidden":true,"created_at_display":"3\u5206\u949f\u524d"},{"id":171779,"object_id":1933,"object_type":10,"target_id":18359,"target_object_type":9,"act":1,"attribute":"create","old_value":18359,"new_value":18359,"users":"{1001}","description":{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]},"created_by":1001,"created_at":"2026-05-18 14:33:53","is_delete":false,"parent_id":"","client":{"id":1933,"key":1933,"name":"SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8(\u91cd\u590d\u5ba2\u6237)","logo":"","client_type":5,"client_class":43,"client_industry":5},"need_hidden":false,"created_at_display":"05\u670818\u65e5 14:33"},{"id":171776,"object_id":399,"object_type":10,"target_id":39166,"target_object_type":19,"act":1,"attribute":"create","old_value":39166,"new_value":39166,"users":"{1005,5064}","description":{"d1":"\u59da\u96ea\u7eaf","d2":"\u521b\u5efa\u4e86","d3":"\u5de5\u4f5c\u65e5\u5fd7","d4":["\u62dc\u8bbf\u5ba2\u6237"]},"created_by":5064,"created_at":"2026-05-18 13:48:04","is_delete":false,"parent_id":"","client":{"id":399,"key":399,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240\u4e2d\u76fe(\u8fc7\u5355\u516c\u53f8)","logo":"\/files\/cdn\/a57be577deb434\/logo\/6fc2ad20-226c-311c-9f64-96f95d6c6bdd.png","client_type":1,"client_class":43,"client_industry":1},"need_hidden":false,"created_at_display":"05\u670818\u65e5 13:48"},{"id":171772,"object_id":2596,"object_type":10,"target_id":5285,"target_object_type":14,"act":3,"attribute":"delete","old_value":5285,"new_value":5285,"users":"{1005,1001}","description":{"d1":"\u5218\u4eba\u8bda","d2":"\u5220\u9664\u4e86","d3":"\u8054\u7cfb\u4eba","d4":["\u6c6a\u9526"]},"created_by":1001,"created_at":"2026-05-15 15:49:54","is_delete":true,"parent_id":"","client":{"id":2596,"key":2596,"name":"\u4eac\u4e1c\u4e91\u8ba1\u7b97\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","logo":"","client_type":5,"client_class":43,"client_industry":6},"need_hidden":false,"created_at_display":"05\u670815\u65e5 15:49"},{"id":171749,"object_id":2616,"object_type":10,"target_id":39162,"target_object_type":19,"act":1,"attribute":"create","old_value":39162,"new_value":39162,"users":"{1001}","description":{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u5de5\u4f5c\u65e5\u5fd7","d4":["\u62dc\u8bbf\u5ba2\u6237"]},"created_by":1001,"created_at":"2026-05-09 18:11:24","is_delete":false,"parent_id":"","client":{"id":2616,"key":2616,"name":"\u5317\u4eac\u6e90\u70b9\u601d\u535a\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","logo":"","client_type":5,"client_class":43,"client_industry":20},"need_hidden":false,"created_at_display":"05\u670809\u65e5 18:11"},{"id":171748,"object_id":2538,"object_type":10,"target_id":39161,"target_object_type":19,"act":1,"attribute":"create","old_value":39161,"new_value":39161,"users":"{1001}","description":{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u5de5\u4f5c\u65e5\u5fd7","d4":["\u62dc\u8bbf\u5ba2\u6237"]},"created_by":1001,"created_at":"2026-05-09 18:10:58","is_delete":false,"parent_id":"","client":{"id":2538,"key":2538,"name":"(\u8fc7\u5355)\u5317\u4eac\u6606\u4ed1\u8054\u901a\u79d1\u6280\u53d1\u5c55\u80a1\u4efd\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":20},"need_hidden":false,"created_at_display":"05\u670809\u65e5 18:10"},{"id":171746,"object_id":146,"object_type":10,"target_id":39160,"target_object_type":19,"act":1,"attribute":"create","old_value":39160,"new_value":39160,"users":"{1001}","description":{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u5de5\u4f5c\u65e5\u5fd7","d4":["\u62dc\u8bbf\u5ba2\u6237"]},"created_by":1001,"created_at":"2026-05-09 17:18:36","is_delete":false,"parent_id":"","client":{"id":146,"key":146,"name":"smc(\u5929\u6d25)\u5236\u9020\u6709\u9650\u516c\u53f8-(\u91cd\u590d\u5ba2\u6237)","logo":"","client_type":5,"client_class":43,"client_industry":5},"need_hidden":false,"created_at_display":"05\u670809\u65e5 17:18"},{"id":171745,"object_id":2803,"object_type":10,"target_id":17939,"target_object_type":9,"act":2,"attribute":"update","old_value":17939,"new_value":17939,"users":"{1001}","description":{"d1":"\u97e9\u96c5\u82b3","d2":"\u66f4\u65b0\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]},"created_by":1011,"created_at":"2026-05-09 17:11:07","is_delete":false,"parent_id":"","client":{"id":2803,"key":2803,"name":"\u62d3\u5b9e\u603b\u76d1\u4f1a","logo":"","client_type":5,"client_class":43,"client_industry":13},"need_hidden":false,"created_at_display":"05\u670809\u65e5 17:11"},{"id":171741,"object_id":1661,"object_type":10,"target_id":39159,"target_object_type":19,"act":1,"attribute":"create","old_value":39159,"new_value":39159,"users":"{1001}","description":{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u5de5\u4f5c\u65e5\u5fd7","d4":["\u62dc\u8bbf\u5ba2\u6237"]},"created_by":1001,"created_at":"2026-05-09 17:07:05","is_delete":false,"parent_id":"","client":{"id":1661,"key":1661,"name":"\u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":13},"need_hidden":false,"created_at_display":"05\u670809\u65e5 17:07"},{"id":171738,"object_id":3456,"object_type":10,"target_id":18326,"target_object_type":9,"act":2,"attribute":"update","old_value":18326,"new_value":18326,"users":"{5295}","description":{"d1":"\u59da\u96ea\u7eaf","d2":"\u66f4\u65b0\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]},"created_by":5064,"created_at":"2026-05-09 09:47:39","is_delete":false,"parent_id":"","client":{"id":3456,"key":3456,"name":"\u5317\u4eac\u521b\u601d\u7acb\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":13},"need_hidden":false,"created_at_display":"05\u670809\u65e5 09:47"},{"id":171723,"object_id":3432,"object_type":10,"target_id":18358,"target_object_type":9,"act":3,"attribute":"delete","old_value":18358,"new_value":18358,"users":"{1001}","description":{"d1":"\u5218\u4eba\u8bda","d2":"\u5220\u9664\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]},"created_by":1001,"created_at":"2026-04-30 13:47:43","is_delete":true,"parent_id":"","client":{"id":3432,"key":3432,"name":"\u4e2d\u56fd\u6c11\u822a\u7ba1\u7406\u5e72\u90e8\u5b66\u9662","logo":"","client_type":1,"client_class":80,"client_industry":1},"need_hidden":false,"created_at_display":"04\u670830\u65e5 13:47"},{"id":171721,"object_id":3432,"object_type":10,"target_id":18358,"target_object_type":9,"act":2,"attribute":"update","old_value":18358,"new_value":18358,"users":"{1001}","description":{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]},"created_by":1001,"created_at":"2026-04-30 13:47:32","is_delete":true,"parent_id":"","client":{"id":3432,"key":3432,"name":"\u4e2d\u56fd\u6c11\u822a\u7ba1\u7406\u5e72\u90e8\u5b66\u9662","logo":"","client_type":1,"client_class":80,"client_industry":1},"need_hidden":false,"created_at_display":"04\u670830\u65e5 13:47"},{"id":171715,"object_id":982,"object_type":10,"target_id":39158,"target_object_type":19,"act":2,"attribute":"update","old_value":39158,"new_value":39158,"users":"{1001,1000}","description":{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5de5\u4f5c\u65e5\u5fd7","d4":["\u552e\u540e\u670d\u52a1"]},"created_by":1000,"created_at":"2026-04-30 11:38:20","is_delete":false,"parent_id":"","client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","logo":"","client_type":6,"client_class":1,"client_industry":4},"need_hidden":false,"created_at_display":"04\u670830\u65e5 11:38"},{"id":171713,"object_id":982,"object_type":10,"target_id":39158,"target_object_type":19,"act":2,"attribute":"update","old_value":39158,"new_value":39158,"users":"{1001,1000}","description":{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5de5\u4f5c\u65e5\u5fd7","d4":["\u552e\u540e\u670d\u52a1"]},"created_by":1000,"created_at":"2026-04-30 11:38:11","is_delete":false,"parent_id":"","client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","logo":"","client_type":6,"client_class":1,"client_industry":4},"need_hidden":false,"created_at_display":"04\u670830\u65e5 11:38"},{"id":171711,"object_id":982,"object_type":10,"target_id":39158,"target_object_type":19,"act":1,"attribute":"create","old_value":39158,"new_value":39158,"users":"{1001,1000}","description":{"d1":"\u66f9\u6c38\u751f","d2":"\u521b\u5efa\u4e86","d3":"\u5de5\u4f5c\u65e5\u5fd7","d4":["\u552e\u540e\u670d\u52a1"]},"created_by":1000,"created_at":"2026-04-30 11:37:20","is_delete":false,"parent_id":"","client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","logo":"","client_type":6,"client_class":1,"client_industry":4},"need_hidden":false,"created_at_display":"04\u670830\u65e5 11:37"},{"id":171709,"object_id":1956,"object_type":10,"target_id":"","target_object_type":"","act":5,"attribute":"sales_rep","old_value":["\u5218\u4eba\u8bda"],"new_value":[""],"users":"{1000}","description":{"d1":"\u66f9\u6c38\u751f","d2":"\u653e\u5f03\u4e86","d3":"\u5ba2\u6237","d4":[]},"created_by":1000,"created_at":"2026-04-29 18:18:46","is_delete":false,"parent_id":"","client":{"id":1956,"key":1956,"name":"\u5ea6\u5c0f\u6ee1\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":10},"need_hidden":true,"created_at_display":"04\u670829\u65e5 18:18"},{"id":171701,"object_id":3432,"object_type":10,"target_id":18358,"target_object_type":9,"act":1,"attribute":"create","old_value":18358,"new_value":18358,"users":"{1001}","description":{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]},"created_by":1001,"created_at":"2026-04-29 15:48:36","is_delete":true,"parent_id":"","client":{"id":3432,"key":3432,"name":"\u4e2d\u56fd\u6c11\u822a\u7ba1\u7406\u5e72\u90e8\u5b66\u9662","logo":"","client_type":1,"client_class":80,"client_industry":1},"need_hidden":false,"created_at_display":"04\u670829\u65e5 15:48"},{"id":171679,"object_id":982,"object_type":10,"target_id":39157,"target_object_type":19,"act":2,"attribute":"update","old_value":39157,"new_value":39157,"users":"{1001,1000}","description":{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5de5\u4f5c\u65e5\u5fd7","d4":["\u6316\u6398\u5546\u673a"]},"created_by":1000,"created_at":"2026-04-23 21:17:53","is_delete":false,"parent_id":"","client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","logo":"","client_type":6,"client_class":1,"client_industry":4},"need_hidden":false,"created_at_display":"04\u670823\u65e5 21:17"}],"pagenation":{"totalcount":64829,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-02 15:27:31', 297031680) RETURNING "id"
15:27:31.447	2.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "logo", "client_type", "client_class", "client_industry" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3461, 3460, 3459, 1933, 399, 2596, 2616, 2538, 146, 2803, 1661, 3456, 3432, 982, 1956)
15:27:31.159	1.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:27:31.157	0.6 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
15:27:31.157	0.2 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta