Changes between Version 14 and Version 15 of neb-touch-gory-details

Timestamp:

Feb 9, 2011, 5:04:54 PM (15 years ago)

Author:

Serge CHASTEL

Comment:

--

neb-touch-gory-details

@@ -24 +24 @@
   === SQL statements decomposition ===
 
-
+Stat_object statement:
+
+{{{
+        SELECT
+            so.so_id,
+            so.ext_id,
+            attr.read_lock,
+            attr.write_lock,
+            attr.epoch,
+            attr.mtime,
+            SUM(available) as available,
+            COUNT(instance.so_id) as instances
+        FROM storage_object as so
+        JOIN storage_object_attr as attr
+            USING (so_id)
+        JOIN instance
+            USING (so_id)
+        LEFT JOIN mountedvol
+            USING(vol_id)
+        WHERE ext_id = ?
+        GROUP BY so.so_id
+}}}
+   
+with ? = this/is/a/test/never/done/before
   === Trace ===
 {{{