CREATE TABLE public test id integer NOT NULL user_id integer last_modi

 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
CREATE TABLE public.test
(
id integer NOT NULL,
user_id integer,
last_modified timestamp with time zone,
latest_device_used character varying(200),
latest_os_used character varying(200),
latest_browser_used character varying(200),
latest_ip_used inet
)
WITH (
OIDS=FALSE
);
ALTER TABLE public.test
OWNER TO postgres;
dugga=# explain analyze UPDATE "test" SET "user_id" = 91, "last_modified" = '2019-02-12T08:44:40.341139+00:00'::timestamptz, "latest_device_used" = 'PC', "latest_os_used" = 'Ubuntu', "latest_browser_used" = 'Firefox 65.0', "latest_ip_used" = '127.0.0.1'::inet WHERE "test"."id" = 1
;
QUERY PLAN
--------------------------------------------------------------------------------------------------------
Update on test (cost=0.00..10.75 rows=1 width=1308) (actual time=0.036..0.036 rows=0 loops=1)
-> Seq Scan on test (cost=0.00..10.75 rows=1 width=1308) (actual time=0.013..0.014 rows=1 loops=1)
Filter: (id = 1)
Planning time: 0.093 ms
Execution time: 0.075 ms
(5 rows)