SQL Report


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

Time spent on postgres queries: 0.00193s | Time spent on PHP: 0.0684s



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.05615s | After: 0.05636s | Elapsed: 0.00021s



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.05950s | After: 0.05986s | Elapsed: 0.00036s



Query results obtained from the cache

Before: 0.06119s | After: 0.06121s | Elapsed [cache]: 0.00003s | Elapsed [db]: 0.00019s



Query #4

Before: 0.06137s | After: 0.06238s | Elapsed: 0.00102s



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

Before: 0.06300s | After: 0.06321s | Elapsed: 0.00021s



Query results obtained from the cache

Before: 0.06455s | After: 0.06458s | Elapsed [cache]: 0.00002s | Elapsed [db]: 0.00016s



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.06599s | After: 0.06613s | Elapsed: 0.00013s



Query results obtained from the cache

Before: 0.06804s | After: 0.06810s | Elapsed [cache]: 0.00006s | Elapsed [db]: 0.00027s