SQL Report


Page generated in 0.0929 seconds with 14 queries + 3 queries returning data from cache

Time spent on postgres queries: 0.00629s | Time spent on PHP: 0.0866s



Query #1
QUERY PLAN
Bitmap Heap Scan on phpbb_config (cost=4.47..7.78 rows=25 width=22)
Recheck Cond: (is_dynamic = 1)
-> Bitmap Index Scan on phpbb_config_is_dynamic (cost=0.00..4.46 rows=25 width=0)
Index Cond: (is_dynamic = 1)

Before: 0.05976s | After: 0.05998s | Elapsed: 0.00022s



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

Before: 0.06364s | After: 0.06395s | Elapsed: 0.00031s



Query results obtained from the cache

Before: 0.06504s | After: 0.06508s | Elapsed [cache]: 0.00004s | Elapsed [db]: 0.00023s



Query #4

Before: 0.06520s | After: 0.06639s | Elapsed: 0.00120s



Query #5
QUERY PLAN
Aggregate (cost=3.26..3.27 rows=1 width=8)
-> Seq Scan on phpbb_sessions (cost=0.00..3.23 rows=14 width=33)
Filter: ((session_time >= 1568806281) AND (session_user_id = 1))

Before: 0.06692s | After: 0.06710s | Elapsed: 0.00018s



Query results obtained from the cache

Before: 0.06833s | After: 0.06835s | Elapsed [cache]: 0.00003s | Elapsed [db]: 0.00013s



Query #7
QUERY PLAN
Sort (cost=2.71..2.77 rows=22 width=5922)
Sort Key: left_id
-> Seq Scan on phpbb_forums f (cost=0.00..2.22 rows=22 width=5922)

Before: 0.06986s | After: 0.07036s | Elapsed: 0.00051s



Query results obtained from the cache

Before: 0.07313s | After: 0.07318s | Elapsed [cache]: 0.00005s | Elapsed [db]: 0.00056s



Query #9
QUERY PLAN
Seq Scan on phpbb_config_text (cost=0.00..1.09 rows=1 width=548)
Filter: ((config_name)::text = 'hijri_adj_data'::text)

Before: 0.07436s | After: 0.07451s | Elapsed: 0.00014s



Query #10
QUERY PLAN
Sort (cost=8.56..8.56 rows=2 width=70)
Sort Key: g.group_legend
-> Nested Loop Left Join (cost=4.29..8.55 rows=2 width=70)
Join Filter: (g.group_id = ug.group_id)
Filter: ((g.group_type <> 2) OR (ug.user_id = 1))
-> Seq Scan on phpbb_groups g (cost=0.00..1.09 rows=2 width=70)
Filter: (group_legend > 0)
-> Materialize (cost=4.29..7.42 rows=1 width=8)
-> Bitmap Heap Scan on phpbb_user_group ug (cost=4.29..7.42 rows=1 width=8)
Recheck Cond: (user_id = 1)
Filter: (user_pending = 0)
-> Bitmap Index Scan on phpbb_user_group_user_id (cost=0.00..4.29 rows=2 width=0)
Index Cond: (user_id = 1)

Before: 0.07711s | After: 0.07743s | Elapsed: 0.00032s



Query #11
QUERY PLAN
Seq Scan on phpbb_forums (cost=0.00..2.88 rows=1 width=4)
Filter: ((forum_recent_topics = 1) AND (forum_id = ANY ('{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22}'::integer[])))

Before: 0.07834s | After: 0.07853s | Elapsed: 0.00020s



Query #12
QUERY PLAN
Aggregate (cost=12.19..12.20 rows=1 width=8)
-> Seq Scan on phpbb_topics t (cost=0.00..11.98 rows=83 width=4)
Filter: ((topic_id <> 0) AND (topic_status <> 2) AND (topic_visibility = 1) AND (forum_id = ANY ('{1,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,19,20,2,21,22,18}'::integer[])))

Before: 0.08032s | After: 0.08090s | Elapsed: 0.00059s



Query #13
QUERY PLAN
Limit (cost=19.15..19.27 rows=50 width=26)
-> Sort (cost=19.15..19.36 rows=83 width=26)
Sort Key: t.topic_last_post_time DESC
-> Hash Left Join (cost=4.05..16.50 rows=83 width=26)
Hash Cond: (t.forum_id = ft.forum_id)
-> Hash Left Join (cost=2.58..14.79 rows=83 width=22)
Hash Cond: (t.topic_id = tt.topic_id)
-> Seq Scan on phpbb_topics t (cost=0.00..11.98 rows=83 width=18)
Filter: ((topic_id <> 0) AND (topic_status <> 2) AND (topic_visibility = 1) AND (forum_id = ANY ('{1,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,19,20,2,21,22,18}'::integer[])))
-> Hash (cost=2.56..2.56 rows=1 width=8)
-> Seq Scan on phpbb_topics_track tt (cost=0.00..2.56 rows=1 width=8)
Filter: (user_id = 1)
-> Hash (cost=1.46..1.46 rows=1 width=8)
-> Seq Scan on phpbb_forums_track ft (cost=0.00..1.46 rows=1 width=8)
Filter: (user_id = 1)

Before: 0.08190s | After: 0.08276s | Elapsed: 0.00086s



Query #14
QUERY PLAN
Limit (cost=39.59..39.60 rows=5 width=850)
-> Sort (cost=39.59..39.60 rows=5 width=850)
Sort Key: t.topic_last_post_time DESC
-> Nested Loop Left Join (cost=2.64..39.53 rows=5 width=850)
-> Hash Left Join (cost=2.50..10.67 rows=5 width=818)
Hash Cond: (t.forum_id = f.forum_id)
-> Seq Scan on phpbb_topics t (cost=0.00..8.16 rows=5 width=258)
Filter: (topic_id = ANY ('{1059,1056,934,1055,991}'::integer[]))
-> Hash (cost=2.22..2.22 rows=22 width=564)
-> Seq Scan on phpbb_forums f (cost=0.00..2.22 rows=22 width=564)
-> Index Scan using phpbb_posts_pkey on phpbb_posts fp (cost=0.15..5.76 rows=1 width=36)
Index Cond: (post_id = t.topic_first_post_id)

Before: 0.08506s | After: 0.08597s | Elapsed: 0.00091s



Query #15
QUERY PLAN
Aggregate (cost=3.25..3.25 rows=1 width=8)
-> Seq Scan on phpbb_sessions s (cost=0.00..3.23 rows=8 width=14)
Filter: ((session_time >= 1568813160) AND (session_user_id = 1))

Before: 0.08937s | After: 0.08972s | Elapsed: 0.00035s



Query #16
QUERY PLAN
Seq Scan on phpbb_sessions s (cost=0.00..3.23 rows=1 width=20)
Filter: ((session_time >= 1568813160) AND (session_user_id <> 1))

Before: 0.09005s | After: 0.09025s | Elapsed: 0.00020s



Query #17
QUERY PLAN
Sort (cost=8.30..8.30 rows=1 width=36)
Sort Key: username_clean
-> Index Scan using phpbb_users_pkey on phpbb_users u (cost=0.27..8.29 rows=1 width=36)
Index Cond: (user_id = 8)

Before: 0.09085s | After: 0.09116s | Elapsed: 0.00031s