SQL Report


Page generated in 2.5845 seconds with 24 queries + 4 queries returning data from cache

Time spent on postgres queries: 1.08382s | Time spent on PHP: 1.50072s



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

Before: 0.22248s | After: 0.26626s | Elapsed: 0.04378s



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.36176s | After: 0.40569s | Elapsed: 0.04393s



Query results obtained from the cache

Before: 0.45047s | After: 0.45058s | Elapsed [cache]: 0.00011s | Elapsed [db]: 0.04373s



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.49459s | After: 0.53981s | Elapsed: 0.04522s



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.58358s | After: 0.62855s | Elapsed: 0.04497s



Query #6

Before: 0.62867s | After: 0.67388s | Elapsed: 0.04521s



Query #7
QUERY PLAN
Aggregate (cost=1967.19..1967.20 rows=1 width=8)
-> Seq Scan on pin_session (cost=0.00..1965.86 rows=536 width=33)
Filter: ((update_time >= 1610827148) AND (uid = 1))

Before: 0.71810s | After: 0.77271s | Elapsed: 0.05461s



Query results obtained from the cache

Before: 0.81848s | After: 0.81864s | Elapsed [cache]: 0.00016s | Elapsed [db]: 0.04370s



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

Before: 0.86448s | After: 0.90808s | Elapsed: 0.04360s



Query #10
QUERY PLAN
Nested Loop (cost=0.00..145.29 rows=1 width=5279)
Join Filter: (f.forum_id = t.forum_id)
-> Seq Scan on phpbb_topics t (cost=0.00..135.06 rows=1 width=271)
Filter: (topic_id = 512)
-> Seq Scan on phpbb_forums f (cost=0.00..10.10 rows=10 width=5008)

Before: 0.95298s | After: 0.99762s | Elapsed: 0.04464s



Query results obtained from the cache

Before: 1.06549s | After: 1.06564s | Elapsed [cache]: 0.00015s | Elapsed [db]: 0.04366s



Query #12
QUERY PLAN
Nested Loop Left Join (cost=0.28..29.86 rows=1 width=1077)
Join Filter: (m.group_id = g.group_id)
-> Nested Loop Left Join (cost=0.28..19.18 rows=1 width=1047)
-> Seq Scan on phpbb_moderator_cache m (cost=0.00..10.88 rows=1 width=1046)
Filter: (display_on_index = 1)
-> Index Scan using phpbb_users_pkey on phpbb_users u (cost=0.28..8.29 rows=1 width=5)
Index Cond: (user_id = m.user_id)
-> Seq Scan on phpbb_groups g (cost=0.00..10.30 rows=30 width=34)

Before: 1.12402s | After: 1.17619s | Elapsed: 0.05216s



Query #13
QUERY PLAN
Limit (cost=365.02..365.03 rows=1 width=12)
-> Sort (cost=365.02..365.03 rows=1 width=12)
Sort Key: post_time, post_id
-> Seq Scan on phpbb_posts p (cost=0.00..365.01 rows=1 width=12)
Filter: ((topic_id = 512) AND (post_visibility = 1))

Before: 1.22537s | After: 1.27066s | Elapsed: 0.04529s



Query #14
QUERY PLAN
Nested Loop Left Join (cost=0.28..398.44 rows=1 width=1443)
Join Filter: (z.zebra_id = p.poster_id)
-> Nested Loop (cost=0.28..362.82 rows=1 width=1439)
-> Seq Scan on phpbb_posts p (cost=0.00..354.51 rows=1 width=534)
Filter: (post_id = 558)
-> Index Scan using phpbb_users_pkey on phpbb_users u (cost=0.28..8.29 rows=1 width=905)
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.31580s | After: 1.36096s | Elapsed: 0.04516s



Query #15
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.42151s | After: 1.46518s | Elapsed: 0.04368s



Query #16
QUERY PLAN
Sort (cost=21.05..21.05 rows=1 width=5194)
Sort Key: f.field_order
-> Nested Loop (cost=0.00..21.04 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.15 rows=1 width=4122)
Filter: ((field_active = 1) AND (field_no_view = 0))

Before: 1.50943s | After: 1.55336s | Elapsed: 0.04393s



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

Before: 1.59736s | After: 1.64113s | Elapsed: 0.04376s



Query #18
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.68551s | After: 1.73020s | Elapsed: 0.04469s



Query #19
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.77451s | After: 1.81839s | Elapsed: 0.04388s



Query #20
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.86308s | After: 1.90704s | Elapsed: 0.04396s



Query #21
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 = 53))
-> 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.95217s | After: 1.99652s | Elapsed: 0.04435s



Query #22
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 = 53))
-> 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: 2.04132s | After: 2.08582s | Elapsed: 0.04450s



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

Before: 2.12984s | After: 2.17360s | Elapsed: 0.04376s



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

Before: 2.22562s | After: 2.26935s | Elapsed: 0.04373s



Query #25
QUERY PLAN
Seq Scan on phpbb_topics (cost=0.00..135.06 rows=1 width=271)
Filter: (topic_id = 512)

Affected rows: 1 | Before: 2.31358s | After: 2.35914s | Elapsed: 0.04557s



Query #26
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 >= 1610834040) AND (session_user_id = 1) AND (session_forum_id = 19))

Before: 2.40383s | After: 2.44859s | Elapsed: 0.04476s



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

Before: 2.49255s | After: 2.53726s | Elapsed: 0.04471s



Query results obtained from the cache

Before: 2.58237s | After: 2.58391s | Elapsed [cache]: 0.00154s | Elapsed [db]: 0.04378s