PostgreSQLの珍しい実行計画はAurora DSQLでも出現するのか確認してみた

create table hoge (id int primary key, val int);

explain select * from hoge for update;

ERROR:  locking clause such as FOR UPDATE can be applied only on tables with equality predicates on the key

explain select * from hoge where id  = 1 for update;

                                   QUERY PLAN                                    
---------------------------------------------------------------------------------
 LockRows  (cost=100.17..208.19 rows=1 width=24)
   ->  Index Scan using hoge_pkey on hoge  (cost=100.17..208.18 rows=1 width=24)
         Index Cond: (id = 1)
         Projected via pushdown compute engine: id, val
(4 rows)

explain select * from hoge tablesample system(10);

ERROR:  Sampling is not supported

explain select id from hoge group by grouping sets(id, ());

                                           QUERY PLAN                                            
-------------------------------------------------------------------------------------------------
 GroupAggregate  (cost=125100.05..183600.06 rows=1000001 width=4)
   Group Key: id
   Group Key: ()
   ->  Index Only Scan using hoge_pkey on hoge  (cost=125100.05..171100.05 rows=1000000 width=4)
         Projected via pushdown compute engine: id
(5 rows)

explain select id from hoge except select id from fuga;

                                                 QUERY PLAN                                                  
-------------------------------------------------------------------------------------------------------------
 HashSetOp Except  (cost=125100.05..377200.10 rows=1000000 width=8)
   ->  Append  (cost=125100.05..372200.10 rows=2000000 width=8)
         ->  Subquery Scan on "*SELECT* 1"  (cost=125100.05..181100.05 rows=1000000 width=8)
               ->  Index Only Scan using hoge_pkey on hoge  (cost=125100.05..171100.05 rows=1000000 width=4)
                     Projected via pushdown compute engine: id
         ->  Subquery Scan on "*SELECT* 2"  (cost=125100.05..181100.05 rows=1000000 width=8)
               ->  Index Only Scan using fuga_pkey on fuga  (cost=125100.05..171100.05 rows=1000000 width=4)
                     Projected via pushdown compute engine: id
(8 rows)

explain
select *
from xmltable(
  '/rows/row'
  passing
  $$
  <rows>
  <row id="1"></row>
  </rows>
  $$
  columns id int path '@id'
);

ERROR:  unsupported XML feature
LINE 6:   $$
          ^
DETAIL:  This functionality requires the server to be built with libxml support.

create extension postgres_fdw;

ERROR:  unsupported statement: CreateExtension

insert into hoge select generate_series(1,10000);
analyze hoge;
explain select * from hoge where ctid < '(1,0)';

ERROR:  cannot retrieve a system column in this context

select ctid from hoge where id = 1;

ERROR:  cannot retrieve a system column in this context

SELECT oid, relname, relnamespace, relowner FROM pg_class;

  oid  |                    relname                     | relnamespace | relowner 
-------+------------------------------------------------+--------------+----------
  1247 | pg_type                                        |           11 |       10
  1249 | pg_attribute                                   |           11 |       10
  1255 | pg_proc                                        |           11 |       10
...略  

create function copy_inserted() returns trigger as $$
begin
    if (tg_op = 'INSERT') then
        execute 'insert into fuga select * from new_table';
    end if;
    return null;
end;
$$
language plpgsql;

ERROR:  CREATE FUNCTION with language plpgsql not supported

create trigger copy_hoge_insert_to_fuga
after insert on hoge
referencing new table as new_table
for each statement execute procedure copy_inserted();

ERROR:  unsupported statement: CreateTrig