· 7 years ago · Nov 30, 2018, 08:18 AM
1CREATE TABLE IF NOT EXISTS table_name (
2 attribute VARCHAR(64) ARRAY DEFAULT NULL
3);
4
5CREATE INDEX table_ix ON table_name USING GIN (attribute);
6
7Seq Scan on subject (cost=0.00..2.15 rows=11 width=717) (actual time=0.010..0.019 rows=11 loops=1)
8 Filter: (attribute @> '{VALUE}'::character varying[])
9 Rows Removed by Filter: 1
10Planning time: 0.201 ms
11Execution time: 0.033 ms