SQL Report


Page generated in 1.6139 seconds with 25 queries + 5 queries returning data from cache

Time spent on postgres queries: 1.08641s | Time spent on PHP: 0.52752s



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

Before: 0.04946s | After: 0.05132s | Elapsed: 0.00186s



Query #2
QUERY PLAN
Nested Loop (cost=0.69..16.73 rows=1 width=1461)
-> Index Scan using pin_session_pkey on pin_session s (cost=0.41..8.43 rows=1 width=527)
Index Cond: (session_id = 'bc09823b0c438a739f4a16ff5b0e5be6'::text)
-> Index Scan using phpbb_users_pkey on phpbb_users u (cost=0.28..8.29 rows=1 width=934)
Index Cond: (user_id = s.uid)

Before: 0.19288s | After: 0.19774s | Elapsed: 0.00486s



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

Before: 0.20191s | After: 0.20227s | Elapsed: 0.00035s



Query results obtained from the cache

Before: 0.20634s | After: 0.28745s | Elapsed [cache]: 0.08111s | Elapsed [db]: 0.00742s



Query #5

Affected rows: 0 | Before: 0.28771s | After: 0.28803s | Elapsed: 0.00032s



Query #6
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.29030s | After: 0.38556s | Elapsed: 0.09525s



Query #7
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.38601s | After: 0.38778s | Elapsed: 0.00177s



Query #8

Before: 0.38788s | After: 0.39268s | Elapsed: 0.00480s



Query #9
QUERY PLAN
Aggregate (cost=4557.65..4557.66 rows=1 width=8)
-> Seq Scan on pin_session (cost=0.00..4556.47 rows=472 width=33)
Filter: ((update_time >= 1624282540) AND (uid = 1))

Before: 0.40127s | After: 1.09532s | Elapsed: 0.69405s



Query results obtained from the cache

Before: 1.11664s | After: 1.11673s | Elapsed [cache]: 0.00009s | Elapsed [db]: 0.00508s



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

Before: 1.12060s | After: 1.12224s | Elapsed: 0.00164s



Query #12
QUERY PLAN
Hash Join (cost=8.31..12.12 rows=1 width=5279)
Hash Cond: (f.forum_id = t.forum_id)
-> Seq Scan on phpbb_forums f (cost=0.00..3.63 rows=63 width=5008)
-> Hash (cost=8.30..8.30 rows=1 width=271)
-> Index Scan using phpbb_topics_pkey on phpbb_topics t (cost=0.28..8.30 rows=1 width=271)
Index Cond: (topic_id = 3556)

Before: 1.13680s | After: 1.14139s | Elapsed: 0.00458s



Query results obtained from the cache

Before: 1.14216s | After: 1.14224s | Elapsed [cache]: 0.00008s | Elapsed [db]: 0.00022s



Query results obtained from the cache

Before: 1.17664s | After: 1.17996s | Elapsed [cache]: 0.00332s | Elapsed [db]: 0.00062s



Query #15
QUERY PLAN
Limit (cost=364.98..364.99 rows=1 width=12)
-> Sort (cost=364.98..364.99 rows=1 width=12)
Sort Key: post_time, post_id
-> Seq Scan on phpbb_posts p (cost=0.00..364.97 rows=1 width=12)
Filter: ((topic_id = 3556) AND (post_visibility = 1))

Before: 1.19063s | After: 1.38240s | Elapsed: 0.19177s



Query #16
QUERY PLAN
Nested Loop Left Join (cost=0.56..52.23 rows=1 width=1472)
Join Filter: (z.zebra_id = p.poster_id)
-> Nested Loop (cost=0.56..16.61 rows=1 width=1468)
-> Index Scan using phpbb_posts_pkey on phpbb_posts p (cost=0.28..8.30 rows=1 width=534)
Index Cond: (post_id = 5412)
-> Index Scan using phpbb_users_pkey on phpbb_users u (cost=0.28..8.29 rows=1 width=934)
Index Cond: (user_id = p.poster_id)
-> Seq Scan on phpbb_zebra z (cost=0.00..35.50 rows=10 width=8)
Filter: (user_id = 1)

Before: 1.39254s | After: 1.39763s | Elapsed: 0.00510s



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

Before: 1.40098s | After: 1.40249s | Elapsed: 0.00151s



Query #18
QUERY PLAN
Sort (cost=12.09..12.10 rows=1 width=5194)
Sort Key: f.field_order
-> Nested Loop (cost=0.00..12.08 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..1.20 rows=1 width=4122)
Filter: ((field_active = 1) AND (field_no_view = 0))

Before: 1.40485s | After: 1.40652s | Elapsed: 0.00167s



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

Before: 1.40710s | After: 1.40853s | Elapsed: 0.00143s



Query #20
QUERY PLAN
GroupAggregate (cost=0.00..219.73 rows=1 width=14)
Group Key: session_user_id
-> Seq Scan on phpbb_sessions (cost=0.00..219.71 rows=1 width=14)
Filter: (session_user_id = 53)

Before: 1.47774s | After: 1.49389s | Elapsed: 0.01615s



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 = 53))
-> 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.51252s | After: 1.51789s | Elapsed: 0.00538s



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 = 53)
-> 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.52761s | After: 1.52810s | Elapsed: 0.00049s



Query #23
QUERY PLAN
Nested Loop (cost=2.98..38.05 rows=1 width=24)
Join Filter: ((ug.group_leader <> 1) OR (g.group_skip_auth <> 1))
-> Nested Loop (cost=2.85..37.60 rows=1 width=34)
Join Filter: (a.group_id = ug.group_id)
-> Hash Join (cost=2.85..9.98 rows=1 width=24)
Hash Cond: (a.auth_option_id = ao.auth_option_id)
-> Seq Scan on phpbb_acl_groups a (cost=0.00..7.03 rows=41 width=14)
Filter: (auth_role_id = 0)
-> Hash (cost=2.84..2.84 rows=1 width=14)
-> Seq Scan on phpbb_acl_options ao (cost=0.00..2.84 rows=1 width=14)
Filter: ((auth_option)::text = 'u_readpm'::text)
-> Seq Scan on phpbb_user_group ug (cost=0.00..27.57 rows=3 width=10)
Filter: ((user_pending = 0) AND (user_id = 53))
-> Index Scan using phpbb_groups_pkey on phpbb_groups g (cost=0.13..0.44 rows=1 width=6)
Index Cond: (group_id = a.group_id)

Before: 1.54127s | After: 1.55800s | Elapsed: 0.01673s



Query #24
QUERY PLAN
Hash Join (cost=14.83..42.67 rows=22 width=24)
Hash Cond: (ug.group_id = a.group_id)
-> Hash Join (cost=1.16..28.74 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 = 53))
-> Hash (cost=1.07..1.07 rows=7 width=6)
-> Seq Scan on phpbb_groups g (cost=0.00..1.07 rows=7 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.55944s | After: 1.56058s | Elapsed: 0.00114s



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

Before: 1.56100s | After: 1.56113s | Elapsed: 0.00013s



Query #26
QUERY PLAN
Seq Scan on phpbb_bank (cost=0.00..1.23 rows=1 width=8)
Filter: (user_id = 53)

Before: 1.57136s | After: 1.59269s | Elapsed: 0.02134s



Query #27
QUERY PLAN
Index Scan using phpbb_topics_pkey on phpbb_topics (cost=0.28..8.30 rows=1 width=271)
Index Cond: (topic_id = 3556)

Affected rows: 1 | Before: 1.59371s | After: 1.60558s | Elapsed: 0.01187s



Query #28
QUERY PLAN
Aggregate (cost=244.40..244.41 rows=1 width=8)
-> Seq Scan on phpbb_sessions s (cost=0.00..244.40 rows=1 width=13)
Filter: ((session_time >= 1624289400) AND (session_user_id = 1) AND (session_forum_id = 2))

Before: 1.60886s | After: 1.61008s | Elapsed: 0.00122s



Query #29
QUERY PLAN
Seq Scan on phpbb_sessions s (cost=0.00..244.40 rows=1 width=19)
Filter: ((session_time >= 1624289430) AND (session_user_id <> 1) AND (session_forum_id = 2))

Before: 1.61047s | After: 1.61147s | Elapsed: 0.00100s



Query results obtained from the cache

Before: 1.61312s | After: 1.61329s | Elapsed [cache]: 0.00017s | Elapsed [db]: 0.00032s