SHARE
TWEET

Untitled

a guest Jun 19th, 2019 70 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. alfresco=# explain analyse SELECT app.app_name_id AS audit_app_name_id,
  2.        entry.id AS audit_entry_id,
  3.        entry.audit_user_id AS audit_user_id,
  4.        entry.audit_time AS audit_time,
  5.        entry.audit_values_id AS audit_values_id
  6. FROM alf_audit_app app
  7. JOIN alf_audit_entry entry ON (entry.audit_app_id = app.id)
  8. WHERE app.app_name_id = 1
  9. ORDER BY entry.id ASC;
  10.                                                                                QUERY PLAN                                                                                
  11. -------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  12.  Nested Loop  (cost=0.44..1326451.71 rows=8972615 width=40) (actual time=17011.440..17011.441 rows=0 loops=1)
  13.    Join Filter: (app.id = entry.audit_app_id)
  14.    Rows Removed by Join Filter: 26917844
  15.    ->  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)
  16.    ->  Materialize  (cost=0.00..1.04 rows=1 width=16) (actual time=0.000..0.000 rows=1 loops=26917844)
  17.          ->  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)
  18.                Filter: (app_name_id = 1)
  19.                Rows Removed by Filter: 2
  20.  Planning Time: 0.438 ms
  21.  Execution Time: 17011.489 ms
  22. (10 rows)
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top