{"result":{"depiction_url":null,"edges":{"hasreference":{"objects":[{"created":"2026-10-07T11:13:27Z","object_id":{"id":1307,"is_a":["text","documentation","reference","module"],"name":"doc_module_mod_server_storage","title":"mod_server_storage","uri":"https:\/\/zotonic.com\/id\/1307"},"seq":1}],"predicate":{"id":2774,"is_a":["meta","predicate"],"name":"hasreference","title":{"_type":"trans","tr":{"en":"Documentation reference"}},"uri":"https:\/\/zotonic.com\/id\/hasreference"}},"refers":{"objects":[{"created":"2026-10-07T11:13:09Z","object_id":{"id":1307,"is_a":["text","documentation","reference","module"],"name":"doc_module_mod_server_storage","title":"mod_server_storage","uri":"https:\/\/zotonic.com\/id\/1307"},"seq":1000000}],"predicate":{"id":2409,"is_a":["meta","predicate"],"name":"refers","title":{"_type":"trans","tr":{"en":"Refers"}},"uri":"https:\/\/zotonic.com\/id\/refers"}},"relation":{"objects":[{"created":"2026-10-07T11:13:27Z","object_id":{"id":2956,"is_a":["text","documentation","developerguide"],"name":"developer_database_queries","title":{"_type":"trans","tr":{"en":"Add a database query when models are not enough"}},"uri":"https:\/\/zotonic.com\/id\/2956"},"seq":1},{"created":"2026-10-07T11:13:27Z","object_id":{"id":3004,"is_a":["text","documentation","developerguide"],"name":"developer_slow_requests","title":{"_type":"trans","tr":{"en":"A page is slow"}},"uri":"https:\/\/zotonic.com\/id\/3004"},"seq":2}],"predicate":{"id":303,"is_a":["meta","predicate"],"name":"relation","title":{"_type":"trans","tr":{"nl":"Relatie","en":"Relation"}},"uri":"http:\/\/purl.org\/dc\/terms\/relation"}},"subject":{"objects":[{"created":"2026-10-07T11:13:27Z","object_id":{"id":2554,"is_a":["categorization","keyword","keyword_information_type"],"name":"zotonic_topic_how_to_guide","title":"How-to guide","uri":"https:\/\/zotonic.com\/id\/2554"},"seq":1},{"created":"2026-10-07T11:13:27Z","object_id":{"id":2564,"is_a":["categorization","keyword","keyword_audience"],"name":"zotonic_topic_backend_developer","title":"Backend developer","uri":"https:\/\/zotonic.com\/id\/2564"},"seq":2},{"created":"2026-10-07T11:13:27Z","object_id":{"id":2631,"is_a":["categorization","keyword","keyword_architecture"],"name":"zotonic_topic_database","title":"Database","uri":"https:\/\/zotonic.com\/id\/2631"},"seq":3},{"created":"2026-10-07T11:13:27Z","object_id":{"id":2607,"is_a":["categorization","keyword","keyword_domain"],"name":"zotonic_topic_logging_and_monitoring","title":"Logging and monitoring","uri":"https:\/\/zotonic.com\/id\/2607"},"seq":4},{"created":"2026-10-07T11:13:27Z","object_id":{"id":2671,"is_a":["categorization","keyword","keyword_technology"],"name":"zotonic_topic_postgresql","title":"PostgreSQL","uri":"https:\/\/zotonic.com\/id\/2671"},"seq":5}],"predicate":{"id":308,"is_a":["meta","predicate"],"name":"subject","title":{"_type":"trans","tr":{"en":"Keyword"}},"uri":"http:\/\/purl.org\/dc\/elements\/1.1\/subject"}}},"id":2977,"is_a":["text","documentation","developerguide"],"links":[{"rel":"self","target":"https:\/\/zotonic.com\/.zotonic\/websub\/topic\/2977"},{"rel":"hub","target":"https:\/\/zotonic.com\/.zotonic\/websub"}],"medium":null,"medium_url":null,"name":"developer_database_trace","page_url":{"en":"https:\/\/zotonic.com\/docs\/2977\/trace-database-queries-for-your-session","x-default":"https:\/\/zotonic.com\/docs\/2977\/trace-database-queries-for-your-session"},"preview_url":null,"resource":{"body":{"_type":"trans","tr":{"en":"<p>Enable <a href=\"\/id\/1307\" class=\"doc-reference doc-reference-module\"><code>module#mod_server_storage<\/code><\/a> if the Development page says it is needed for database tracing. On the Development page, enable <strong>Trace all database queries for the current session<\/strong>.<\/p>\n<p>Reproduce one page load or action in that session and inspect the trace output. Look for repeated queries, unexpectedly large result sets, and queries that dominate the request time. A trace from another session may not include your request.<\/p>\n<p>Turn tracing off when finished. Use the evidence to choose a query to investigate; do not add indexes based on query count alone.<\/p>"}},"category_id":{"id":317,"is_a":["meta","category"],"name":"developerguide","title":"Developer guide","uri":"https:\/\/zotonic.com\/id\/developerguide"},"content_group_id":{"id":339,"is_a":["meta","content_group"],"name":"default_content_group","title":{"_type":"trans","tr":{"en":"Default Content Group"}},"uri":"https:\/\/zotonic.com\/id\/default_content_group"},"created":"2026-10-07T11:12:57Z","creator_id":{"id":1,"is_a":["person"],"name":"administrator","title":"Site Administrator","uri":"https:\/\/zotonic.com\/id\/1"},"doc_editorial_bundle":true,"doc_editorial_edges":{"hasreference":[1307],"relation":[2956,3004],"subject":[2554,2564,2607,2631,2671]},"is_authoritative":true,"is_dependent":false,"is_featured":false,"is_protected":false,"is_published":true,"is_unfindable":false,"language":["en"],"modified":"2026-10-07T11:13:33Z","modifier_id":{"id":1,"is_a":["person"],"name":"administrator","title":"Site Administrator","uri":"https:\/\/zotonic.com\/id\/1"},"name":"developer_database_trace","pivot_geocode":null,"pivot_location_lat":null,"pivot_location_lng":null,"privacy":0,"publication_end":"9999-06-01T00:00:00Z","publication_start":"2026-10-07T11:12:57Z","slug":"trace-database-queries-for-your-session","summary":{"_type":"trans","tr":{"en":"Enable module#mod_server_storage if the Development page says it is needed for database tracing. On the Development page, enable Trace all database queries for the current session."}},"title":{"_type":"trans","tr":{"en":"Trace database queries for your session"}},"title_slug":{"_type":"trans","tr":{"en":"trace-database-queries-for-your-session"}},"tz":"UTC","uri":null,"version":22,"visible_for":0},"uri":"https:\/\/zotonic.com\/id\/2977","uri_template":"https:\/\/zotonic.com\/id\/:id","websub":{"hub":"https:\/\/zotonic.com\/.zotonic\/websub","topic":"https:\/\/zotonic.com\/.zotonic\/websub\/topic\/2977"}},"status":"ok"}