API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 23rd, 2017
59
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.01 KB | None | 0 0
raw download clone embed print report
  1. QUERY PLAN
  2. ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  3. GroupAggregate (cost=408.42..408.68 rows=5 width=152) (actual time=41.138..41.138 rows=1 loops=1)
  4. Group Key: u.email, u.login, (COALESCE(NULLIF((u.first_name)::text, ''::text), (u.login)::text)), u.last_name, c.name, c.size_cd, c.alias_name, cpa.balance, ct.name
  5. -> Sort (cost=408.42..408.43 rows=5 width=152) (actual time=41.097..41.097 rows=2 loops=1)
  6. Sort Key: u.email, u.login, (COALESCE(NULLIF((u.first_name)::text, ''::text), (u.login)::text)), u.last_name, c.name, c.size_cd, c.alias_name, cpa.balance, ct.name
  7. Sort Method: quicksort Memory: 25kB
  8. -> Nested Loop Left Join (cost=3.44..408.36 rows=5 width=152) (actual time=41.001..41.031 rows=2 loops=1)
  9. -> Nested Loop Left Join (cost=3.15..406.63 rows=5 width=136) (actual time=40.996..41.024 rows=2 loops=1)
  10. -> Nested Loop Left Join (cost=2.86..365.04 rows=5 width=136) (actual time=40.994..41.022 rows=2 loops=1)
  11. -> Nested Loop Left Join (cost=2.44..83.29 rows=5 width=136) (actual time=40.974..40.993 rows=2 loops=1)
  12. Join Filter: (v.company_id = c.id)
  13. -> Nested Loop Left Join (cost=2.02..59.34 rows=1 width=136) (actual time=40.930..40.944 rows=1 loops=1)
  14. Join Filter: (ca.company_id = c.id)
  15. -> Nested Loop Left Join (cost=1.73..51.03 rows=1 width=132) (actual time=31.196..31.209 rows=1 loops=1)
  16. -> Nested Loop (cost=1.44..33.55 rows=1 width=128) (actual time=24.684..24.697 rows=1 loops=1)
  17. -> Nested Loop (cost=1.15..25.23 rows=1 width=120) (actual time=14.955..14.966 rows=1 loops=1)
  18. -> Nested Loop (cost=0.71..16.76 rows=1 width=63) (actual time=6.688..6.696 rows=1 loops=1)
  19. -> Index Only Scan using index_company_users_on_company_id_and_user_id on company_users cu (cost=0.29..8.31 rows=1 width=8) (actual time=6.662..6.663 rows=1 loops=1)
  20. Index Cond: (company_id = 1000028131)
  21. Heap Fetches: 1
  22. -> Index Scan using companies_pkey on companies c (cost=0.42..8.44 rows=1 width=59) (actual time=0.019..0.026 rows=1 loops=1)
  23. Index Cond: (id = 1000028131)
  24. -> Index Scan using users_pkey on users u (cost=0.43..8.46 rows=1 width=65) (actual time=8.264..8.266 rows=1 loops=1)
  25. Index Cond: (id = cu.user_id)
  26. -> Index Scan using index_company_payment_accounts_on_company_id on company_payment_accounts cpa (cost=0.29..8.31 rows=1 width=12) (actual time=9.723..9.725 rows=1 loops=1)
  27. Index Cond: (company_id = 1000028131)
  28. -> Index Scan using index_on_company_payment_account_id on company_payment_transactions cpt (cost=0.29..17.44 rows=4 width=12) (actual time=6.505..6.505 rows=0 loops=1)
  29. Index Cond: (company_payment_account_id = cpa.id)
  30. -> Nested Loop (cost=1.15..25.23 rows=1 width=120) (actual time=14.955..14.966 rows=1 loops=1)
  31. -> Nested Loop (cost=0.71..16.76 rows=1 width=63) (actual time=6.688..6.696 rows=1 loops=1)
  32. -> Index Only Scan using index_company_users_on_company_id_and_user_id on company_users cu (cost=0.29..8.31 rows=1 width=8) (actual time=6.662..6.663 rows=1 loops=1)
  33. Index Cond: (company_id = 1000028131)
  34. Heap Fetches: 1
  35. -> Index Scan using companies_pkey on companies c (cost=0.42..8.44 rows=1 width=59) (actual time=0.019..0.026 rows=1 loops=1)
  36. Index Cond: (id = 1000028131)
  37. -> Index Scan using users_pkey on users u (cost=0.43..8.46 rows=1 width=65) (actual time=8.264..8.266 rows=1 loops=1)
  38. Index Cond: (id = cu.user_id)
  39. -> Index Scan using index_company_payment_accounts_on_company_id on company_payment_accounts cpa (cost=0.29..8.31 rows=1 width=12) (actual time=9.723..9.725 rows=1 loops=1)
  40. Index Cond: (company_id = 1000028131)
  41. -> Index Scan using index_on_company_payment_account_id on company_payment_transactions cpt (cost=0.29..17.44 rows=4 width=12) (actual time=6.505..6.505 rows=0 loops=1)
  42. Index Cond: (company_payment_account_id = cpa.id)
  43. -> Index Only Scan using index_company_addresses_on_company_id_and_address_id on company_addresses ca (cost=0.29..8.30 rows=1 width=8) (actual time=9.730..9.730 rows=0 loops=1)
  44. Index Cond: (company_id = 1000028131)
  45. Heap Fetches: 0
  46. -> Index Scan using index_vacancies_on_company_id on vacancies v (cost=0.42..23.89 rows=5 width=8) (actual time=0.031..0.035 rows=2 loops=1)
  47. Index Cond: (company_id = 1000028131)
  48. -> Index Scan using index_vacancy_responses_on_vacancy_id on vacancy_responses vr (cost=0.42..56.19 rows=16 width=8) (actual time=0.011..0.011 rows=0 loops=2)
  49. Index Cond: (vacancy_id = v.id)
  50. -> Index Scan using addresses_pkey on addresses a (cost=0.29..8.31 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=2)
  51. Index Cond: (id = ca.address_id)
  52. -> Index Scan using cities_pkey on cities ct (cost=0.29..0.33 rows=1 width=24) (actual time=0.001..0.001 rows=0 loops=2)
  53. Index Cond: (id = a.city_id)
  54. Planning time: 2.454 ms
  55. Execution time: 41.360 ms
  56. (40 rows)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!