Business
Jobs
  • About Us
  • Solutions
    • Job Postings
      Post your job and receive qualified candidates in 48h.
    • Candidate Assessments
      500+ technical and psychological tests, plus anti-fraud.
    • Headhunting
      Tailor-made executive search from start to finish.
    • Payroll + EOR
      Payroll dispersal and EOR across 15+ LATAM countries.
  • Pricing
  • Jobs

0

294
Views
EXPLAIN ANALYZE on CREATE INDEX with PostgreSQL

We can execute EXPLAIN ANALYZE on a query and on commands like CREATE TABLE but seems like we cannot on a CREATE INDEX.

What is the reason for this? Must one only get statistics about an index only elsewhere?

over 4 years ago · Santiago Trujillo
1 answers
Answer question

0

To get the time to create an index, you can do the following:

postgres=# select * from now();
postgres=# create index foo on table(col);
postgres=# select * from now();

Type the last command (select * from now()) while the index is being created, be sure to hit enter and it will run this command as soon as the index creation completes. You'll end up with the timestamp just before and just after index creation.

over 4 years ago · Santiago Trujillo Report
Answer question
Find remote jobs

Discover the new way to find a job!

Top jobs
Top job categories
Business
Post vacancy Pricing Sales
Legal
Terms and conditions Privacy policy
© 2026 PeakU Inc. All Rights Reserved.
Andres GPT
Show me some job opportunities
There's an error!