SQL Report


Page generated in 0.0866 seconds with 5 queries + 3 queries returning data from cache

Time spent on postgres queries: 0.00243s | Time spent on PHP: 0.08417s



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.06500s | After: 0.06529s | Elapsed: 0.00030s



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.07146s | After: 0.07187s | Elapsed: 0.00040s



Query results obtained from the cache

Before: 0.07349s | After: 0.07356s | Elapsed [cache]: 0.00007s | Elapsed [db]: 0.00022s



Query #4

Before: 0.07372s | After: 0.07508s | Elapsed: 0.00136s



Query #5
QUERY PLAN
Aggregate (cost=2.50..2.51 rows=1 width=8)
-> Seq Scan on phpbb_sessions (cost=0.00..2.45 rows=20 width=33)
Filter: ((session_time >= 1563753872) AND (session_user_id = 1))

Before: 0.07590s | After: 0.07614s | Elapsed: 0.00024s



Query results obtained from the cache

Before: 0.07807s | After: 0.07810s | Elapsed [cache]: 0.00003s | Elapsed [db]: 0.00014s



Query #7
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.07987s | After: 0.08000s | Elapsed: 0.00013s



Query results obtained from the cache

Before: 0.08280s | After: 0.08286s | Elapsed [cache]: 0.00005s | Elapsed [db]: 0.00026s