SQL Report


Page generated in 0.0833 seconds with 6 queries + 3 queries returning data from cache

Time spent on postgres queries: 0.00283s | Time spent on PHP: 0.08045s



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.06264s | After: 0.06287s | Elapsed: 0.00023s



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

Before: 0.06974s | After: 0.07017s | Elapsed: 0.00042s



Query results obtained from the cache

Before: 0.07182s | After: 0.07187s | Elapsed [cache]: 0.00005s | Elapsed [db]: 0.00025s



Query #4

Before: 0.07203s | After: 0.07343s | Elapsed: 0.00140s



Query #5
QUERY PLAN
Aggregate (cost=2.23..2.24 rows=1 width=8)
-> Seq Scan on phpbb_sessions (cost=0.00..2.21 rows=7 width=33)
Filter: ((session_time >= 1563752236) AND (session_user_id = 1))

Before: 0.07419s | After: 0.07441s | Elapsed: 0.00022s



Query results obtained from the cache

Before: 0.07639s | After: 0.07642s | Elapsed [cache]: 0.00003s | Elapsed [db]: 0.00015s



Query #7
QUERY PLAN
Sort (cost=15.92..15.97 rows=22 width=1056)
Sort Key: f.left_id
-> Hash Left Join (cost=13.11..15.43 rows=22 width=1056)
Hash Cond: (f.forum_id = fa.forum_id)
-> Seq Scan on phpbb_forums f (cost=0.00..2.22 rows=22 width=1052)
-> Hash (cost=13.09..13.09 rows=2 width=8)
-> Bitmap Heap Scan on phpbb_forums_access fa (cost=7.75..13.09 rows=2 width=8)
Recheck Cond: (session_id = '93f80d7c5d34ddb9c170daf98e4499cd'::bpchar)
-> Bitmap Index Scan on phpbb_forums_access_pkey (cost=0.00..7.75 rows=2 width=0)
Index Cond: (session_id = '93f80d7c5d34ddb9c170daf98e4499cd'::bpchar)

Before: 0.07919s | After: 0.07960s | Elapsed: 0.00041s



Query #8
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.08056s | After: 0.08071s | Elapsed: 0.00015s



Query results obtained from the cache

Before: 0.08276s | After: 0.08289s | Elapsed [cache]: 0.00013s | Elapsed [db]: 0.00022s