alfresco=# explain analyse SELECT app.app_name_id AS audit_app_name_id,
       entry.id AS audit_entry_id,
       entry.audit_user_id AS audit_user_id,
       entry.audit_time AS audit_time,
       entry.audit_values_id AS audit_values_id
FROM alf_audit_app app
JOIN alf_audit_entry entry ON (entry.audit_app_id = app.id)
WHERE app.app_name_id = 1
ORDER BY entry.id ASC;
                                                                               QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Nested Loop  (cost=0.44..1326451.71 rows=8972615 width=40) (actual time=17011.440..17011.441 rows=0 loops=1)
   Join Filter: (app.id = entry.audit_app_id)
   Rows Removed by Join Filter: 26917844
   ->  Index Scan using alf_audit_entry_pkey on alf_audit_entry entry  (cost=0.44..922683.01 rows=26917844 width=40) (actual time=0.073..9202.192 rows=26917844 loops=1)
   ->  Materialize  (cost=0.00..1.04 rows=1 width=16) (actual time=0.000..0.000 rows=1 loops=26917844)
         ->  Seq Scan on alf_audit_app app  (cost=0.00..1.04 rows=1 width=16) (actual time=0.022..0.024 rows=1 loops=1)
               Filter: (app_name_id = 1)
               Rows Removed by Filter: 2
 Planning Time: 0.438 ms
 Execution Time: 17011.489 ms
(10 rows)