Snippets

Lucas Possamai Slow Queries - 2016-02-18

Created by Lucas Possamai
slow_feb
Raw 
 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
2016-02-17 23:32:25.044 UTC|31074|[56c5029a.7962]@192.168.100.147(46145)|geoop_web_live|PID_17753|||OP_addnote|www/postapi.php?|geoop_live LOG:  duration: 110896.667 ms  statement: /*[17753] REQUEST-URI: |postapi.php*/
WITH  inserted_notes_main AS (
INSERT INTO ja_notes (time_start,n_quote_status,description,note_type,item_code,mobiuserid,jobid)
SELECT to_timestamp(1455751795),0,'Name: SHEILA T','note','signature',953526,13911361
RETURNING bill_item_id,id
) SELECT * FROM inserted_notes_main;


2016-02-17 23:32:25.072 UTC|26452|[56c50276.6754]@192.168.100.147(43105)|geoop_web_live|PID_14916|||OP_editjob|www/postapi.php?|geoop_live LOG:  duration: 146053.453 ms  statement: /*[14916] REQUEST-URI: |postapi.php*/
UPDATE ja_job_users SET mobiuser_id = 208901, start_visit = to_timestamp(1455751500)::timestamp without time zone, end_visit = to_timestamp(1455752100)::timestamp without time zone WHERE clientid = 2565 AND job_id = 13919198 AND mobiuser_id = 208901 AND deleted = false


2016-02-17 23:32:25.100 UTC|3207|[56c502ca.c87]@192.168.100.146(35551)|geoop_web_live|PID_9979|||OP_editjob|www/postapi.php?|geoop_live LOG:  duration: 62701.531 ms  statement: /*[9979] REQUEST-URI: |postapi.php*/
UPDATE ja_job_users SET mobiuser_id = 9264, start_visit = to_timestamp(1455751200)::timestamp without time zone, end_visit = to_timestamp(1455751800)::timestamp without time zone WHERE clientid = 2565 AND job_id = 13912852 AND mobiuser_id = 9264 AND deleted = false


2016-02-17 23:32:25.155 UTC|4061|[56c502d3.fdd]@192.168.100.146(36228)|geoop_web_live|PID_10050|||OP_addnote|www/postapi.php?|geoop_live LOG:  duration: 53649.764 ms  statement: /*[10050] REQUEST-URI: |postapi.php*/
WITH  inserted_notes_main AS (
INSERT INTO ja_notes (time_start,n_quote_status,note_type,mobiuserid,jobid)
SELECT to_timestamp(1455751781),0,'timer',174517,13897009
RETURNING bill_item_id,id
) SELECT * FROM inserted_notes_main;


2016-02-17 23:32:25.214 UTC|2469|[56c502c2.9a5]@192.168.100.147(49331)|geoop_web_live|PID_19409|UID_937086|CID_21268|OP_addnote|www/postapi.php?|geoop_live LOG:  duration: 70638.754 ms  statement: /*[19409] REQUEST-URI: |postapi.php*/
WITH  inserted_notes_main AS (
INSERT INTO ja_notes (time_start,n_quote_status,description,note_type,mobiuserid,jobid)
SELECT to_timestamp(1455751870),0,'Keys have been returned to Ray White Warner','note',937086,13805873
RETURNING bill_item_id,id
) SELECT * FROM inserted_notes_main;


2016-02-17 23:32:25.221 UTC|2645|[56c502c4.a55]@192.168.100.146(35098)|geoop_web_live|PID_8605|||OP_addnote|www/postapi.php?|geoop_live LOG:  duration: 68535.531 ms  statement: /*[8605] REQUEST-URI: |postapi.php*/
WITH  inserted_notes_main AS (
INSERT INTO ja_notes (time_start,n_quote_status,description,note_type,item_code,mobiuserid,jobid)
SELECT to_timestamp(1455751795),0,'Name: SHEILA T','note','signature',953526,13911361
RETURNING bill_item_id,id
) SELECT * FROM inserted_notes_main;

Comments (0)

HTTPS SSH

You can clone a snippet to your computer for local editing. Learn more.