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

2 votes139 views1 answer
ADD COLOUNS CREATED AND UPDATED AT IN MYSQL
SQL
0 vote120 views3 answers
Get free card roblox
SQL
0 vote129 views1 answer
How many columns can be used for creating index?
SQL
9 votes170 views1 answer
No sql
SQL
0 vote126 views1 answer
Sql select all tables from database change url
SQL
2 votes142 views1 answer
Sql count having
SQL
29 votes122 views5 answers
Mysql show table structure
SQL
0 vote146 views2 answers
Amazon linux postgresql client
SQL
10 votes131 views1 answer
Oracle object dependencies
SQL
0 vote130 views1 answer
Will graphql replace sql
SQL