Postgresql datetrunc too slow

CREATE INDEX ON test (date_trunc('day', updated_at));

/*If updated_at is a timestamp without time zone, that will work fine. 
For a timestamp with time zone, you'll have to specify a time zone, 
because otherwise the result will depend on the session time zone, 
which makes it unusable for an index:*/

CREATE INDEX ON test (date_trunc('day', updated_at AT TIME ZONE 'UTC'));

Source: stackoverflow.com

Similar codes

0 vote262 views1 answer
Price-colour
SQL
0 vote324 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL
0 vote283 views1 answer
Oracle query to find schema you are working on
SQL
0 vote292 views1 answer
Mysql best varchar length size
SQL
3 votes270 views3 answers
Create table in microsoft sql server
SQL
21 votes283 views5 answers
Oracle all tables
SQL
0 vote276 views1 answer
Start and stop mysql
SQL
0 vote263 views1 answer
Show all mongodb
SQL
2 votes299 views2 answers
Create empty table from existing table
SQL
32 votes300 views6 answers
Insert select
SQL