Editing Accessing Photos and Pictures on Synology Diskstation NAS (section)

== Verifying media indexing ==

`ssh` to the NAS.

<syntaxhighlight lang="sh">
$ sudo psql mediaserver postgres
</syntaxhighlight>

To view the number of image files that have been indexed:

<syntaxhighlight lang="postgres">
mediaserver=# select count(*) from photo;
</syntaxhighlight>

If the DSM is currently updating the index, running this command multiple times may show the number of indexed files increasing.

Also, after re-indexing the DSM will index the 3 types of media one after the other, e.g. video, music, and photo. If video and music are indexed first, the count for photos will remain at 0 until all the files of those types have been indexed.

To view stats about specific files that have been indexed:

<syntaxhighlight lang="postgres">
mediaserver=# select * from photo where path like '/[VOLUME_NAME]/photo/path/to/subdirectory%' order by id desc limit 10;
</syntaxhighlight>