SQL Report


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

Time spent on postgres queries: 0.04978s | Time spent on PHP: 0.04089s



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

Before: 0.00413s | After: 0.00434s | Elapsed: 0.00020s



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.00795s | After: 0.00822s | Elapsed: 0.00027s



Query results obtained from the cache

Before: 0.00907s | After: 0.00912s | Elapsed [cache]: 0.00006s | Elapsed [db]: 0.00014s



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.00942s | After: 0.01436s | Elapsed: 0.00495s



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.01459s | After: 0.01540s | Elapsed: 0.00081s



Query #6

Before: 0.01547s | After: 0.01730s | Elapsed: 0.00183s



Query #7
QUERY PLAN
Aggregate (cost=2324.45..2324.46 rows=1 width=8)
-> Seq Scan on pin_session (cost=0.00..2324.24 rows=83 width=33)
Filter: ((update_time >= 1574306491) AND (uid = 1))

Before: 0.01781s | After: 0.03957s | Elapsed: 0.02176s



Query results obtained from the cache

Before: 0.04804s | After: 0.04813s | Elapsed [cache]: 0.00009s | Elapsed [db]: 0.00041s



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

Before: 0.04871s | After: 0.04881s | Elapsed: 0.00010s



Query #10
QUERY PLAN
Hash Join (cost=135.11..148.42 rows=1 width=573)
Hash Cond: (f.forum_id = t.forum_id)
-> Seq Scan on phpbb_forums f (cost=0.00..12.40 rows=240 width=302)
-> Hash (cost=135.10..135.10 rows=1 width=271)
-> Seq Scan on phpbb_topics t (cost=0.00..135.10 rows=1 width=271)
Filter: (topic_id = 3642)

Before: 0.04999s | After: 0.05086s | Elapsed: 0.00086s



Query results obtained from the cache

Before: 0.05134s | After: 0.05139s | Elapsed [cache]: 0.00005s | Elapsed [db]: 0.00010s



Query results obtained from the cache

Before: 0.05579s | After: 0.05585s | Elapsed [cache]: 0.00006s | Elapsed [db]: 0.00032s



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

Before: 0.05690s | After: 0.05882s | Elapsed: 0.00191s



Query #14
QUERY PLAN
Nested Loop Left Join (cost=0.28..399.84 rows=1 width=1443)
Join Filter: (z.zebra_id = p.poster_id)
-> Nested Loop (cost=0.28..364.33 rows=1 width=1439)
-> Seq Scan on phpbb_posts p (cost=0.00..356.02 rows=1 width=534)
Filter: (post_id = 5592)
-> 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=1 width=8)
Filter: (user_id = 1)

Before: 0.05988s | After: 0.06226s | Elapsed: 0.00238s



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

Before: 0.06650s | After: 0.06661s | Elapsed: 0.00010s



Query #16
QUERY PLAN
Sort (cost=90.78..92.13 rows=540 width=140)
Sort Key: f.field_order
-> Hash Join (cost=24.85..66.27 rows=540 width=140)
Hash Cond: (l.field_id = f.field_id)
-> Seq Scan on phpbb_profile_lang l (cost=0.00..32.62 rows=905 width=17)
Filter: (lang_id = 3)
-> Hash (cost=18.10..18.10 rows=540 width=123)
-> Seq Scan on phpbb_profile_fields f (cost=0.00..18.10 rows=540 width=123)
Filter: ((field_active = 1) AND (field_no_view = 0))

Before: 0.06722s | After: 0.06751s | Elapsed: 0.00029s



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

Before: 0.06786s | After: 0.06796s | Elapsed: 0.00010s



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

Before: 0.06842s | After: 0.06942s | Elapsed: 0.00100s



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: 0.07011s | After: 0.07034s | Elapsed: 0.00023s



Query #20
QUERY PLAN
Nested Loop (cost=4.55..9.60 rows=1 width=28)
-> Nested Loop (cost=4.40..9.16 rows=2 width=14)
-> Seq Scan on phpbb_acl_users a (cost=0.00..1.38 rows=1 width=12)
Filter: (user_id = 53)
-> Bitmap Heap Scan on phpbb_acl_roles_data r (cost=4.40..7.62 rows=17 width=10)
Recheck Cond: (role_id = a.auth_role_id)
-> Bitmap Index Scan on phpbb_acl_roles_data_pkey (cost=0.00..4.40 rows=17 width=0)
Index Cond: (role_id = a.auth_role_id)
-> Index Scan using phpbb_acl_options_pkey on phpbb_acl_options ao (cost=0.14..0.19 rows=1 width=14)
Index Cond: (auth_option_id = r.auth_option_id)
Filter: ((auth_option)::text = 'u_readpm'::text)

Before: 0.07100s | After: 0.07135s | Elapsed: 0.00035s



Query #21
QUERY PLAN
Nested Loop (cost=10.19..72.02 rows=1 width=24)
Join Filter: ((a.group_id = ug.group_id) AND ((ug.group_leader <> 1) OR (g.group_skip_auth <> 1)))
-> Hash Join (cost=10.19..31.34 rows=1 width=30)
Hash Cond: (g.group_id = a.group_id)
-> Seq Scan on phpbb_groups g (cost=0.00..18.10 rows=810 width=6)
-> Hash (cost=10.18..10.18 rows=1 width=24)
-> Nested Loop (cost=4.21..10.18 rows=1 width=24)
-> 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_groups a (cost=4.21..7.33 rows=1 width=14)
Recheck Cond: (auth_option_id = ao.auth_option_id)
Filter: (auth_role_id = 0)
-> Bitmap Index Scan on auth_opt_id (cost=0.00..4.21 rows=8 width=0)
Index Cond: (auth_option_id = ao.auth_option_id)
-> Seq Scan on phpbb_user_group ug (cost=0.00..40.60 rows=5 width=10)
Filter: ((user_pending = 0) AND (user_id = 53))

Before: 0.07235s | After: 0.07301s | Elapsed: 0.00066s



Query #22
QUERY PLAN
Hash Join (cost=54.34..80.03 rows=37 width=24)
Hash Cond: (ug.group_id = a.group_id)
-> Hash Join (cost=40.66..65.92 rows=5 width=12)
Hash Cond: (g.group_id = ug.group_id)
Join Filter: ((ug.group_leader <> 1) OR (g.group_skip_auth <> 1))
-> Seq Scan on phpbb_groups g (cost=0.00..18.10 rows=810 width=6)
-> Hash (cost=40.60..40.60 rows=5 width=10)
-> Seq Scan on phpbb_user_group ug (cost=0.00..40.60 rows=5 width=10)
Filter: ((user_pending = 0) AND (user_id = 53))
-> 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: 0.07391s | After: 0.07482s | Elapsed: 0.00091s



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

Before: 0.07510s | After: 0.07520s | Elapsed: 0.00010s



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

Before: 0.07650s | After: 0.07659s | Elapsed: 0.00009s



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

Affected rows: 1 | Before: 0.07704s | After: 0.08422s | Elapsed: 0.00718s



Query #26
QUERY PLAN
Aggregate (cost=245.38..245.39 rows=1 width=8)
-> Seq Scan on phpbb_sessions s (cost=0.00..245.38 rows=1 width=13)
Filter: ((session_time >= 1574313360) AND (session_user_id = 1) AND (session_forum_id = 12))

Before: 0.08484s | After: 0.08578s | Elapsed: 0.00095s



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

Before: 0.08604s | After: 0.08693s | Elapsed: 0.00089s



Query #28
QUERY PLAN
Sort (cost=21.89..22.49 rows=240 width=52)
Sort Key: left_id
-> Seq Scan on phpbb_forums (cost=0.00..12.40 rows=240 width=52)

Before: 0.08814s | After: 0.08998s | Elapsed: 0.00185s