Free Online PostgreSQL 15 Playground: Practice & Master SQL Skills

SQL code: Upload Copy Format Clear

CREATE TABLE test(uuid text); insert into test select uuid_generate_v4()::text from generate_series(1,1000000); explain analyze select count(*) from (select uuid::varchar(5) from test) t1; explain analyze select count(*) from (select left(uuid, 5) from test) t1; explain analyze select count(*) from (select uuid::varchar(5) from test) t1; explain analyze select count(*) from (select left(uuid, 5) from test) t1; explain analyze select count(*) from (select uuid::varchar(5) from test) t1; explain analyze select count(*) from (select left(uuid, 5) from test) t1; explain analyze select count(*) from (select uuid::varchar(5) from test) t1; explain analyze select count(*) from (select left(uuid, 5) from test) t1;

SQL Server: Preserve result

SQLize Online / PHPize Online / SQLtest Online

SQLize.online is a free online SQL environment for quickly running, experimenting with and sharing code. You can run your SQL code on top of the most popular RDBMS including MySQL, MariaDB, SQLite, PostgreSQL, Oracle and Microsoft SQL Server.

Stuck with a problem? Got Error? Ask ChatGPT!