explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MXjr

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 1,285.577 ↓ 200.0 200 1

Limit (cost=312,418.06..312,419.02 rows=1 width=1,258) (actual time=1,279.829..1,285.577 rows=200 loops=1)

2. 0.000 1,285.547 ↓ 200.0 200 1

Finalize GroupAggregate (cost=312,418.06..312,419.02 rows=1 width=1,258) (actual time=1,279.827..1,285.547 rows=200 loops=1)

  • Group Key: (timezone('Europe/London'::text, date_trunc('day'::text, timezone('Europe/London'::text, user_game_activity.interval_start_date)))), (timezone('Europe/London'::text, date_trunc('month'::text, timezone('Europe/London'::text, user_game_activity.interval_start_date)))), users.user_id, game_supplier.supplier_id, game_category.category_id, game.game_id, game_profile.game_profile_id, portal.portal_id, vip_level.vip_level_id, user_game_activity.client_mode, user_game_activity.play_mode, vip_schema.description
3. 1,309.886 1,309.886 ↓ 116.5 233 1

Gather Merge (cost=312,418.06..312,418.53 rows=2 width=1,098) (actual time=1,279.755..1,309.886 rows=233 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • -> Partial GroupAggregat-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
4. 0.023 9,296.245 ↑ 1.0 200 1

Limit (cost=1,218,553.02..1,218,606.02 rows=200 width=1,258) (actual time=9,293.275..9,296.245 rows=200 loops=1)

5. 2.941 9,296.222 ↑ 35.2 200 1

GroupAggregate (cost=1,218,553.02..1,220,419.41 rows=7,043 width=1,258) (actual time=9,293.274..9,296.222 rows=200 loops=1)

  • Group Key: (timezone('Europe/London'::text, date_trunc('day'::text, timezone('Europe/London'::text, user_game_activity.interval_start_date)))), (timezone('Europe/London'::text, date_trunc('month'::text, timezone('Europe/London'::text, user_game_activity.interval_start_date)))), users.user_id, game_supplier.supplier_id, game_category.category_id, game.game_id, game_profile.game_profile_id, portal.portal_id, vip_level.vip_level_id, user_game_activity.client_mode, user_game_activity.play_mode, vip_schema.description
6. 110.854 9,293.281 ↑ 17.0 415 1

Sort (cost=1,218,553.02..1,218,570.62 rows=7,043 width=368) (actual time=9,293.182..9,293.281 rows=415 loops=1)

  • Sort Key: (timezone('Europe/London'::text, date_trunc('day'::text, timezone('Europe/London'::text, user_game_activity.interval_start_date)))), (timezone('Europe/London'::text, date_trunc('month'::text, timezone('Europe/London'::text, user_game_activity.interval_start_date)))), users.user_id, game_supplier.supplier_id, game_category.category_id, game.game_id, game_profile.game_profile_id, portal.portal_id, vip_level.vip_level_id, user_game_activity.client_mode, user_game_activity.play_mode, vip_schema.description
  • Sort Method: quicksort Memory: 16462kB
7. 76.880 9,182.427 ↓ 4.3 30,436 1

Merge Join (cost=26,898.05..1,218,102.90 rows=7,043 width=368) (actual time=8,766.172..9,182.427 rows=30,436 loops=1)

  • Merge Cond: ((vip_level.vip_schema_id)::text = (vip_schema.vip_schema_id)::text)
8. 270.444 9,105.502 ↓ 4.3 30,436 1

Nested Loop (cost=2,058.15..1,242,746.87 rows=7,043 width=347) (actual time=8,766.080..9,105.502 rows=30,436 loops=1)

  • Join Filter: (user_game_activity.vip_level_id = vip_level.vip_level_id)
  • Rows Removed by Join Filter: 730464
9. 0.158 0.158 ↑ 1.0 25 1

Index Scan using vip_level_unq02 on vip_level (cost=0.14..12.51 rows=25 width=20) (actual time=0.016..0.158 rows=25 loops=1)

10. 127.333 8,834.900 ↓ 4.3 30,436 25

Materialize (cost=2,058.01..1,240,110.84 rows=7,043 width=335) (actual time=3.193..353.396 rows=30,436 loops=25)

11. 30.412 8,707.567 ↓ 4.3 30,436 1

Hash Join (cost=2,058.01..1,240,075.63 rows=7,043 width=335) (actual time=79.794..8,707.567 rows=30,436 loops=1)

  • Hash Cond: (game.game_id = acl_allowed_game.game_id)
12. 0.000 8,676.063 ↓ 4.3 30,436 1

Gather (cost=1,947.32..1,239,946.47 rows=7,009 width=343) (actual time=78.682..8,676.063 rows=30,436 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
13. 12.685 8,690.236 ↓ 3.5 10,145 3 / 3

Hash Left Join (cost=947.32..1,238,245.57 rows=2,920 width=343) (actual time=56.182..8,690.236 rows=10,145 loops=3)

  • Hash Cond: ((organisation.organisation_id)::text = (organisation_ancestor.organisation_id)::text)
14. 12.911 8,677.261 ↓ 3.5 10,145 3 / 3

Hash Join (cost=932.93..1,238,184.47 rows=2,920 width=352) (actual time=55.847..8,677.261 rows=10,145 loops=3)

  • Hash Cond: (users.affiliate_id = affiliate.affiliate_id)
15. 19.542 8,663.381 ↓ 1.5 10,145 3 / 3

Nested Loop (cost=879.76..1,238,076.38 rows=6,858 width=360) (actual time=54.571..8,663.381 rows=10,145 loops=3)

16. 27.643 8,593.112 ↓ 1.5 10,145 3 / 3

Nested Loop (cost=879.34..1,234,404.73 rows=6,858 width=344) (actual time=54.481..8,593.112 rows=10,145 loops=3)

17. 121.708 8,484.306 ↓ 1.5 10,145 3 / 3

Hash Join (cost=878.92..1,231,310.68 rows=6,858 width=344) (actual time=54.366..8,484.306 rows=10,145 loops=3)

  • Hash Cond: ((organisation.organisation_id)::text = (acl_allowed_organisation.organisation_id)::text)
18. 353.655 8,362.501 ↑ 2.7 705,517 3 / 3

Hash Join (cost=874.60..1,226,243.37 rows=1,899,695 width=353) (actual time=34.815..8,362.501 rows=705,517 loops=3)

  • Hash Cond: ((brand.organisation_id)::text = (organisation.organisation_id)::text)
19. 365.929 8,008.551 ↑ 2.7 705,517 3 / 3

Hash Join (cost=860.37..1,221,166.14 rows=1,899,695 width=344) (actual time=34.481..8,008.551 rows=705,517 loops=3)

  • Hash Cond: ((portal.brand_id)::text = (brand.brand_id)::text)
20. 465.738 7,642.331 ↑ 2.7 705,517 3 / 3

Hash Join (cost=846.36..1,216,086.28 rows=1,899,695 width=344) (actual time=34.142..7,642.331 rows=705,517 loops=3)

  • Hash Cond: (user_game_activity.portal_id = portal.portal_id)
21. 352.681 7,156.147 ↑ 2.7 705,517 3 / 3

Hash Join (cost=153.75..1,210,405.49 rows=1,899,695 width=284) (actual time=13.552..7,156.147 rows=705,517 loops=3)

  • Hash Cond: ((game.category_id)::text = (game_category.category_id)::text)
22. 393.229 6,803.413 ↑ 2.7 705,517 3 / 3

Hash Join (cost=152.50..1,203,496.25 rows=1,899,695 width=274) (actual time=13.470..6,803.413 rows=705,517 loops=3)

  • Hash Cond: ((game.supplier_id)::text = (game_supplier.supplier_id)::text)
23. 379.145 6,410.127 ↑ 2.7 705,517 3 / 3

Hash Join (cost=150.82..1,197,803.41 rows=1,899,695 width=264) (actual time=13.376..6,410.127 rows=705,517 loops=3)

  • Hash Cond: (game_profile.game_id = game.game_id)
24. 399.892 6,028.800 ↑ 2.7 705,517 3 / 3

Hash Join (cost=61.37..1,192,709.95 rows=1,899,695 width=214) (actual time=11.161..6,028.800 rows=705,517 loops=3)

  • Hash Cond: (user_game_activity.game_profile_id = game_profile.game_profile_id)
25. 5,627.346 5,627.346 ↑ 2.7 705,517 3 / 3

Parallel Seq Scan on user_game_activity (cost=0.00..1,187,645.12 rows=1,899,695 width=199) (actual time=9.561..5,627.346 rows=705,517 loops=3)

  • Filter: ((interval_start_date >= '2019-09-01 11:00:00+00'::timestamp with time zone) AND (interval_end_date <= '2019-12-01 12:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 3846578
26. 0.478 1.562 ↑ 1.0 1,261 3 / 3

Hash (cost=45.61..45.61 rows=1,261 width=23) (actual time=1.561..1.562 rows=1,261 loops=3)

  • Buckets: 2048 Batches: 1 Memory Usage: 86kB
27. 1.084 1.084 ↑ 1.0 1,261 3 / 3

Seq Scan on game_profile (cost=0.00..45.61 rows=1,261 width=23) (actual time=0.037..1.084 rows=1,261 loops=3)

28. 0.651 2.182 ↑ 1.0 1,220 3 / 3

Hash (cost=74.20..74.20 rows=1,220 width=50) (actual time=2.182..2.182 rows=1,220 loops=3)

  • Buckets: 2048 Batches: 1 Memory Usage: 116kB
29. 1.531 1.531 ↑ 1.0 1,220 3 / 3

Seq Scan on game (cost=0.00..74.20 rows=1,220 width=50) (actual time=0.030..1.531 rows=1,220 loops=3)

30. 0.018 0.057 ↑ 1.0 30 3 / 3

Hash (cost=1.30..1.30 rows=30 width=27) (actual time=0.057..0.057 rows=30 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
31. 0.039 0.039 ↑ 1.0 30 3 / 3

Seq Scan on game_supplier (cost=0.00..1.30 rows=30 width=27) (actual time=0.029..0.039 rows=30 loops=3)

32. 0.014 0.053 ↑ 1.0 11 3 / 3

Hash (cost=1.11..1.11 rows=11 width=20) (actual time=0.052..0.053 rows=11 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
33. 0.039 0.039 ↑ 1.0 11 3 / 3

Seq Scan on game_category (cost=0.00..1.11 rows=11 width=20) (actual time=0.036..0.039 rows=11 loops=3)

34. 6.943 20.446 ↓ 1.0 14,411 3 / 3

Hash (cost=513.94..513.94 rows=14,294 width=68) (actual time=20.446..20.446 rows=14,411 loops=3)

  • Buckets: 16384 Batches: 1 Memory Usage: 1545kB
35. 13.503 13.503 ↓ 1.0 14,411 3 / 3

Seq Scan on portal (cost=0.00..513.94 rows=14,294 width=68) (actual time=0.038..13.503 rows=14,411 loops=3)

36. 0.085 0.291 ↑ 1.0 267 3 / 3

Hash (cost=10.67..10.67 rows=267 width=18) (actual time=0.291..0.291 rows=267 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 22kB
37. 0.206 0.206 ↑ 1.0 267 3 / 3

Seq Scan on brand (cost=0.00..10.67 rows=267 width=18) (actual time=0.035..0.206 rows=267 loops=3)

38. 0.087 0.295 ↑ 1.0 277 3 / 3

Hash (cost=10.77..10.77 rows=277 width=9) (actual time=0.295..0.295 rows=277 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 20kB
39. 0.208 0.208 ↑ 1.0 277 3 / 3

Seq Scan on organisation (cost=0.00..10.77 rows=277 width=9) (actual time=0.031..0.208 rows=277 loops=3)

40. 0.006 0.097 ↑ 1.0 1 3 / 3

Hash (cost=4.30..4.30 rows=1 width=9) (actual time=0.097..0.097 rows=1 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
41. 0.091 0.091 ↑ 1.0 1 3 / 3

Index Only Scan using pk_acl_allowed_organisation on acl_allowed_organisation (cost=0.28..4.30 rows=1 width=9) (actual time=0.089..0.091 rows=1 loops=3)

  • Index Cond: ((user_id = 197663) AND (permission = 'READ'::text))
  • Heap Fetches: 0
42. 81.163 81.163 ↑ 1.0 1 30,436 / 3

Index Scan using pk_user_registration on user_registration (cost=0.42..0.45 rows=1 width=16) (actual time=0.008..0.008 rows=1 loops=30,436)

  • Index Cond: (user_registration_id = user_game_activity.user_registration_id)
43. 50.727 50.727 ↑ 1.0 1 30,436 / 3

Index Scan using pk_users on users (cost=0.42..0.54 rows=1 width=24) (actual time=0.005..0.005 rows=1 loops=30,436)

  • Index Cond: (user_id = user_registration.user_id)
44. 0.087 0.969 ↓ 1.1 325 3 / 3

Hash (cost=49.51..49.51 rows=293 width=16) (actual time=0.969..0.969 rows=325 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 24kB
45. 0.228 0.882 ↓ 1.1 325 3 / 3

Hash Join (cost=21.81..49.51 rows=293 width=16) (actual time=0.382..0.882 rows=325 loops=3)

  • Hash Cond: (affiliate.affiliate_id = acl_allowed_affiliate.affiliate_id)
46. 0.344 0.344 ↑ 1.0 688 3 / 3

Seq Scan on affiliate (cost=0.00..25.88 rows=688 width=8) (actual time=0.035..0.344 rows=688 loops=3)

47. 0.058 0.310 ↓ 1.1 325 3 / 3

Hash (cost=18.15..18.15 rows=293 width=8) (actual time=0.310..0.310 rows=325 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 21kB
48. 0.252 0.252 ↓ 1.1 325 3 / 3

Index Only Scan using pk_acl_allowed_affiliate on acl_allowed_affiliate (cost=0.29..18.15 rows=293 width=8) (actual time=0.130..0.252 rows=325 loops=3)

  • Index Cond: ((user_id = 197663) AND (permission = 'READ'::text))
  • Heap Fetches: 6
49. 0.097 0.290 ↑ 1.0 269 3 / 3

Hash (cost=11.01..11.01 rows=270 width=18) (actual time=0.290..0.290 rows=269 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 22kB
50. 0.193 0.193 ↑ 1.0 269 3 / 3

Seq Scan on organisation_ancestor (cost=0.00..11.01 rows=270 width=18) (actual time=0.046..0.193 rows=269 loops=3)

  • Filter: nearest_billing_entity
  • Rows Removed by Filter: 332
51. 0.468 1.092 ↑ 1.0 1,220 1

Hash (cost=95.37..95.37 rows=1,226 width=8) (actual time=1.092..1.092 rows=1,220 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 64kB
52. 0.624 0.624 ↑ 1.0 1,220 1

Index Only Scan using pk_acl_allowed_game on acl_allowed_game (cost=0.42..95.37 rows=1,226 width=8) (actual time=0.040..0.624 rows=1,220 loops=1)

  • Index Cond: ((user_id = 197663) AND (permission = 'READ'::text))
  • Heap Fetches: 55
53. 0.027 0.045 ↑ 5.0 1 1

Sort (cost=1.11..1.12 rows=5 width=22) (actual time=0.045..0.045 rows=1 loops=1)

  • Sort Key: vip_schema.vip_schema_id
  • Sort Method: quicksort Memory: 25kB
54. 0.018 0.018 ↑ 1.0 5 1

Seq Scan on vip_schema (cost=0.00..1.05 rows=5 width=22) (actual time=0.016..0.018 rows=5 loops=1)

55. 5.532 3,766.506 ↓ 111.0 111 3

Execution Time: 9304.614 mse (cost=311,418.03..311,418.28 rows=1 width=1,098) (actual time=1,253.760..1,255.502 rows=111 loops=3)

  • Group Key: (timezone('Europe/London'::text, date_trunc('day'::text, timezone('Europe/London'::text, user_game_activity.interval_start_date)))), (timezone('Europe/London'::text, date_trunc('month'::text, timezone('Europe/London'::text, user_game_activity.interval_start_date)))), users.user_id, game_supplier.supplier_id, game_category.category_id, game.game_id, game_profile.game_profile_id, portal.portal_id, vip_level.vip_level_id, user_game_activity.client_mode, user_game_activity.play_mode, vip_schema.description
56. 209.583 3,760.974 ↓ 122.0 122 3

Sort (cost=311,418.03..311,418.04 rows=1 width=368) (actual time=1,253.628..1,253.658 rows=122 loops=3)

  • Sort Key: (timezone('Europe/London'::text, date_trunc('day'::text, timezone('Europe/London'::text, user_game_activity.interval_start_date)))), (timezone('Europe/London'::text, date_trunc('month'::text, timezone('Europe/London'::text, user_game_activity.interval_start_date)))), users.user_id, game_supplier.supplier_id, game_category.category_id, game.game_id, game_profile.game_profile_id, portal.portal_id, vip_level.vip_level_id, user_game_activity.client_mode, user_game_activity.play_mode, vip_schema.description
  • Sort Method: quicksort Memory: 11129kB
  • Worker 0: Sort Method: quicksort Memory: 5932kB
  • Worker 1: Sort Method: quicksort Memory: 6144kB
57. 255.479 3,551.391 ↓ 14,007.0 14,007 3

Nested Loop (cost=889.92..311,418.02 rows=1 width=368) (actual time=25.622..1,183.797 rows=14,007 loops=3)

58. 62.657 3,211.872 ↓ 14,007.0 14,007 3

Nested Loop (cost=889.79..311,417.21 rows=1 width=347) (actual time=25.237..1,070.624 rows=14,007 loops=3)

59. 78.889 3,065.175 ↓ 14,007.0 14,007 3

Nested Loop Left Join (cost=889.65..311,417.05 rows=1 width=335) (actual time=25.161..1,021.725 rows=14,007 loops=3)

60. 87.465 2,692.146 ↓ 14,007.0 14,007 3

Nested Loop (cost=889.37..311,416.58 rows=1 width=344) (actual time=25.067..897.382 rows=14,007 loops=3)

  • Join Filter: (game.game_id = acl_allowed_game.game_id)
61. 56.181 2,352.561 ↓ 14,007.0 14,007 3

Hash Join (cost=888.95..311,412.58 rows=1 width=352) (actual time=24.943..784.187 rows=14,007 loops=3)

  • Hash Cond: (users.affiliate_id = affiliate.affiliate_id)
62. 70.696 2,295.729 ↓ 63.1 14,007 3

Nested Loop (cost=880.32..311,403.11 rows=222 width=360) (actual time=24.627..765.243 rows=14,007 loops=3)

63. 92.972 1,804.833 ↓ 63.1 14,007 3

Nested Loop (cost=879.90..311,284.26 rows=222 width=344) (actual time=24.540..601.611 rows=14,007 loops=3)

64. 45.369 1,249.641 ↓ 63.1 14,007 3

Hash Join (cost=879.48..311,126.73 rows=222 width=344) (actual time=24.433..416.547 rows=14,007 loops=3)

  • Hash Cond: ((organisation.organisation_id)::text = (acl_allowed_organisation.organisation_id)::text)
65. 46.467 1,203.915 ↑ 3.8 16,242 3

Hash Join (cost=875.16..310,958.27 rows=61,588 width=353) (actual time=23.922..401.305 rows=16,242 loops=3)

  • Hash Cond: ((brand.organisation_id)::text = (organisation.organisation_id)::text)
66. 49.602 1,156.563 ↑ 3.8 16,242 3

Hash Join (cost=860.93..310,779.90 rows=61,588 width=344) (actual time=23.590..385.521 rows=16,242 loops=3)

  • Hash Cond: ((portal.brand_id)::text = (brand.brand_id)::text)
67. 54.474 1,105.968 ↑ 3.8 16,242 3

Hash Join (cost=846.92..310,601.66 rows=61,588 width=344) (actual time=23.223..368.656 rows=16,242 loops=3)

  • Hash Cond: (user_game_activity.portal_id = portal.portal_id)
68. 45.051 993.615 ↑ 3.8 16,242 3

Hash Join (cost=154.31..309,747.33 rows=61,588 width=284) (actual time=3.795..331.205 rows=16,242 loops=3)

  • Hash Cond: ((game.category_id)::text = (game_category.category_id)::text)
69. 54.444 948.420 ↑ 3.8 16,242 3

Hash Join (cost=153.06..309,522.12 rows=61,588 width=274) (actual time=3.713..316.140 rows=16,242 loops=3)

  • Hash Cond: ((game.supplier_id)::text = (game_supplier.supplier_id)::text)
70. 48.840 893.805 ↑ 3.8 16,242 3

Hash Join (cost=151.38..309,335.94 rows=61,588 width=264) (actual time=3.625..297.935 rows=16,242 loops=3)

  • Hash Cond: (game_profile.game_id = game.game_id)
71. 59.721 838.668 ↑ 3.8 16,242 3

Hash Join (cost=61.93..309,084.27 rows=61,588 width=214) (actual time=1.477..279.556 rows=16,242 loops=3)

  • Hash Cond: (user_game_activity.game_profile_id = game_profile.game_profile_id)
72. 774.840 774.840 ↑ 3.8 16,242 3

Parallel Index Scan using user_game_activity_pkey on user_game_activity (cost=0.56..308,860.68 rows=61,588 width=199) (actual time=0.077..258.280 rows=16,242 loops=3)

  • Index Cond: (interval_start_date >= '2020-05-18 16:00:00+00'::timestamp with time zone)
  • Filter: (interval_end_date <= '2020-05-19 16:00:00+00'::timestamp with time zone)
  • Rows Removed by Filter: 30682
73. 1.020 4.107 ↑ 1.0 1,261 3

Hash (cost=45.61..45.61 rows=1,261 width=23) (actual time=1.368..1.369 rows=1,261 loops=3)

  • Buckets: 2048 Batches: 1 Memory Usage: 86kB
74. 3.087 3.087 ↑ 1.0 1,261 3

Seq Scan on game_profile (cost=0.00..45.61 rows=1,261 width=23) (actual time=0.032..1.029 rows=1,261 loops=3)

75. 1.509 6.297 ↑ 1.0 1,220 3

Hash (cost=74.20..74.20 rows=1,220 width=50) (actual time=2.099..2.099 rows=1,220 loops=3)

  • Buckets: 2048 Batches: 1 Memory Usage: 116kB
76. 4.788 4.788 ↑ 1.0 1,220 3

Seq Scan on game (cost=0.00..74.20 rows=1,220 width=50) (actual time=0.028..1.596 rows=1,220 loops=3)

77. 0.054 0.171 ↑ 1.0 30 3

Hash (cost=1.30..1.30 rows=30 width=27) (actual time=0.057..0.057 rows=30 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
78. 0.117 0.117 ↑ 1.0 30 3

Seq Scan on game_supplier (cost=0.00..1.30 rows=30 width=27) (actual time=0.029..0.039 rows=30 loops=3)

79. 0.039 0.144 ↑ 1.0 11 3

Hash (cost=1.11..1.11 rows=11 width=20) (actual time=0.048..0.048 rows=11 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
80. 0.105 0.105 ↑ 1.0 11 3

Seq Scan on game_category (cost=0.00..1.11 rows=11 width=20) (actual time=0.032..0.035 rows=11 loops=3)

81. 17.409 57.879 ↓ 1.0 14,411 3

Hash (cost=513.94..513.94 rows=14,294 width=68) (actual time=19.293..19.293 rows=14,411 loops=3)

  • Buckets: 16384 Batches: 1 Memory Usage: 1545kB
82. 40.470 40.470 ↓ 1.0 14,411 3

Seq Scan on portal (cost=0.00..513.94 rows=14,294 width=68) (actual time=0.037..13.490 rows=14,411 loops=3)

83. 0.321 0.993 ↑ 1.0 267 3

Hash (cost=10.67..10.67 rows=267 width=18) (actual time=0.331..0.331 rows=267 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 22kB
84. 0.672 0.672 ↑ 1.0 267 3

Seq Scan on brand (cost=0.00..10.67 rows=267 width=18) (actual time=0.040..0.224 rows=267 loops=3)

85. 0.252 0.885 ↑ 1.0 277 3

Hash (cost=10.77..10.77 rows=277 width=9) (actual time=0.295..0.295 rows=277 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 20kB
86. 0.633 0.633 ↑ 1.0 277 3

Seq Scan on organisation (cost=0.00..10.77 rows=277 width=9) (actual time=0.037..0.211 rows=277 loops=3)

87. 0.021 0.357 ↑ 1.0 1 3

Hash (cost=4.30..4.30 rows=1 width=9) (actual time=0.119..0.119 rows=1 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
88. 0.336 0.336 ↑ 1.0 1 3

Index Only Scan using pk_acl_allowed_organisation on acl_allowed_organisation (cost=0.28..4.30 rows=1 width=9) (actual time=0.111..0.112 rows=1 loops=3)

  • Index Cond: ((user_id = 2168379) AND (permission = 'READ'::text))
  • Heap Fetches: 3
89. 462.220 462.220 ↑ 1.0 1 42,020

Index Scan using pk_user_registration on user_registration (cost=0.42..0.71 rows=1 width=16) (actual time=0.011..0.011 rows=1 loops=42,020)

  • Index Cond: (user_registration_id = user_game_activity.user_registration_id)
90. 420.200 420.200 ↑ 1.0 1 42,020

Index Scan using pk_users on users (cost=0.42..0.54 rows=1 width=24) (actual time=0.010..0.010 rows=1 loops=42,020)

  • Index Cond: (user_id = user_registration.user_id)
91. 0.042 0.651 ↑ 1.0 1 3

Hash (cost=8.61..8.61 rows=1 width=16) (actual time=0.216..0.217 rows=1 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
92. 0.021 0.609 ↑ 1.0 1 3

Nested Loop (cost=0.56..8.61 rows=1 width=16) (actual time=0.202..0.203 rows=1 loops=3)

93. 0.393 0.393 ↑ 1.0 1 3

Index Only Scan using pk_acl_allowed_affiliate on acl_allowed_affiliate (cost=0.29..4.31 rows=1 width=8) (actual time=0.130..0.131 rows=1 loops=3)

  • Index Cond: ((user_id = 2168379) AND (permission = 'READ'::text))
  • Heap Fetches: 3
94. 0.195 0.195 ↑ 1.0 1 3

Index Only Scan using pk_affiliate on affiliate (cost=0.28..4.29 rows=1 width=8) (actual time=0.065..0.065 rows=1 loops=3)

  • Index Cond: (affiliate_id = acl_allowed_affiliate.affiliate_id)
  • Heap Fetches: 0
95. 252.120 252.120 ↑ 1.0 1 42,020

Index Only Scan using pk_acl_allowed_game on acl_allowed_game (cost=0.42..3.98 rows=1 width=8) (actual time=0.006..0.006 rows=1 loops=42,020)

  • Index Cond: ((user_id = 2168379) AND (game_id = game_profile.game_id) AND (permission = 'READ'::text))
  • Heap Fetches: 42020
96. 294.140 294.140 ↑ 1.0 1 42,020

Index Scan using organisation_ancestor_unq02 on organisation_ancestor (cost=0.28..0.47 rows=1 width=18) (actual time=0.005..0.007 rows=1 loops=42,020)

  • Index Cond: ((organisation_id)::text = (organisation.organisation_id)::text)
  • Filter: nearest_billing_entity
  • Rows Removed by Filter: 1
97. 84.040 84.040 ↑ 1.0 1 42,020

Index Scan using pk_vip_level on vip_level (cost=0.14..0.16 rows=1 width=20) (actual time=0.002..0.002 rows=1 loops=42,020)

  • Index Cond: (vip_level_id = user_game_activity.vip_level_id)
98. 84.040 84.040 ↑ 1.0 1 42,020

Index Scan using pk_vip_schema on vip_schema (cost=0.13..0.63 rows=1 width=22) (actual time=0.002..0.002 rows=1 loops=42,020)

  • Index Cond: ((vip_schema_id)::text = (vip_level.vip_schema_id)::text)
Planning time : 49.770 ms
Execution time : 1,316.476 ms