SQL Report


Page generated in 0.1019 seconds with 13 queries + 3 queries returning data from cache

Time spent on postgres queries: 0.00613s | Time spent on PHP: 0.09577s



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.06331s | After: 0.06354s | Elapsed: 0.00022s



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

Before: 0.07034s | After: 0.07067s | Elapsed: 0.00033s



Query results obtained from the cache

Before: 0.07217s | After: 0.07220s | Elapsed [cache]: 0.00003s | Elapsed [db]: 0.00025s



Query #4

Before: 0.07239s | After: 0.07375s | Elapsed: 0.00136s



Query #5
QUERY PLAN
Aggregate (cost=4.93..4.94 rows=1 width=8)
-> Seq Scan on phpbb_sessions (cost=0.00..4.75 rows=70 width=33)
Filter: ((session_time >= 1571455900) AND (session_user_id = 1))

Before: 0.07443s | After: 0.07463s | Elapsed: 0.00021s



Query results obtained from the cache

Before: 0.07687s | After: 0.07690s | Elapsed [cache]: 0.00003s | Elapsed [db]: 0.00015s



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

Before: 0.07947s | After: 0.07992s | Elapsed: 0.00045s



Query results obtained from the cache

Before: 0.08212s | After: 0.08215s | Elapsed [cache]: 0.00003s | Elapsed [db]: 0.00042s



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.08367s | After: 0.08389s | Elapsed: 0.00022s



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.08676s | After: 0.08712s | Elapsed: 0.00036s



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.08821s | After: 0.08844s | Elapsed: 0.00023s



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

Before: 0.09065s | After: 0.09126s | Elapsed: 0.00061s



Query #13
QUERY PLAN
Limit (cost=19.28..19.41 rows=50 width=26)
-> Sort (cost=19.28..19.49 rows=84 width=26)
Sort Key: t.topic_last_post_time DESC
-> Hash Left Join (cost=4.05..16.60 rows=84 width=26)
Hash Cond: (t.forum_id = ft.forum_id)
-> Hash Left Join (cost=2.58..14.88 rows=84 width=22)
Hash Cond: (t.topic_id = tt.topic_id)
-> Seq Scan on phpbb_topics t (cost=0.00..12.08 rows=84 width=18)
Filter: ((topic_id <> 0) AND (topic_status <> 2) AND (topic_visibility = 1) AND (forum_id = ANY ('{1,3,4,6,7,8,9,10,11,12,13,14,15,16,17,19,20,2,21,22,18,5}'::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.09243s | After: 0.09335s | Elapsed: 0.00092s



Query #14
QUERY PLAN
Limit (cost=39.62..39.64 rows=5 width=852)
-> Sort (cost=39.62..39.64 rows=5 width=852)
Sort Key: t.topic_last_post_time DESC
-> Nested Loop Left Join (cost=2.64..39.57 rows=5 width=852)
-> Hash Left Join (cost=2.50..10.70 rows=5 width=820)
Hash Cond: (t.forum_id = f.forum_id)
-> Seq Scan on phpbb_topics t (cost=0.00..8.19 rows=5 width=260)
Filter: (topic_id = ANY ('{1061,1060,1059,1056,934}'::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.09617s | After: 0.09701s | Elapsed: 0.00084s



Query #15
QUERY PLAN
Aggregate (cost=4.76..4.77 rows=1 width=8)
-> Seq Scan on phpbb_sessions s (cost=0.00..4.75 rows=1 width=15)
Filter: ((session_time >= 1571462760) AND (session_user_id = 1))

Before: 0.09961s | After: 0.09984s | Elapsed: 0.00022s



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

Before: 0.10010s | After: 0.10025s | Elapsed: 0.00016s