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)