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

9 votes139 views3 answers
Show table columns mysql command line
SQL
0 vote147 views1 answer
Get clob size oracle
SQL
0 vote151 views1 answer
Aktor yang pernah terlibat di film bergenre Aksi di sql
SQL
0 vote156 views1 answer
Port 5432 is already in use Usually this means that there is already a PostgreSQL server running on your Mac. If you want to run multiple servers simultaneously, use different ports.
SQL
8 votes143 views3 answers
Oracle auto_increment
SQL
0 vote135 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL
0 vote159 views1 answer
T-SQL - Where Used List (Table/View)
SQL
0 vote110 views1 answer
Finish transaction sql
SQL
0 vote160 views1 answer
Postgresql inheritance
SQL
1 vote169 views3 answers
Postgresql crete view
SQL