User Tools

Site Tools


profiling:django

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Next revisionBoth sides next revision
profiling:django [2014/09/12 16:40] – Primo controllo su workflows_stateobjectrelation lettiprofiling:django [2014/09/12 16:45] letti
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 ); * 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)  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) (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)  Nested Loop  (cost=30.21..182.54 rows=495 width=16) (actual time=31.059..47.288 rows=195 loops=1)
Line 110: Line 110:
 (8 righe) (8 righe)
  
 +(END) %%
profiling/django.txt · Last modified: 2015/02/16 15:28 by 127.0.0.1