\d visitors
Таблица "visitors"
 Столбец | Тип | Модификаторы
----------------------------+-----------------------------+-------------------------------------------------------
 id | integer | NOT NULL DEFAULT nextval('visitors_id_seq'::regclass)
 account_id | integer | NOT NULL
 ...
 Триггеры:
 search_columns_update BEFORE INSERT OR UPDATE ON visitors FOR EACH ROW EXECUTE PROCEDURE visitors_search_trigger()
Дочерних таблиц: 100 (чтобы просмотреть и их, воспользуйтесь \d+)

SELECT create_hash_partitions('visitors', 'account_id', 100, FALSE);
SELECT partition_table_concurrently('visitors', 10000, 1.0);

\d visitors_80
 Таблица "visitors_80"
 Столбец | Тип | Модификаторы
----------------------------+-----------------------------+-------------------------------------------------------
 id | integer | NOT NULL DEFAULT nextval('visitors_id_seq'::regclass)
 account_id | integer | NOT NULL
 ...
 Ограничения-проверки:
 "pathman_visitors_80_check" CHECK (get_hash_part_idx(hashint4(account_id), 100) = 80)
Наследует: visitors

explain analyze update visitors set updated_at = now() where id = 1 and account_id = 1;
 QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------------------------
 Update on visitors (cost=0.57..258.81 rows=101 width=2750) (actual time=77.315..77.315 rows=0 loops=1)
 Update on visitors
 Update on visitors_0
 ...
 Update on visitors_99
 ...
 Planning time: 24.816 ms
 Execution time: 86.232 ms
(407 строк)

explain analyze delete from visitors where id = 1 and account_id = 1;
 QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------------------------
 Delete on visitors (cost=0.57..258.30 rows=101 width=6) (actual time=10.997..10.997 rows=0 loops=1)
 Delete on visitors
 Delete on visitors_0
 ...
 Delete on visitors_99
 Planning time: 23.559 ms
 Execution time: 11.652 ms
(407 строк)

explain analyze select 1 from visitors where id = 1 and account_id = 1;
 QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------
 Result (cost=0.57..5.85 rows=2 width=4) (actual time=1.541..1.541 rows=0 loops=1)
 -> Append (cost=0.57..5.83 rows=2 width=0) (actual time=1.541..1.541 rows=0 loops=1)
 -> Index Scan using visitors_pkey on visitors (cost=0.57..2.99 rows=1 width=0) (actual time=0.959..0.959 rows=0 loops=1)
 Index Cond: (id = 1)
 Filter: (account_id = 1)
 -> Index Scan using visitors_70_pkey on visitors_70 (cost=0.43..2.85 rows=1 width=0) (actual time=0.581..0.581 rows=0 loops=1)
 Index Cond: (id = 1)
 Filter: (account_id = 1)
 Planning time: 0.554 ms
 Execution time: 1.568 ms
(10 строк)

SELECT * FROM pg_extension;
 extname | extowner | extnamespace | extrelocatable | extversion | extconfig | extcondition
---------------+----------+--------------+----------------+------------+---------------------+--------------
 plpgsql | 10 | 11 | f | 1.0 | |
 btree_gin | 10 | 2200 | t | 1.0 | |
 dblink | 10 | 17225 | t | 1.1 | |
 fuzzystrmatch | 10 | 17225 | t | 1.0 | |
 intarray | 10 | 2200 | t | 1.0 | |
 postgres_fdw | 16384 | 2200 | t | 1.0 | |
 pgstattuple | 10 | 2200 | t | 1.1 | |
 pg_trgm | 10 | 2200 | t | 1.3 | |
 btree_gist | 16384 | 17225 | t | 1.2 | |
 hstore | 10 | 2200 | t | 1.4 | |
 pg_pathman | 16384 | 17225 | f | 1.4 | {46492080,46492091} | {"",""}
 pg_repack | 10 | 2200 | f | 1.4.2 | |
(12 строк)

SELECT version();
 version
----------------------------------------------------------------------------------------------------------
 PostgreSQL 9.6.9 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-18), 64-bit
(1 строка)

SELECT get_pathman_lib_version();
 get_pathman_lib_version
-------------------------
 1.4.12
(1 строка)