SQL Report


Page generated in 2.1366 seconds with 25 queries + 4 queries returning data from cache

Time spent on postgres queries: 0.95697s | Time spent on PHP: 1.17962s



Query #1
QUERY PLAN
Seq Scan on phpbb_config (cost=0.00..9.53 rows=28 width=22)
Filter: (is_dynamic = 1)

Before: 0.18319s | After: 0.21918s | Elapsed: 0.03599s



Query #2
QUERY PLAN
Index Scan using phpbb_users_pkey on phpbb_users (cost=0.28..8.29 rows=1 width=905)
Index Cond: (user_id = 1)

Before: 0.25919s | After: 0.29534s | Elapsed: 0.03615s



Query results obtained from the cache

Before: 0.33221s | After: 0.33235s | Elapsed [cache]: 0.00014s | Elapsed [db]: 0.03590s



Query #4
QUERY PLAN
Index Scan using phpbb_config_pkey on phpbb_config (cost=0.27..8.29 rows=1 width=24)
Index Cond: ((config_name)::text = 'rand_seed_last_update'::text)

Affected rows: 1 | Before: 0.36860s | After: 0.40600s | Elapsed: 0.03740s



Query #5
QUERY PLAN
Index Scan using phpbb_config_pkey on phpbb_config (cost=0.27..8.29 rows=1 width=24)
Index Cond: ((config_name)::text = 'rand_seed'::text)

Affected rows: 1 | Before: 0.44205s | After: 0.48028s | Elapsed: 0.03823s



Query #6

Before: 0.48041s | After: 0.51717s | Elapsed: 0.03675s



Query #7
QUERY PLAN
Aggregate (cost=10817.88..10817.89 rows=1 width=8)
-> Seq Scan on pin_session (cost=0.00..10817.84 rows=12 width=33)
Filter: ((update_time >= 1606265878) AND (uid = 1))

Before: 0.55373s | After: 0.63257s | Elapsed: 0.07884s



Query results obtained from the cache

Before: 0.67045s | After: 0.67057s | Elapsed [cache]: 0.00012s | Elapsed [db]: 0.03596s



Query #9
QUERY PLAN
Index Scan using phpbb_users_pkey on phpbb_users (cost=0.28..8.29 rows=1 width=905)
Index Cond: (user_id = 2)

Before: 0.70715s | After: 0.74323s | Elapsed: 0.03608s



Query #10
QUERY PLAN
Hash Join (cost=10.68..38.30 rows=4 width=526)
Hash Cond: (ug.group_id = g.group_id)
-> Seq Scan on phpbb_user_group ug (cost=0.00..27.57 rows=4 width=8)
Filter: ((user_id = ANY ('{2,1}'::integer[])) AND (user_pending = 0))
-> Hash (cost=10.30..10.30 rows=30 width=522)
-> Seq Scan on phpbb_groups g (cost=0.00..10.30 rows=30 width=522)

Before: 0.77982s | After: 0.81602s | Elapsed: 0.03620s



Query #11
QUERY PLAN
Seq Scan on phpbb_zebra (cost=0.00..40.60 rows=1 width=4)
Filter: ((zebra_id = 2) AND (user_id = 1))

Before: 0.85273s | After: 0.88855s | Elapsed: 0.03582s



Query #12
QUERY PLAN
Aggregate (cost=219.72..219.73 rows=1 width=10)
-> Seq Scan on phpbb_sessions (cost=0.00..219.71 rows=1 width=10)
Filter: (session_user_id = 2)

Before: 0.92495s | After: 0.96178s | Elapsed: 0.03683s



Query #13
QUERY PLAN
Nested Loop Left Join (cost=0.00..26.40 rows=9 width=8)
Join Filter: (fa.forum_id = f.forum_id)
-> Seq Scan on phpbb_forums f (cost=0.00..10.12 rows=9 width=4)
Filter: ((forum_password)::text <> ''::text)
-> Materialize (cost=0.00..16.01 rows=2 width=8)
-> Seq Scan on phpbb_forums_access fa (cost=0.00..16.00 rows=2 width=8)
Filter: (session_id = '000878f39c689118dbd0c42b25f48607'::bpchar)

Before: 0.99874s | After: 1.03474s | Elapsed: 0.03600s



Query #14
QUERY PLAN
Limit (cost=596.92..596.93 rows=1 width=12)
-> Sort (cost=596.92..597.00 rows=31 width=12)
Sort Key: (count(post_id)) DESC
-> GroupAggregate (cost=595.47..596.77 rows=31 width=12)
Group Key: forum_id
-> Sort (cost=595.47..595.80 rows=132 width=8)
Sort Key: forum_id
-> Seq Scan on phpbb_posts (cost=0.00..590.82 rows=132 width=8)
Filter: ((poster_id = 2) AND (post_postcount = 1) AND (post_visibility = 1) AND (forum_id = ANY ('{1,2,3,4,5,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42}'::integer[])))

Before: 1.07167s | After: 1.10966s | Elapsed: 0.03799s



Query results obtained from the cache

Before: 1.14582s | After: 1.14597s | Elapsed [cache]: 0.00015s | Elapsed [db]: 0.03590s



Query #16
QUERY PLAN
Limit (cost=598.41..598.41 rows=1 width=12)
-> Sort (cost=598.41..598.73 rows=130 width=12)
Sort Key: (count(post_id)) DESC
-> GroupAggregate (cost=595.47..597.76 rows=130 width=12)
Group Key: topic_id
-> Sort (cost=595.47..595.80 rows=132 width=8)
Sort Key: topic_id
-> Seq Scan on phpbb_posts (cost=0.00..590.82 rows=132 width=8)
Filter: ((poster_id = 2) AND (post_postcount = 1) AND (post_visibility = 1) AND (forum_id = ANY ('{1,2,3,4,5,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42}'::integer[])))

Before: 1.18246s | After: 1.22019s | Elapsed: 0.03773s



Query #17
QUERY PLAN
Seq Scan on phpbb_topics (cost=0.00..135.10 rows=1 width=55)
Filter: (topic_id = 248)

Before: 1.25661s | After: 1.29302s | Elapsed: 0.03642s



Query #18
QUERY PLAN
Seq Scan on phpbb_lang (cost=0.00..10.62 rows=1 width=2)
Filter: ((lang_iso)::text = 'zh-cn'::text)

Before: 1.32965s | After: 1.36557s | Elapsed: 0.03592s



Query #19
QUERY PLAN
Sort (cost=21.07..21.08 rows=1 width=5194)
Sort Key: f.field_order
-> Nested Loop (cost=0.00..21.06 rows=1 width=5194)
Join Filter: (l.field_id = f.field_id)
-> Seq Scan on phpbb_profile_lang l (cost=0.00..10.88 rows=1 width=1072)
Filter: (lang_id = 3)
-> Seq Scan on phpbb_profile_fields f (cost=0.00..10.18 rows=1 width=4122)
Filter: ((field_active = 1) AND (field_hide = 0) AND (field_no_view = 0))

Before: 1.40221s | After: 1.43851s | Elapsed: 0.03630s



Query #20
QUERY PLAN
Seq Scan on phpbb_profile_fields_data (cost=0.00..10.12 rows=1 width=5744)
Filter: (user_id = 2)

Before: 1.47483s | After: 1.51076s | Elapsed: 0.03594s



Query #21
QUERY PLAN
Nested Loop (cost=0.00..4.30 rows=1 width=24)
Join Filter: (a.auth_option_id = ao.auth_option_id)
-> Seq Scan on phpbb_acl_users a (cost=0.00..1.45 rows=1 width=14)
Filter: ((auth_role_id = 0) AND (user_id = 2))
-> Seq Scan on phpbb_acl_options ao (cost=0.00..2.84 rows=1 width=14)
Filter: ((auth_option)::text = 'u_readpm'::text)

Before: 1.54822s | After: 1.58434s | Elapsed: 0.03613s



Query #22
QUERY PLAN
Nested Loop (cost=4.30..11.71 rows=1 width=28)
Join Filter: (r.role_id = a.auth_role_id)
-> Seq Scan on phpbb_acl_users a (cost=0.00..1.38 rows=1 width=12)
Filter: (user_id = 2)
-> Nested Loop (cost=4.30..10.30 rows=3 width=20)
-> Seq Scan on phpbb_acl_options ao (cost=0.00..2.84 rows=1 width=14)
Filter: ((auth_option)::text = 'u_readpm'::text)
-> Bitmap Heap Scan on phpbb_acl_roles_data r (cost=4.30..7.43 rows=3 width=10)
Recheck Cond: (auth_option_id = ao.auth_option_id)
-> Bitmap Index Scan on ath_op_id (cost=0.00..4.29 rows=3 width=0)
Index Cond: (auth_option_id = ao.auth_option_id)

Before: 1.62100s | After: 1.65725s | Elapsed: 0.03624s



Query #23
QUERY PLAN
Nested Loop (cost=10.82..46.95 rows=1 width=24)
Join Filter: (a.auth_option_id = ao.auth_option_id)
-> Seq Scan on phpbb_acl_options ao (cost=0.00..2.84 rows=1 width=14)
Filter: ((auth_option)::text = 'u_readpm'::text)
-> Nested Loop (cost=10.82..43.73 rows=30 width=14)
Join Filter: (ug.group_id = a.group_id)
-> Hash Join (cost=10.68..38.31 rows=3 width=12)
Hash Cond: (ug.group_id = g.group_id)
Join Filter: ((ug.group_leader <> 1) OR (g.group_skip_auth <> 1))
-> Seq Scan on phpbb_user_group ug (cost=0.00..27.57 rows=3 width=10)
Filter: ((user_pending = 0) AND (user_id = 2))
-> Hash (cost=10.30..10.30 rows=30 width=6)
-> Seq Scan on phpbb_groups g (cost=0.00..10.30 rows=30 width=6)
-> Index Scan using group_id on phpbb_acl_groups a (cost=0.15..1.73 rows=6 width=14)
Index Cond: (group_id = g.group_id)
Filter: (auth_role_id = 0)

Before: 1.69430s | After: 1.73113s | Elapsed: 0.03683s



Query #24
QUERY PLAN
Hash Join (cost=24.35..52.24 rows=22 width=24)
Hash Cond: (ug.group_id = a.group_id)
-> Hash Join (cost=10.68..38.31 rows=3 width=12)
Hash Cond: (ug.group_id = g.group_id)
Join Filter: ((ug.group_leader <> 1) OR (g.group_skip_auth <> 1))
-> Seq Scan on phpbb_user_group ug (cost=0.00..27.57 rows=3 width=10)
Filter: ((user_pending = 0) AND (user_id = 2))
-> Hash (cost=10.30..10.30 rows=30 width=6)
-> Seq Scan on phpbb_groups g (cost=0.00..10.30 rows=30 width=6)
-> Hash (cost=13.29..13.29 rows=31 width=24)
-> Nested Loop (cost=4.44..13.29 rows=31 width=24)
-> Nested Loop (cost=4.30..10.30 rows=3 width=20)
-> Seq Scan on phpbb_acl_options ao (cost=0.00..2.84 rows=1 width=14)
Filter: ((auth_option)::text = 'u_readpm'::text)
-> Bitmap Heap Scan on phpbb_acl_roles_data r (cost=4.30..7.43 rows=3 width=10)
Recheck Cond: (auth_option_id = ao.auth_option_id)
-> Bitmap Index Scan on ath_op_id (cost=0.00..4.29 rows=3 width=0)
Index Cond: (auth_option_id = ao.auth_option_id)
-> Index Scan using auth_role_id on phpbb_acl_groups a (cost=0.15..0.70 rows=29 width=12)
Index Cond: (auth_role_id = r.role_id)

Before: 1.76823s | After: 1.80598s | Elapsed: 0.03775s



Query #25
QUERY PLAN
Seq Scan on phpbb_banlist (cost=0.00..10.88 rows=1 width=4)
Filter: ((ban_exclude <> 1) AND (ban_userid = 2) AND (ban_end = 0))

Before: 1.84206s | After: 1.87796s | Elapsed: 0.03590s



Query #26
QUERY PLAN
Seq Scan on phpbb_points (cost=0.00..10.70 rows=70 width=1064)

Before: 1.91411s | After: 1.94990s | Elapsed: 0.03579s



Query #27
QUERY PLAN
Seq Scan on phpbb_bank (cost=0.00..20.62 rows=4 width=8)
Filter: (user_id = 2)

Before: 1.98650s | After: 2.02247s | Elapsed: 0.03597s



Query #28
QUERY PLAN
Aggregate (cost=365.02..365.03 rows=1 width=8)
-> Seq Scan on phpbb_posts (cost=0.00..365.01 rows=1 width=4)
Filter: ((post_visibility = ANY ('{0,3}'::integer[])) AND (poster_id = 2))

Before: 2.06012s | After: 2.09789s | Elapsed: 0.03777s



Query results obtained from the cache

Before: 2.13549s | After: 2.13565s | Elapsed [cache]: 0.00017s | Elapsed [db]: 0.04374s