Table zfindb.public.tmp_efs_map Generated by
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
Column Type Size Nulls Auto Default Children Parents Comments
efs1 int8 19  √  null
efs2 int8 19  √  null
xpat_found bool 1  √  null
xpatres_superterm text 2147483647  √  null
xpatres_subterm text 2147483647  √  null

Table contained 12,580,214 rows at Wed Sep 15 00:41 PDT 2021

Column(s) Type Sort Constraint Name
efs2 Performance Asc tmp_index
xpatres_superterm Performance Asc tmp_index_x
xpatres_subterm Performance Asc tmp_index_x2