Explain plan
1
Query plan  Aggregate (cost=350.10..350.11 rows=1 width=0)
2
Query plan  -> GroupAggregate (cost=173.44..338.00 rows=968 width=393)
3
Query plan  -> Sort (cost=173.44..175.86 rows=968 width=393)
4
Query plan  Sort Key: ?
5
Query plan  -> Hash Left Join (cost=88.66..125.43 rows=968 width=393)
6
Query plan  Hash Cond: ?
7
Query plan  -> Hash Right Join (cost=83.92..107.38 rows=968 width=365)
8
Query plan  Hash Cond: ?
9
Query plan  -> Seq Scan on first_position (cost=0.00..11.52 rows=452 width=17)
10
Query plan  -> Hash (cost=82.02..82.02 rows=152 width=352)
11
Query plan  -> Hash Right Join (cost=73.25..82.02 rows=152 width=352)
12
Query plan  Hash Cond: ?
13
Query plan  -> Seq Scan on social_subscription (cost=0.00..6.09 rows=309 width=8)
14
Query plan  -> Hash (cost=72.82..72.82 rows=34 width=348)
15
Query plan  -> Hash Left Join (cost=67.61..72.82 rows=34 width=348)
16
Query plan  Hash Cond: ?
17
Query plan  -> Hash Right Join (cost=65.87..70.50 rows=34 width=344)
18
Query plan  Hash Cond: ?
19
Query plan  -> Seq Scan on "authUsers_user" (cost=0.00..3.94 rows=94 width=177)
20
Query plan  -> Hash (cost=65.44..65.44 rows=34 width=167)
21
Query plan  -> Hash Join (cost=61.99..65.44 rows=34 width=167)
22
Query plan  Hash Cond: ?
23
Query plan  -> Seq Scan on social_socialprofile (cost=0.00..2.86 rows=67 width=66)
24
Query plan  Filter: ?
25
Query plan  -> Hash (cost=61.54..61.54 rows=36 width=101)
26
Query plan  -> Hash Join (cost=59.20..61.54 rows=36 width=101)
27
Query plan  Hash Cond: ?
28
Query plan  -> Seq Scan on minor_accountperformance (cost=0.00..1.71 rows=71 width=42)
29
Query plan  -> Hash (cost=58.75..58.75 rows=36 width=59)
30
Query plan  -> Hash Right Join (cost=56.41..58.75 rows=36 width=59)
31
Query plan  Hash Cond: ?
32
Query plan  -> Seq Scan on first_account (cost=0.00..1.71 rows=71 width=43)
33
Query plan  -> Hash (cost=55.96..55.96 rows=36 width=16)
34
Query plan  -> Seq Scan on aggregate_apps_mainaccount (cost=54.08..55.96 rows=36 width=16)
35
Query plan  Filter: ?
36
Query plan  SubPlan 1
37
Query plan  -> Hash Right Join (cost=2.60..54.07 rows=1 width=4)
38
Query plan  Hash Cond: ?
39
Query plan  Filter: ?
40
Query plan  -> Seq Scan on first_order u2 (cost=0.00..34.99 rows=1199 width=8)
41
Query plan  -> Hash (cost=1.71..1.71 rows=71 width=4)
42
Query plan  -> Seq Scan on first_account u1 (cost=0.00..1.71 rows=71 width=4)
43
Query plan  -> Hash (cost=1.33..1.33 rows=33 width=8)
44
Query plan  -> Seq Scan on social_follow (cost=0.00..1.33 rows=33 width=8)
45uery plan -> Seq Scan on first_account u1 (cost=0.00..1.71 rows=71 width=4)
43
Query plan  -> Hash (cost=1.33..1.33 rows=33 width=8)
44
Query plan  -> Seq Scan on social_follow (cost=0.00..1.33 rows=33 width=8)
45
Query plan  -> Hash (cost=3.22..3.22 rows=122 width=28)
46
Query plan  -> Seq Scan on performance_periodicgain (cost=0.00..3.22 rows=122 width=28)

Query plan  -> Hash (cost=3.22..3.22 rows=122 width=28)
46
Query plan  -> Seq Scan on performance_periodicgain (cost=0.00..3.22 rows=122 width=28)