1

where are indexes created in AGE extension on Postgres since normally indexes are created on every column where we create index. But in case of AGE since its graph-based so there are nodes and edges so how does indexes work in this scenario ??

Since nodes are different from columns so how does indexes work on them ??

I'm trying to understand this query as how does indexes work in apache-age !

Olaf Kock
  • 46,930
  • 8
  • 59
  • 90
umerFreak
  • 9
  • 2

1 Answers1

0

In AGE the initial schema is 'ag_catalog'. For every new graph a new schema is formed. To see the general indexes we can do:

    SELECT schemaname, indexname, tablename 
    FROM pg_indexes 
    WHERE schemaname = 'ag_catalog' 
    ORDER BY indexname;

For a particular graph you can also see the indexes by just changing

    WHERE schemaname = '<graph_name>'
Hrishikesh Mallick
  • 9
  • 2