Task: Get Execution Time of a PostgreSQL Query

Task: Get Execution Time of a PostgreSQL Query: a task in Terminal-Lego-15k (Harbor dataset). Write a SQL script for PostgreSQL that measures the execution time of a query and outputs the duration. The original attempt used T-SQL (SQL Server) syntax with DECLARE @variable which is not valid in…

The task

Write a SQL script for PostgreSQL that measures the execution time of a query and outputs the duration. The original attempt used T-SQL (SQL Server) syntax with `DECLARE @variable` which is not valid in PostgreSQL. Your task is to create a proper PostgreSQL-compatible solution that measures query execution time.

Part of PrimeIntellect/Terminal-Lego-15k.