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 vote378 views1 answer
Insert set mysql
SQL
0 vote382 views1 answer
Sql date time query find
SQL
0 vote402 views1 answer
How to use sqlcommand
SQL
2 votes357 views1 answer
Oracle find unusable indexes
SQL
0 vote388 views1 answer
Best sql collation
SQL
1 vote386 views1 answer
Connect to mysql database ubuntu
SQL
0 vote351 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL
19 votes361 views5 answers
Mysql between date range
SQL
0 vote346 views1 answer
TSQL function split string
SQL
15 votes353 views3 answers
Create table with primary key auto increment in sql
SQL