clear markdown feedback
clear markdown feedback
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3364508 fiddles created (36275 in the last week).

create table docs(how_to_use_dbfiddle) as values ('Enter one statement per field') , ('Fields grow as you type') , ('Use the [+] buttons to add more') , ('See examples below for advanced usage');
4 rows affected
 hidden batch(es)


explain (analyze,buffers) select max('Do this to get execution plans and stats') from docs d1 cross join docs d2;
QUERY PLAN
Aggregate (cost=27794.60..27794.61 rows=1 width=32) (actual time=0.025..0.025 rows=1 loops=1)
Buffers: shared hit=2 dirtied=1
-> Nested Loop (cost=0.00..23170.60 rows=1849600 width=0) (actual time=0.008..0.016 rows=16 loops=1)
Buffers: shared hit=2 dirtied=1
-> Seq Scan on docs d1 (cost=0.00..23.60 rows=1360 width=0) (actual time=0.004..0.005 rows=4 loops=1)
Buffers: shared hit=1 dirtied=1
-> Materialize (cost=0.00..30.40 rows=1360 width=0) (actual time=0.001..0.001 rows=4 loops=4)
Buffers: shared hit=1
-> Seq Scan on docs d2 (cost=0.00..23.60 rows=1360 width=0) (actual time=0.001..0.002 rows=4 loops=1)
Buffers: shared hit=1
Planning time: 0.089 ms
Execution time: 0.058 ms
 hidden batch(es)