Differences

This shows you the differences between two versions of the page.

--- profiling:django [2014/09/12 16:40] – Primo controllo su workflows_stateobjectrelation letti
+++ profiling:django [2015/02/16 15:28] (current) – external edit 127.0.0.1
@@ Line 61: / Line 61: @@
 ==== Misurare ====
-Un modo per controllare l'effettivo utilizo degli indici è lanciare dalla dbshell di django la query di **Utilizzo degli indici** alla pagina [[sysadmin:postgresql]]
+Un modo per controllare l'effettivo utilizo degli indici è lanciare dalla dbshell di django la query di **Utilizzo degli indici** alla pagina [[ops:postgresql]]
@@ Line 76: / Line 76: @@
 * EXPLAIN ANALYZE SELECT "workflows_stateobjectrelation"."id", "workflows_stateobjectrelation"."content_type_id", "workflows_stateobjectrelation"."content_id", "workflows_stateobjectrelation"."state_id" FROM "workflows_stateobjectrelation" INNER JOIN "workflows_state" ON ("workflows_stateobjectrelation"."state_id" = "workflows_state"."id") WHERE ("workflows_state"."name" = 'Closed'  AND "workflows_stateobjectrelation"."content_type_id" = 68 );
-                            QUERY PLAN
+%%                            QUERY PLAN
 ----------------------------------------------------------------------------------------------------------------------------------------------------------
  Nested Loop  (cost=52.76..238.26 rows=495 width=16) (actual time=31.081..47.576 rows=195 loops=1)
@@ Line 89: / Line 89: @@
 (9 righe)
-(END)
+(END) %%
@@ Line 98: / Line 98: @@
-                     QUERY PLAN
+%%                     QUERY PLAN
 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  Nested Loop  (cost=30.21..182.54 rows=495 width=16) (actual time=31.059..47.288 rows=195 loops=1)
@@ Line 109: / Line 109: @@
  Total runtime: 47.382 ms
 (8 righe)
+(END) %%