Request Information

This is an example developer support report, part of the Forums Performance article. The start of a message insert is highlighted below

Request Information

Your Workspace : Main Site : ds : Request Information

Parameters

Request Start Time: Wed Dec 11 09:04:05 2002
Request Completion Time: Wed Dec 11 09:04:33 2002

Request Duration: 27478 ms

IP: 127.0.0.1

Method: GET

URL: /qa/loader

Query: (empty)

Request Start Time:	Wed Dec 11 09:04:05 2002
Request Completion Time:	Wed Dec 11 09:04:33 2002
Request Duration:	27478 ms
IP:	127.0.0.1
Method:	GET
URL:	/qa/loader
Query:	(empty)

Request Processor

+1.5 ms: Applied transformation from /web/oatest/www / qa/loader -> ? - 2.4 ms
+11.1 ms: Served file /web/oatest/packages/jcd-qa/www/loader.tcl with adp_parse_ad_conn_file - 27442.9 ms
+27477.4 ms: Applied GET filter: (for /qa/loader ds_trace_filter) - 1.5 ms
- returned filter_ok

Comments

rp_handler: trying rp_serve_abstract_file /web/oatest/www / qa/loader
rp_handler: not found
rp_handler: trying rp_serve_abstract_file /web/oatest/packages/jcd-qa/www / loader

Headers

Host: localhost:8080

User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.2.1) Gecko/20021130

Accept: text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,video/x-mng,image/png,image/jpeg,image/gif;q=0.2,text/css,*/*;q=0.1

Accept-Language: en-us, en;q=0.66, de;q=0.33

Accept-Encoding: gzip, deflate, compress;q=0.9

Accept-Charset: ISO-8859-1, utf-8;q=0.66, *;q=0.66

Keep-Alive: 300

Connection: keep-alive

Cookie: ad_user_login=2599%20%7b900%200%20CE30D8A509C2E36DBE609E85AC3B1021AAE589B6%7d

Host:	localhost:8080
User-Agent:	Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.2.1) Gecko/20021130
Accept:	text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,video/x-mng,image/png,image/jpeg,image/gif;q=0.2,text/css,/;q=0.1
Accept-Language:	en-us, en;q=0.66, de;q=0.33
Accept-Encoding:	gzip, deflate, compress;q=0.9
Accept-Charset:	ISO-8859-1, utf-8;q=0.66, *;q=0.66
Keep-Alive:	300
Connection:	keep-alive
Cookie:	ad_user_login=2599%20%7b900%200%20CE30D8A509C2E36DBE609E85AC3B1021AAE589B6%7d

Output Headers

Set-Cookie: ad_session_id=190001%2c2599%20%7b51%201039598645%20E9C1F25A59490C84115F83D2D2D5F7E3BF1506B5%7d; Path=/; Max-Age=1200

Server: AOLserver/3.3.1+ad13

Set-Cookie:	ad_session_id=190001%2c2599%20%7b51%201039598645%20E9C1F25A59490C84115F83D2D2D5F7E3BF1506B5%7d; Path=/; Max-Age=1200
Server:	AOLserver/3.3.1+ad13

Database Requests

Duration Pool Command

0 ms subquery gethandle (returned nsdb0)
2 ms
subquery
dbqd.acs-tcl.tcl.defs-procs.ad_parameter_cache.select_parameter_value: 0or1row nsdb0
      select apm_parameter_values.attr_value
      from apm_parameters, apm_parameter_values
      where apm_parameter_values.package_id = :package_id
      and apm_parameter_values.parameter_id = apm_parameters.parameter_id
      and apm_parameters.parameter_name = :parameter_name
    
2 ms
subquery
dbqd.acs-tcl.tcl.defs-procs.ad_parameter_cache.select_parameter_value: 0or1row nsdb0
      select apm_parameter_values.attr_value
      from apm_parameters, apm_parameter_values
      where apm_parameter_values.package_id = :package_id
      and apm_parameter_values.parameter_id = apm_parameters.parameter_id
      and apm_parameters.parameter_name = :parameter_name
    
2 ms
subquery
dbqd.acs-tcl.tcl.defs-procs.ad_parameter_cache.select_parameter_value: 0or1row nsdb0
      select apm_parameter_values.attr_value
      from apm_parameters, apm_parameter_values
      where apm_parameter_values.package_id = :package_id
      and apm_parameter_values.parameter_id = apm_parameters.parameter_id
      and apm_parameters.parameter_name = :parameter_name
    
2 ms
subquery
dbqd.acs-tcl.tcl.security-procs.sec_get_token.get_token: 0or1row nsdb0
      select token from secret_tokens
                       	                 where token_id = :token_id
      
2 ms
subquery
dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_sequence: 0or1row nsdb0
      select nextval(:sequence) as nextval
      where (select relkind 
             from pg_class 
             where relname = :sequence) = 'S'
    
39 ms
subquery
dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_view: 0or1row nsdb0
      select nextval 
      from sec_id_seq
    
9 ms
subquery
dbqd.acs-tcl.tcl.security-procs.sec_update_user_session_info.update_last_visit: dml nsdb0
        update users
        set second_to_last_visit = last_visit,
            last_visit = now(),
            n_sessions = n_sessions + 1
        where user_id = :user_id
    
      
14 ms
subquery
dbqd.acs-tcl.tcl.acs-permissions-procs.permission::permission_p_not_cached.select_permission_p: 0or1row nsdb0
            select 1
            where 't' = acs_permission__permission_p(:object_id, :party_id, :privilege)
        
3 ms
subquery
dbqd.acs-tcl.tcl.defs-procs.ad_parameter_cache.select_parameter_value: 0or1row nsdb0
      select apm_parameter_values.attr_value
      from apm_parameters, apm_parameter_values
      where apm_parameter_values.package_id = :package_id
      and apm_parameter_values.parameter_id = apm_parameters.parameter_id
      and apm_parameters.parameter_name = :parameter_name
    
2 ms
subquery
dbqd.acs-tcl.tcl.defs-procs.ad_parameter_cache.select_parameter_value: 0or1row nsdb0
      select apm_parameter_values.attr_value
      from apm_parameters, apm_parameter_values
      where apm_parameter_values.package_id = :package_id
      and apm_parameter_values.parameter_id = apm_parameters.parameter_id
      and apm_parameters.parameter_name = :parameter_name
    
2 ms
subquery
dbqd.acs-subsite.tcl.package-procs.package_instantiate_object.package_select: 0or1row nsdb0
      
      select t.package_name
      from acs_object_types t
      where t.object_type = :object_type
      
    
1 ms
subquery
dbqd.acs-subsite.tcl.package-procs.package_plsql_args.select_type_info: 0or1row nsdb0
	select t.package_name
	  from acs_object_types t 
	 where t.object_type = :object_type
    
5 ms
subquery
dbqd.acs-subsite.tcl.package-procs.package_plsql_args.select_object_type_param_list: select nsdb0
	select args.arg_name
        from acs_function_args args
        where args.function = upper(:package_name) || '__' || upper(:function_name)
      
0 ms
subquery
getrow nsdb0
0 ms
subquery
getrow nsdb0
0 ms
subquery
getrow nsdb0
0 ms
subquery
getrow nsdb0
0 ms
subquery
getrow nsdb0
0 ms
subquery
getrow nsdb0
0 ms
subquery
getrow nsdb0
0 ms
subquery
getrow nsdb0
0 ms
subquery
getrow nsdb0
0 ms main gethandle (returned nsdb1)
5 ms
main
dbqd.acs-subsite.tcl.plpgsql-utility-procs.plpgsql_utility::generate_attribute_parameter_call.get_function_args: select nsdb1
      select arg_name, arg_default
      from acs_function_args
      where function = upper(:function_name)
      order by arg_seq
    
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
272 ms
subquery
dbqd.acs-subsite.tcl.package-procs.package_instantiate_object.create_object: 0or1row nsdb0
	select site_node__new(NULL,:parent_id,:name,NULL,:directory_p,:pattern_p,:creation_user,:creation_ip)

      
3 ms
subquery
dbqd.acs-subsite.tcl.subsite-callback-procs.subsite_callback.select_callbacks: select nsdb0
	select distinct callback, callback_type
	  from subsite_callbacks
	 where object_type in (select t2.object_type
	                         from acs_object_types t1, acs_object_types t2
	                        where t2.tree_sortkey <= t1.tree_sortkey
				  and t1.tree_sortkey between t2.tree_sortkey and tree_right(t2.tree_sortkey)
				  and t1.object_type = :object_type)
	   and event_type = :event_type
    
      
0 ms
subquery
getrow nsdb0
3 ms
subquery
dbqd.acs-tcl.tcl.site-nodes-procs.site_node::update_cache.select_site_node: 0or1row nsdb0
            select site_node__url(site_nodes.node_id) as url,
                   site_nodes.node_id,
                   site_nodes.parent_id,
                   site_nodes.directory_p,
                   site_nodes.pattern_p,
                   site_nodes.object_id,
                   (select acs_objects.object_type
                    from acs_objects
                    where acs_objects.object_id = site_nodes.object_id) as object_type,
                   apm_packages.package_key,
                   apm_packages.package_id,
                   apm_packages.instance_name
            from site_nodes left join apm_packages on site_nodes.object_id = apm_packages.package_id
            where site_nodes.node_id = :node_id
        
1716 ms
subquery
dbqd.acs-tcl.tcl.apm-procs.apm_package_create_instance.apm_package_instance_new: 0or1row nsdb0
      select apm_package__new(
        :package_id,
        :instance_name,
        :package_key,
        'apm_package',
        now(),
        null,
        null,
        :context_id
      );
    
      
3 ms
subquery
dbqd.acs-tcl.tcl.apm-procs.apm_parameter_sync.apm_parameter_names_and_values: select nsdb0
      select parameter_name, attr_value
      from apm_parameters p, apm_parameter_values v, apm_packages a
      where p.parameter_id = v.parameter_id
      and a.package_id = v.package_id
      and a.package_id = :package_id
    
0 ms
subquery
getrow nsdb0
0 ms
subquery
getrow nsdb0
0 ms
subquery
getrow nsdb0
0 ms
subquery
getrow nsdb0
4 ms
subquery
dbqd.acs-tcl.tcl.site-nodes-procs.site_node::mount.mount_object: dml nsdb0
            update site_nodes
            set object_id = :object_id
            where node_id = :node_id
        
3 ms
subquery
dbqd.acs-tcl.tcl.site-nodes-procs.site_node::update_cache.select_site_node: 0or1row nsdb0
            select site_node__url(site_nodes.node_id) as url,
                   site_nodes.node_id,
                   site_nodes.parent_id,
                   site_nodes.directory_p,
                   site_nodes.pattern_p,
                   site_nodes.object_id,
                   (select acs_objects.object_type
                    from acs_objects
                    where acs_objects.object_id = site_nodes.object_id) as object_type,
                   apm_packages.package_key,
                   apm_packages.package_id,
                   apm_packages.instance_name
            from site_nodes left join apm_packages on site_nodes.object_id = apm_packages.package_id
            where site_nodes.node_id = :node_id
        
73 ms
subquery
dbqd.acs-tcl.tcl.site-nodes-procs.site_node::update_cache.select_site_node: 0or1row nsdb0
            select site_node__url(site_nodes.node_id) as url,
                   site_nodes.node_id,
                   site_nodes.parent_id,
                   site_nodes.directory_p,
                   site_nodes.pattern_p,
                   site_nodes.object_id,
                   (select acs_objects.object_type
                    from acs_objects
                    where acs_objects.object_id = site_nodes.object_id) as object_type,
                   apm_packages.package_key,
                   apm_packages.package_id,
                   apm_packages.instance_name
            from site_nodes left join apm_packages on site_nodes.object_id = apm_packages.package_id
            where site_nodes.node_id = :node_id
        
2 ms
subquery
dbqd.acs-subsite.tcl.package-procs.package_instantiate_object.package_select: 0or1row nsdb0
      
      select t.package_name
      from acs_object_types t
      where t.object_type = :object_type
      
    
2 ms
subquery
dbqd.acs-subsite.tcl.package-procs.package_plsql_args.select_type_info: 0or1row nsdb0
	select t.package_name
	  from acs_object_types t 
	 where t.object_type = :object_type
    
6 ms
subquery
dbqd.acs-subsite.tcl.package-procs.package_plsql_args.select_object_type_param_list: select nsdb0
	select args.arg_name
        from acs_function_args args
        where args.function = upper(:package_name) || '__' || upper(:function_name)
      
0 ms
subquery
getrow nsdb0
0 ms
subquery
getrow nsdb0
0 ms
subquery
getrow nsdb0
0 ms
subquery
getrow nsdb0
0 ms
subquery
getrow nsdb0
0 ms
subquery
getrow nsdb0
0 ms
subquery
getrow nsdb0
0 ms
subquery
getrow nsdb0
0 ms
subquery
getrow nsdb0
0 ms
subquery
getrow nsdb0
0 ms
subquery
getrow nsdb0
0 ms
subquery
getrow nsdb0
4 ms
main
dbqd.acs-subsite.tcl.plpgsql-utility-procs.plpgsql_utility::generate_attribute_parameter_call.get_function_args: select nsdb1
      select arg_name, arg_default
      from acs_function_args
      where function = upper(:function_name)
      order by arg_seq
    
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
43 ms
subquery
dbqd.acs-subsite.tcl.package-procs.package_instantiate_object.create_object: 0or1row nsdb0
	select forums_forum__new(:forum_id,'forums_forum',:name,:charter,:presentation_type,:posting_policy,:package_id,NULL,:creation_user,:creation_ip,NULL)

      
2 ms
subquery
dbqd.acs-subsite.tcl.subsite-callback-procs.subsite_callback.select_callbacks: select nsdb0
	select distinct callback, callback_type
	  from subsite_callbacks
	 where object_type in (select t2.object_type
	                         from acs_object_types t1, acs_object_types t2
	                        where t2.tree_sortkey <= t1.tree_sortkey
				  and t1.tree_sortkey between t2.tree_sortkey and tree_right(t2.tree_sortkey)
				  and t1.object_type = :object_type)
	   and event_type = :event_type
    
      
0 ms
subquery
getrow nsdb0
One message insert starts here.
2 ms
subquery
dbqd..NULL: 0or1row nsdb0
select min(forum_id) from forums_forums where package_id = :package_id
3 ms
subquery
dbqd..NULL: 0or1row nsdb0
 select message_id as parent_id from uu_message_map where key = :ref and forum_id = :forum_id
2 ms
subquery
dbqd..NULL: 0or1row nsdb0
select party_id as user_id from parties where email = :email
29 ms
subquery
dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_sequence: 0or1row nsdb0
      select nextval(:sequence) as nextval
      where (select relkind 
             from pg_class 
             where relname = :sequence) = 'S'
    
1 ms
subquery
dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_view: 0or1row nsdb0
      select nextval 
      from acs_object_id_seq
    
1001 ms
subquery
dbqd.acs-tcl.tcl.community-core-procs.ad_user_new.user_insert: 0or1row nsdb0
	    select acs__add_user(
                         :user_id,
                         'user',
                         now(),
                         null,
	                 :peeraddr,
			 :email,
			 :url,
			 :first_names,
			 :last_name,
			 :hashed_password,
	                 :salt,
	                 :password_question,
	                 :password_answer,
                         null,
	                 :email_verified_p,
	                 :member_state);
	
      
22 ms
subquery
dbqd.acs-tcl.tcl.user-extensions-procs.acs_user_extension::list_extensions.select_extensions: select nsdb0
select impl_name from acs_sc_impls, acs_sc_bindings, acs_sc_contracts
where
acs_sc_impls.impl_id = acs_sc_bindings.impl_id and
acs_sc_contracts.contract_id= acs_sc_bindings.contract_id and 
acs_sc_contracts.contract_name='UserData'
0 ms
subquery
getrow nsdb0
0 ms
subquery
getrow nsdb0
1 ms
subquery
dbqd.acs-tcl.tcl.community-core-procs.cc_email_from_party.email_from_party: 0or1row nsdb0
      
	select email from parties where party_id = :party_id
    
      
1 ms
subquery
dbqd..NULL: 0or1row nsdb0
	select package_key from apm_packages where package_id = :package_id
    
2 ms
subquery
dbqd.acs-tcl.tcl.defs-procs.ad_parameter_cache.select_parameter_value: 0or1row nsdb0
      select apm_parameter_values.attr_value
      from apm_parameters, apm_parameter_values
      where apm_parameter_values.package_id = :package_id
      and apm_parameter_values.parameter_id = apm_parameters.parameter_id
      and apm_parameters.parameter_name = :parameter_name
    
2 ms
subquery
dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_sequence: 0or1row nsdb0
      select nextval(:sequence) as nextval
      where (select relkind 
             from pg_class 
             where relname = :sequence) = 'S'
    
1 ms
subquery
dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_view: 0or1row nsdb0
      select nextval 
      from acs_object_id_seq
    
2 ms
subquery
dbqd..NULL: dml nsdb0
insert into uu_message_map values (:new_id,:message_id, :forum_id)
1 ms
subquery
dbqd.acs-subsite.tcl.package-procs.package_instantiate_object.package_select: 0or1row nsdb0
      
      select t.package_name
      from acs_object_types t
      where t.object_type = :object_type
      
    
1 ms
subquery
dbqd.acs-subsite.tcl.package-procs.package_plsql_args.select_type_info: 0or1row nsdb0
	select t.package_name
	  from acs_object_types t 
	 where t.object_type = :object_type
    
4 ms
subquery
dbqd.acs-subsite.tcl.package-procs.package_plsql_args.select_object_type_param_list: select nsdb0
	select args.arg_name
        from acs_function_args args
        where args.function = upper(:package_name) || '__' || upper(:function_name)
      
0 ms
subquery
getrow nsdb0
0 ms
subquery
getrow nsdb0
0 ms
subquery
getrow nsdb0
0 ms
subquery
getrow nsdb0
0 ms
subquery
getrow nsdb0
0 ms
subquery
getrow nsdb0
0 ms
subquery
getrow nsdb0
0 ms
subquery
getrow nsdb0
0 ms
subquery
getrow nsdb0
0 ms
subquery
getrow nsdb0
0 ms
subquery
getrow nsdb0
0 ms
subquery
getrow nsdb0
0 ms
subquery
getrow nsdb0
0 ms
subquery
getrow nsdb0
0 ms
subquery
getrow nsdb0
4 ms
main
dbqd.acs-subsite.tcl.plpgsql-utility-procs.plpgsql_utility::generate_attribute_parameter_call.get_function_args: select nsdb1
      select arg_name, arg_default
      from acs_function_args
      where function = upper(:function_name)
      order by arg_seq
    
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
484 ms
subquery
dbqd.acs-subsite.tcl.package-procs.package_instantiate_object.create_object: 0or1row nsdb0
	select forums_message__new(:message_id,'forums_message',:forum_id,:subject,:content,:html_p,:user_id,NULL,NULL,:parent_id,NULL,:creation_user,:creation_ip,NULL)

      
2 ms
subquery
dbqd.acs-subsite.tcl.subsite-callback-procs.subsite_callback.select_callbacks: select nsdb0
	select distinct callback, callback_type
	  from subsite_callbacks
	 where object_type in (select t2.object_type
	                         from acs_object_types t1, acs_object_types t2
	                        where t2.tree_sortkey <= t1.tree_sortkey
				  and t1.tree_sortkey between t2.tree_sortkey and tree_right(t2.tree_sortkey)
				  and t1.object_type = :object_type)
	   and event_type = :event_type
    
      
0 ms
subquery
getrow nsdb0
3 ms
subquery
dbqd.acs-tcl.tcl.site-node-apm-integration-procs.site_node_apm_integration::get_child_package_id.select_child_package_id: 0or1row nsdb0
            select sn1.object_id
            from site_nodes sn1,
                 apm_packages
            where sn1.parent_id = (select sn2.node_id
                                   from site_nodes sn2
                                   where sn2.object_id = :package_id)
            and sn1.object_id = apm_packages.package_id
            and apm_packages.package_key = :package_key
        
290 ms
subquery
dbqd.forums.tcl.messages-procs.forum::message::get.select_message: 0or1row nsdb0
            select forums_messages.*,
                   person__name(forums_messages.user_id) as user_name, 
                   party__email(forums_messages.user_id) as user_email,
                   forums_forum__name(forums_messages.forum_id) as forum_name, 
                   forums_message__root_message_id(forums_messages.message_id) as root_message_id,
                   (select fm2.subject
                    from forums_messages fm2 
                    where fm2.message_id = forums_message__root_message_id(forums_messages.message_id)) as root_subject, 
                   to_char(forums_messages.posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date
            from forums_messages
            where forums_messages.message_id= :message_id
        
31 ms
subquery
dbqd.acs-tcl.tcl.site-node-apm-integration-procs.site_node_apm_integration::get_child_package_id.select_child_package_id: 0or1row nsdb0
            select sn1.object_id
            from site_nodes sn1,
                 apm_packages
            where sn1.parent_id = (select sn2.node_id
                                   from site_nodes sn2
                                   where sn2.object_id = :package_id)
            and sn1.object_id = apm_packages.package_id
            and apm_packages.package_key = :package_key
        
312 ms
subquery
dbqd.forums.tcl.messages-procs.forum::message::get.select_message: 0or1row nsdb0
            select forums_messages.*,
                   person__name(forums_messages.user_id) as user_name, 
                   party__email(forums_messages.user_id) as user_email,
                   forums_forum__name(forums_messages.forum_id) as forum_name, 
                   forums_message__root_message_id(forums_messages.message_id) as root_message_id,
                   (select fm2.subject
                    from forums_messages fm2 
                    where fm2.message_id = forums_message__root_message_id(forums_messages.message_id)) as root_subject, 
                   to_char(forums_messages.posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date
            from forums_messages
            where forums_messages.message_id= :message_id
        
2 ms
subquery
dbqd.acs-tcl.tcl.defs-procs.ad_parameter_cache.select_parameter_value: 0or1row nsdb0
      select apm_parameter_values.attr_value
      from apm_parameters, apm_parameter_values
      where apm_parameter_values.package_id = :package_id
      and apm_parameter_values.parameter_id = apm_parameters.parameter_id
      and apm_parameters.parameter_name = :parameter_name
    
2 ms
subquery
dbqd.forums.tcl.messages-procs.forum::message::do_notifications.select_forums_package_url: 0or1row nsdb0
            select site_node__url(node_id)
            from site_nodes
            where object_id = (select package_id
                               from forums_forums
                               where forums_forums.forum_id = :forum_id)
        
2 ms
subquery
dbqd.notifications.tcl.notification-type-procs.notification::type::get_type_id.select_type_id: 0or1row nsdb0
            select type_id
            from notification_types
            where short_name = :short_name
        
2 ms
subquery
dbqd.notifications.tcl.notification-request-procs.notification::request::request_exists.request_count: 0or1row nsdb0
            select count(*)
            from notification_requests
            where type_id = :type_id
            and object_id = :object_id
        
1 ms
subquery
dbqd.notifications.tcl.notification-type-procs.notification::type::get_type_id.select_type_id: 0or1row nsdb0
            select type_id
            from notification_types
            where short_name = :short_name
        
2 ms
subquery
dbqd.notifications.tcl.notification-request-procs.notification::request::request_exists.request_count: 0or1row nsdb0
            select count(*)
            from notification_requests
            where type_id = :type_id
            and object_id = :object_id
        
Message insert finished.
2 ms
subquery
dbqd..NULL: 0or1row nsdb0
select min(forum_id) from forums_forums where package_id = :package_id
2 ms
subquery
dbqd..NULL: 0or1row nsdb0
 select message_id as parent_id from uu_message_map where key = :ref and forum_id = :forum_id
2 ms
subquery
dbqd..NULL: 0or1row nsdb0
select party_id as user_id from parties where email = :email
2 ms
subquery
dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_sequence: 0or1row nsdb0
      select nextval(:sequence) as nextval
      where (select relkind 
             from pg_class 
             where relname = :sequence) = 'S'
    
2 ms
subquery
dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_view: 0or1row nsdb0
      select nextval 
      from acs_object_id_seq
    
561 ms
subquery
dbqd.acs-tcl.tcl.community-core-procs.ad_user_new.user_insert: 0or1row nsdb0
	    select acs__add_user(
                         :user_id,
                         'user',
                         now(),
                         null,
	                 :peeraddr,
			 :email,
			 :url,
			 :first_names,
			 :last_name,
			 :hashed_password,
	                 :salt,
	                 :password_question,
	                 :password_answer,
                         null,
	                 :email_verified_p,
	                 :member_state);
	
      
5 ms
subquery
dbqd.acs-tcl.tcl.user-extensions-procs.acs_user_extension::list_extensions.select_extensions: select nsdb0
select impl_name from acs_sc_impls, acs_sc_bindings, acs_sc_contracts
where
acs_sc_impls.impl_id = acs_sc_bindings.impl_id and
acs_sc_contracts.contract_id= acs_sc_bindings.contract_id and 
acs_sc_contracts.contract_name='UserData'
0 ms
subquery
getrow nsdb0
0 ms
subquery
getrow nsdb0
1 ms
subquery
dbqd.acs-tcl.tcl.community-core-procs.cc_email_from_party.email_from_party: 0or1row nsdb0
      
	select email from parties where party_id = :party_id
    
      
2 ms
subquery
dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_sequence: 0or1row nsdb0
      select nextval(:sequence) as nextval
      where (select relkind 
             from pg_class 
             where relname = :sequence) = 'S'
    
1 ms
subquery
dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_view: 0or1row nsdb0
      select nextval 
      from acs_object_id_seq
    
2 ms
subquery
dbqd..NULL: dml nsdb0
insert into uu_message_map values (:new_id,:message_id, :forum_id)
1 ms
subquery
dbqd.acs-subsite.tcl.package-procs.package_instantiate_object.package_select: 0or1row nsdb0
      
      select t.package_name
      from acs_object_types t
      where t.object_type = :object_type
      
    
4 ms
main
dbqd.acs-subsite.tcl.plpgsql-utility-procs.plpgsql_utility::generate_attribute_parameter_call.get_function_args: select nsdb1
      select arg_name, arg_default
      from acs_function_args
      where function = upper(:function_name)
      order by arg_seq
    
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
215 ms
subquery
dbqd.acs-subsite.tcl.package-procs.package_instantiate_object.create_object: 0or1row nsdb0
	select forums_message__new(:message_id,'forums_message',:forum_id,:subject,:content,:html_p,:user_id,NULL,NULL,:parent_id,NULL,:creation_user,:creation_ip,NULL)

      
2 ms
subquery
dbqd.acs-subsite.tcl.subsite-callback-procs.subsite_callback.select_callbacks: select nsdb0
	select distinct callback, callback_type
	  from subsite_callbacks
	 where object_type in (select t2.object_type
	                         from acs_object_types t1, acs_object_types t2
	                        where t2.tree_sortkey <= t1.tree_sortkey
				  and t1.tree_sortkey between t2.tree_sortkey and tree_right(t2.tree_sortkey)
				  and t1.object_type = :object_type)
	   and event_type = :event_type
    
      
0 ms
subquery
getrow nsdb0
3 ms
subquery
dbqd.acs-tcl.tcl.site-node-apm-integration-procs.site_node_apm_integration::get_child_package_id.select_child_package_id: 0or1row nsdb0
            select sn1.object_id
            from site_nodes sn1,
                 apm_packages
            where sn1.parent_id = (select sn2.node_id
                                   from site_nodes sn2
                                   where sn2.object_id = :package_id)
            and sn1.object_id = apm_packages.package_id
            and apm_packages.package_key = :package_key
        
166 ms
subquery
dbqd.forums.tcl.messages-procs.forum::message::get.select_message: 0or1row nsdb0
            select forums_messages.*,
                   person__name(forums_messages.user_id) as user_name, 
                   party__email(forums_messages.user_id) as user_email,
                   forums_forum__name(forums_messages.forum_id) as forum_name, 
                   forums_message__root_message_id(forums_messages.message_id) as root_message_id,
                   (select fm2.subject
                    from forums_messages fm2 
                    where fm2.message_id = forums_message__root_message_id(forums_messages.message_id)) as root_subject, 
                   to_char(forums_messages.posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date
            from forums_messages
            where forums_messages.message_id= :message_id
        
3 ms
subquery
dbqd.acs-tcl.tcl.site-node-apm-integration-procs.site_node_apm_integration::get_child_package_id.select_child_package_id: 0or1row nsdb0
            select sn1.object_id
            from site_nodes sn1,
                 apm_packages
            where sn1.parent_id = (select sn2.node_id
                                   from site_nodes sn2
                                   where sn2.object_id = :package_id)
            and sn1.object_id = apm_packages.package_id
            and apm_packages.package_key = :package_key
        
167 ms
subquery
dbqd.forums.tcl.messages-procs.forum::message::get.select_message: 0or1row nsdb0
            select forums_messages.*,
                   person__name(forums_messages.user_id) as user_name, 
                   party__email(forums_messages.user_id) as user_email,
                   forums_forum__name(forums_messages.forum_id) as forum_name, 
                   forums_message__root_message_id(forums_messages.message_id) as root_message_id,
                   (select fm2.subject
                    from forums_messages fm2 
                    where fm2.message_id = forums_message__root_message_id(forums_messages.message_id)) as root_subject, 
                   to_char(forums_messages.posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date
            from forums_messages
            where forums_messages.message_id= :message_id
        
2 ms
subquery
dbqd.forums.tcl.messages-procs.forum::message::do_notifications.select_forums_package_url: 0or1row nsdb0
            select site_node__url(node_id)
            from site_nodes
            where object_id = (select package_id
                               from forums_forums
                               where forums_forums.forum_id = :forum_id)
        
5 ms
subquery
dbqd.notifications.tcl.notification-type-procs.notification::type::get_type_id.select_type_id: 0or1row nsdb0
            select type_id
            from notification_types
            where short_name = :short_name
        
2 ms
subquery
dbqd.notifications.tcl.notification-request-procs.notification::request::request_exists.request_count: 0or1row nsdb0
            select count(*)
            from notification_requests
            where type_id = :type_id
            and object_id = :object_id
        
1 ms
subquery
dbqd.notifications.tcl.notification-type-procs.notification::type::get_type_id.select_type_id: 0or1row nsdb0
            select type_id
            from notification_types
            where short_name = :short_name
        
2 ms
subquery
dbqd.notifications.tcl.notification-request-procs.notification::request::request_exists.request_count: 0or1row nsdb0
            select count(*)
            from notification_requests
            where type_id = :type_id
            and object_id = :object_id
        
2 ms
subquery
dbqd..NULL: 0or1row nsdb0
select min(forum_id) from forums_forums where package_id = :package_id
2 ms
subquery
dbqd..NULL: 0or1row nsdb0
 select message_id as parent_id from uu_message_map where key = :ref and forum_id = :forum_id
2 ms
subquery
dbqd..NULL: 0or1row nsdb0
select party_id as user_id from parties where email = :email
2 ms
subquery
dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_sequence: 0or1row nsdb0
      select nextval(:sequence) as nextval
      where (select relkind 
             from pg_class 
             where relname = :sequence) = 'S'
    
2 ms
subquery
dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_view: 0or1row nsdb0
      select nextval 
      from acs_object_id_seq
    
529 ms
subquery
dbqd.acs-tcl.tcl.community-core-procs.ad_user_new.user_insert: 0or1row nsdb0
	    select acs__add_user(
                         :user_id,
                         'user',
                         now(),
                         null,
	                 :peeraddr,
			 :email,
			 :url,
			 :first_names,
			 :last_name,
			 :hashed_password,
	                 :salt,
	                 :password_question,
	                 :password_answer,
                         null,
	                 :email_verified_p,
	                 :member_state);
	
      
3 ms
subquery
dbqd.acs-tcl.tcl.user-extensions-procs.acs_user_extension::list_extensions.select_extensions: select nsdb0
select impl_name from acs_sc_impls, acs_sc_bindings, acs_sc_contracts
where
acs_sc_impls.impl_id = acs_sc_bindings.impl_id and
acs_sc_contracts.contract_id= acs_sc_bindings.contract_id and 
acs_sc_contracts.contract_name='UserData'
0 ms
subquery
getrow nsdb0
0 ms
subquery
getrow nsdb0
1 ms
subquery
dbqd.acs-tcl.tcl.community-core-procs.cc_email_from_party.email_from_party: 0or1row nsdb0
      
	select email from parties where party_id = :party_id
    
      
2 ms
subquery
dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_sequence: 0or1row nsdb0
      select nextval(:sequence) as nextval
      where (select relkind 
             from pg_class 
             where relname = :sequence) = 'S'
    
1 ms
subquery
dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_view: 0or1row nsdb0
      select nextval 
      from acs_object_id_seq
    
2 ms
subquery
dbqd..NULL: dml nsdb0
insert into uu_message_map values (:new_id,:message_id, :forum_id)
1 ms
subquery
dbqd.acs-subsite.tcl.package-procs.package_instantiate_object.package_select: 0or1row nsdb0
      
      select t.package_name
      from acs_object_types t
      where t.object_type = :object_type
      
    
4 ms
main
dbqd.acs-subsite.tcl.plpgsql-utility-procs.plpgsql_utility::generate_attribute_parameter_call.get_function_args: select nsdb1
      select arg_name, arg_default
      from acs_function_args
      where function = upper(:function_name)
      order by arg_seq
    
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
4 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
225 ms
subquery
dbqd.acs-subsite.tcl.package-procs.package_instantiate_object.create_object: 0or1row nsdb0
	select forums_message__new(:message_id,'forums_message',:forum_id,:subject,:content,:html_p,:user_id,NULL,NULL,:parent_id,NULL,:creation_user,:creation_ip,NULL)

      
2 ms
subquery
dbqd.acs-subsite.tcl.subsite-callback-procs.subsite_callback.select_callbacks: select nsdb0
	select distinct callback, callback_type
	  from subsite_callbacks
	 where object_type in (select t2.object_type
	                         from acs_object_types t1, acs_object_types t2
	                        where t2.tree_sortkey <= t1.tree_sortkey
				  and t1.tree_sortkey between t2.tree_sortkey and tree_right(t2.tree_sortkey)
				  and t1.object_type = :object_type)
	   and event_type = :event_type
    
      
0 ms
subquery
getrow nsdb0
8 ms
subquery
dbqd.acs-tcl.tcl.site-node-apm-integration-procs.site_node_apm_integration::get_child_package_id.select_child_package_id: 0or1row nsdb0
            select sn1.object_id
            from site_nodes sn1,
                 apm_packages
            where sn1.parent_id = (select sn2.node_id
                                   from site_nodes sn2
                                   where sn2.object_id = :package_id)
            and sn1.object_id = apm_packages.package_id
            and apm_packages.package_key = :package_key
        
169 ms
subquery
dbqd.forums.tcl.messages-procs.forum::message::get.select_message: 0or1row nsdb0
            select forums_messages.*,
                   person__name(forums_messages.user_id) as user_name, 
                   party__email(forums_messages.user_id) as user_email,
                   forums_forum__name(forums_messages.forum_id) as forum_name, 
                   forums_message__root_message_id(forums_messages.message_id) as root_message_id,
                   (select fm2.subject
                    from forums_messages fm2 
                    where fm2.message_id = forums_message__root_message_id(forums_messages.message_id)) as root_subject, 
                   to_char(forums_messages.posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date
            from forums_messages
            where forums_messages.message_id= :message_id
        
3 ms
subquery
dbqd.acs-tcl.tcl.site-node-apm-integration-procs.site_node_apm_integration::get_child_package_id.select_child_package_id: 0or1row nsdb0
            select sn1.object_id
            from site_nodes sn1,
                 apm_packages
            where sn1.parent_id = (select sn2.node_id
                                   from site_nodes sn2
                                   where sn2.object_id = :package_id)
            and sn1.object_id = apm_packages.package_id
            and apm_packages.package_key = :package_key
        
165 ms
subquery
dbqd.forums.tcl.messages-procs.forum::message::get.select_message: 0or1row nsdb0
            select forums_messages.*,
                   person__name(forums_messages.user_id) as user_name, 
                   party__email(forums_messages.user_id) as user_email,
                   forums_forum__name(forums_messages.forum_id) as forum_name, 
                   forums_message__root_message_id(forums_messages.message_id) as root_message_id,
                   (select fm2.subject
                    from forums_messages fm2 
                    where fm2.message_id = forums_message__root_message_id(forums_messages.message_id)) as root_subject, 
                   to_char(forums_messages.posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date
            from forums_messages
            where forums_messages.message_id= :message_id
        
2 ms
subquery
dbqd.forums.tcl.messages-procs.forum::message::do_notifications.select_forums_package_url: 0or1row nsdb0
            select site_node__url(node_id)
            from site_nodes
            where object_id = (select package_id
                               from forums_forums
                               where forums_forums.forum_id = :forum_id)
        
1 ms
subquery
dbqd.notifications.tcl.notification-type-procs.notification::type::get_type_id.select_type_id: 0or1row nsdb0
            select type_id
            from notification_types
            where short_name = :short_name
        
2 ms
subquery
dbqd.notifications.tcl.notification-request-procs.notification::request::request_exists.request_count: 0or1row nsdb0
            select count(*)
            from notification_requests
            where type_id = :type_id
            and object_id = :object_id
        
1 ms
subquery
dbqd.notifications.tcl.notification-type-procs.notification::type::get_type_id.select_type_id: 0or1row nsdb0
            select type_id
            from notification_types
            where short_name = :short_name
        
2 ms
subquery
dbqd.notifications.tcl.notification-request-procs.notification::request::request_exists.request_count: 0or1row nsdb0
            select count(*)
            from notification_requests
            where type_id = :type_id
            and object_id = :object_id
        
2 ms
subquery
dbqd..NULL: 0or1row nsdb0
select min(forum_id) from forums_forums where package_id = :package_id
2 ms
subquery
dbqd..NULL: 0or1row nsdb0
 select message_id as parent_id from uu_message_map where key = :ref and forum_id = :forum_id
2 ms
subquery
dbqd..NULL: 0or1row nsdb0
select party_id as user_id from parties where email = :email
2 ms
subquery
dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_sequence: 0or1row nsdb0
      select nextval(:sequence) as nextval
      where (select relkind 
             from pg_class 
             where relname = :sequence) = 'S'
    
2 ms
subquery
dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_view: 0or1row nsdb0
      select nextval 
      from acs_object_id_seq
    
503 ms
subquery
dbqd.acs-tcl.tcl.community-core-procs.ad_user_new.user_insert: 0or1row nsdb0
	    select acs__add_user(
                         :user_id,
                         'user',
                         now(),
                         null,
	                 :peeraddr,
			 :email,
			 :url,
			 :first_names,
			 :last_name,
			 :hashed_password,
	                 :salt,
	                 :password_question,
	                 :password_answer,
                         null,
	                 :email_verified_p,
	                 :member_state);
	
      
3 ms
subquery
dbqd.acs-tcl.tcl.user-extensions-procs.acs_user_extension::list_extensions.select_extensions: select nsdb0
select impl_name from acs_sc_impls, acs_sc_bindings, acs_sc_contracts
where
acs_sc_impls.impl_id = acs_sc_bindings.impl_id and
acs_sc_contracts.contract_id= acs_sc_bindings.contract_id and 
acs_sc_contracts.contract_name='UserData'
0 ms
subquery
getrow nsdb0
0 ms
subquery
getrow nsdb0
2 ms
subquery
dbqd.acs-tcl.tcl.community-core-procs.cc_email_from_party.email_from_party: 0or1row nsdb0
      
	select email from parties where party_id = :party_id
    
      
2 ms
subquery
dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_sequence: 0or1row nsdb0
      select nextval(:sequence) as nextval
      where (select relkind 
             from pg_class 
             where relname = :sequence) = 'S'
    
1 ms
subquery
dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_view: 0or1row nsdb0
      select nextval 
      from acs_object_id_seq
    
2 ms
subquery
dbqd..NULL: dml nsdb0
insert into uu_message_map values (:new_id,:message_id, :forum_id)
1 ms
subquery
dbqd.acs-subsite.tcl.package-procs.package_instantiate_object.package_select: 0or1row nsdb0
      
      select t.package_name
      from acs_object_types t
      where t.object_type = :object_type
      
    
4 ms
main
dbqd.acs-subsite.tcl.plpgsql-utility-procs.plpgsql_utility::generate_attribute_parameter_call.get_function_args: select nsdb1
      select arg_name, arg_default
      from acs_function_args
      where function = upper(:function_name)
      order by arg_seq
    
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
60 ms
subquery
dbqd.acs-subsite.tcl.package-procs.package_instantiate_object.create_object: 0or1row nsdb0
	select forums_message__new(:message_id,'forums_message',:forum_id,:subject,:content,:html_p,:user_id,NULL,NULL,:parent_id,NULL,:creation_user,:creation_ip,NULL)

      
  0 ms     main   releasehandle nsdb1

  0 ms     subquery   releasehandle nsdb0

  0 ms     subquery   gethandle (returned nsdb0)
2 ms
subquery
dbqd.forums.tcl.messages-procs.forum::message::new.message_exists_p: 0or1row nsdb0
	  select count(message_id)
	  from forums_messages 
	  where message_id = :message_id
        
2 ms
subquery
dbqd..NULL: 0or1row nsdb0
select min(forum_id) from forums_forums where package_id = :package_id
2 ms
subquery
dbqd..NULL: 0or1row nsdb0
 select message_id as parent_id from uu_message_map where key = :ref and forum_id = :forum_id
2 ms
subquery
dbqd..NULL: 0or1row nsdb0
select party_id as user_id from parties where email = :email
2 ms
subquery
dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_sequence: 0or1row nsdb0
      select nextval(:sequence) as nextval
      where (select relkind 
             from pg_class 
             where relname = :sequence) = 'S'
    
1 ms
subquery
dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_view: 0or1row nsdb0
      select nextval 
      from acs_object_id_seq
    
491 ms
subquery
dbqd.acs-tcl.tcl.community-core-procs.ad_user_new.user_insert: 0or1row nsdb0
	    select acs__add_user(
                         :user_id,
                         'user',
                         now(),
                         null,
	                 :peeraddr,
			 :email,
			 :url,
			 :first_names,
			 :last_name,
			 :hashed_password,
	                 :salt,
	                 :password_question,
	                 :password_answer,
                         null,
	                 :email_verified_p,
	                 :member_state);
	
      
7 ms
subquery
dbqd.acs-tcl.tcl.user-extensions-procs.acs_user_extension::list_extensions.select_extensions: select nsdb0
select impl_name from acs_sc_impls, acs_sc_bindings, acs_sc_contracts
where
acs_sc_impls.impl_id = acs_sc_bindings.impl_id and
acs_sc_contracts.contract_id= acs_sc_bindings.contract_id and 
acs_sc_contracts.contract_name='UserData'
0 ms
subquery
getrow nsdb0
0 ms
subquery
getrow nsdb0
1 ms
subquery
dbqd.acs-tcl.tcl.community-core-procs.cc_email_from_party.email_from_party: 0or1row nsdb0
      
	select email from parties where party_id = :party_id
    
      
2 ms
subquery
dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_sequence: 0or1row nsdb0
      select nextval(:sequence) as nextval
      where (select relkind 
             from pg_class 
             where relname = :sequence) = 'S'
    
2 ms
subquery
dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_view: 0or1row nsdb0
      select nextval 
      from acs_object_id_seq
    
2 ms
subquery
dbqd..NULL: dml nsdb0
insert into uu_message_map values (:new_id,:message_id, :forum_id)
1 ms
subquery
dbqd.acs-subsite.tcl.package-procs.package_instantiate_object.package_select: 0or1row nsdb0
      
      select t.package_name
      from acs_object_types t
      where t.object_type = :object_type
      
    
0 ms main gethandle (returned nsdb1)
4 ms
main
dbqd.acs-subsite.tcl.plpgsql-utility-procs.plpgsql_utility::generate_attribute_parameter_call.get_function_args: select nsdb1
      select arg_name, arg_default
      from acs_function_args
      where function = upper(:function_name)
      order by arg_seq
    
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
247 ms
subquery
dbqd.acs-subsite.tcl.package-procs.package_instantiate_object.create_object: 0or1row nsdb0
	select forums_message__new(:message_id,'forums_message',:forum_id,:subject,:content,:html_p,:user_id,NULL,NULL,:parent_id,NULL,:creation_user,:creation_ip,NULL)

      
2 ms
subquery
dbqd.acs-subsite.tcl.subsite-callback-procs.subsite_callback.select_callbacks: select nsdb0
	select distinct callback, callback_type
	  from subsite_callbacks
	 where object_type in (select t2.object_type
	                         from acs_object_types t1, acs_object_types t2
	                        where t2.tree_sortkey <= t1.tree_sortkey
				  and t1.tree_sortkey between t2.tree_sortkey and tree_right(t2.tree_sortkey)
				  and t1.object_type = :object_type)
	   and event_type = :event_type
    
      
0 ms
subquery
getrow nsdb0
3 ms
subquery
dbqd.acs-tcl.tcl.site-node-apm-integration-procs.site_node_apm_integration::get_child_package_id.select_child_package_id: 0or1row nsdb0
            select sn1.object_id
            from site_nodes sn1,
                 apm_packages
            where sn1.parent_id = (select sn2.node_id
                                   from site_nodes sn2
                                   where sn2.object_id = :package_id)
            and sn1.object_id = apm_packages.package_id
            and apm_packages.package_key = :package_key
        
165 ms
subquery
dbqd.forums.tcl.messages-procs.forum::message::get.select_message: 0or1row nsdb0
            select forums_messages.*,
                   person__name(forums_messages.user_id) as user_name, 
                   party__email(forums_messages.user_id) as user_email,
                   forums_forum__name(forums_messages.forum_id) as forum_name, 
                   forums_message__root_message_id(forums_messages.message_id) as root_message_id,
                   (select fm2.subject
                    from forums_messages fm2 
                    where fm2.message_id = forums_message__root_message_id(forums_messages.message_id)) as root_subject, 
                   to_char(forums_messages.posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date
            from forums_messages
            where forums_messages.message_id= :message_id
        
3 ms
subquery
dbqd.acs-tcl.tcl.site-node-apm-integration-procs.site_node_apm_integration::get_child_package_id.select_child_package_id: 0or1row nsdb0
            select sn1.object_id
            from site_nodes sn1,
                 apm_packages
            where sn1.parent_id = (select sn2.node_id
                                   from site_nodes sn2
                                   where sn2.object_id = :package_id)
            and sn1.object_id = apm_packages.package_id
            and apm_packages.package_key = :package_key
        
170 ms
subquery
dbqd.forums.tcl.messages-procs.forum::message::get.select_message: 0or1row nsdb0
            select forums_messages.*,
                   person__name(forums_messages.user_id) as user_name, 
                   party__email(forums_messages.user_id) as user_email,
                   forums_forum__name(forums_messages.forum_id) as forum_name, 
                   forums_message__root_message_id(forums_messages.message_id) as root_message_id,
                   (select fm2.subject
                    from forums_messages fm2 
                    where fm2.message_id = forums_message__root_message_id(forums_messages.message_id)) as root_subject, 
                   to_char(forums_messages.posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date
            from forums_messages
            where forums_messages.message_id= :message_id
        
2 ms
subquery
dbqd.forums.tcl.messages-procs.forum::message::do_notifications.select_forums_package_url: 0or1row nsdb0
            select site_node__url(node_id)
            from site_nodes
            where object_id = (select package_id
                               from forums_forums
                               where forums_forums.forum_id = :forum_id)
        
1 ms
subquery
dbqd.notifications.tcl.notification-type-procs.notification::type::get_type_id.select_type_id: 0or1row nsdb0
            select type_id
            from notification_types
            where short_name = :short_name
        
2 ms
subquery
dbqd.notifications.tcl.notification-request-procs.notification::request::request_exists.request_count: 0or1row nsdb0
            select count(*)
            from notification_requests
            where type_id = :type_id
            and object_id = :object_id
        
1 ms
subquery
dbqd.notifications.tcl.notification-type-procs.notification::type::get_type_id.select_type_id: 0or1row nsdb0
            select type_id
            from notification_types
            where short_name = :short_name
        
2 ms
subquery
dbqd.notifications.tcl.notification-request-procs.notification::request::request_exists.request_count: 0or1row nsdb0
            select count(*)
            from notification_requests
            where type_id = :type_id
            and object_id = :object_id
        
2 ms
subquery
dbqd..NULL: 0or1row nsdb0
select min(forum_id) from forums_forums where package_id = :package_id
2 ms
subquery
dbqd..NULL: 0or1row nsdb0
 select message_id as parent_id from uu_message_map where key = :ref and forum_id = :forum_id
2 ms
subquery
dbqd..NULL: 0or1row nsdb0
select party_id as user_id from parties where email = :email
2 ms
subquery
dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_sequence: 0or1row nsdb0
      select nextval(:sequence) as nextval
      where (select relkind 
             from pg_class 
             where relname = :sequence) = 'S'
    
4 ms
subquery
dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_view: 0or1row nsdb0
      select nextval 
      from acs_object_id_seq
    
473 ms
subquery
dbqd.acs-tcl.tcl.community-core-procs.ad_user_new.user_insert: 0or1row nsdb0
	    select acs__add_user(
                         :user_id,
                         'user',
                         now(),
                         null,
	                 :peeraddr,
			 :email,
			 :url,
			 :first_names,
			 :last_name,
			 :hashed_password,
	                 :salt,
	                 :password_question,
	                 :password_answer,
                         null,
	                 :email_verified_p,
	                 :member_state);
	
      
3 ms
subquery
dbqd.acs-tcl.tcl.user-extensions-procs.acs_user_extension::list_extensions.select_extensions: select nsdb0
select impl_name from acs_sc_impls, acs_sc_bindings, acs_sc_contracts
where
acs_sc_impls.impl_id = acs_sc_bindings.impl_id and
acs_sc_contracts.contract_id= acs_sc_bindings.contract_id and 
acs_sc_contracts.contract_name='UserData'
0 ms
subquery
getrow nsdb0
0 ms
subquery
getrow nsdb0
1 ms
subquery
dbqd.acs-tcl.tcl.community-core-procs.cc_email_from_party.email_from_party: 0or1row nsdb0
      
	select email from parties where party_id = :party_id
    
      
2 ms
subquery
dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_sequence: 0or1row nsdb0
      select nextval(:sequence) as nextval
      where (select relkind 
             from pg_class 
             where relname = :sequence) = 'S'
    
2 ms
subquery
dbqd.acs-tcl.tcl.00-database-procs-postgresql.db_nextval.nextval_view: 0or1row nsdb0
      select nextval 
      from acs_object_id_seq
    
2 ms
subquery
dbqd..NULL: dml nsdb0
insert into uu_message_map values (:new_id,:message_id, :forum_id)
1 ms
subquery
dbqd.acs-subsite.tcl.package-procs.package_instantiate_object.package_select: 0or1row nsdb0
      
      select t.package_name
      from acs_object_types t
      where t.object_type = :object_type
      
    
4 ms
main
dbqd.acs-subsite.tcl.plpgsql-utility-procs.plpgsql_utility::generate_attribute_parameter_call.get_function_args: select nsdb1
      select arg_name, arg_default
      from acs_function_args
      where function = upper(:function_name)
      order by arg_seq
    
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
0 ms
main
getrow nsdb1
232 ms
subquery
dbqd.acs-subsite.tcl.package-procs.package_instantiate_object.create_object: 0or1row nsdb0
	select forums_message__new(:message_id,'forums_message',:forum_id,:subject,:content,:html_p,:user_id,NULL,NULL,:parent_id,NULL,:creation_user,:creation_ip,NULL)

      
2 ms
subquery
dbqd.acs-subsite.tcl.subsite-callback-procs.subsite_callback.select_callbacks: select nsdb0
	select distinct callback, callback_type
	  from subsite_callbacks
	 where object_type in (select t2.object_type
	                         from acs_object_types t1, acs_object_types t2
	                        where t2.tree_sortkey <= t1.tree_sortkey
				  and t1.tree_sortkey between t2.tree_sortkey and tree_right(t2.tree_sortkey)
				  and t1.object_type = :object_type)
	   and event_type = :event_type
    
      
0 ms
subquery
getrow nsdb0
5 ms
subquery
dbqd.acs-tcl.tcl.site-node-apm-integration-procs.site_node_apm_integration::get_child_package_id.select_child_package_id: 0or1row nsdb0
            select sn1.object_id
            from site_nodes sn1,
                 apm_packages
            where sn1.parent_id = (select sn2.node_id
                                   from site_nodes sn2
                                   where sn2.object_id = :package_id)
            and sn1.object_id = apm_packages.package_id
            and apm_packages.package_key = :package_key
        
173 ms
subquery
dbqd.forums.tcl.messages-procs.forum::message::get.select_message: 0or1row nsdb0
            select forums_messages.*,
                   person__name(forums_messages.user_id) as user_name, 
                   party__email(forums_messages.user_id) as user_email,
                   forums_forum__name(forums_messages.forum_id) as forum_name, 
                   forums_message__root_message_id(forums_messages.message_id) as root_message_id,
                   (select fm2.subject
                    from forums_messages fm2 
                    where fm2.message_id = forums_message__root_message_id(forums_messages.message_id)) as root_subject, 
                   to_char(forums_messages.posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date
            from forums_messages
            where forums_messages.message_id= :message_id
        
3 ms
subquery
dbqd.acs-tcl.tcl.site-node-apm-integration-procs.site_node_apm_integration::get_child_package_id.select_child_package_id: 0or1row nsdb0
            select sn1.object_id
            from site_nodes sn1,
                 apm_packages
            where sn1.parent_id = (select sn2.node_id
                                   from site_nodes sn2
                                   where sn2.object_id = :package_id)
            and sn1.object_id = apm_packages.package_id
            and apm_packages.package_key = :package_key
        
168 ms
subquery
dbqd.forums.tcl.messages-procs.forum::message::get.select_message: 0or1row nsdb0
            select forums_messages.*,
                   person__name(forums_messages.user_id) as user_name, 
                   party__email(forums_messages.user_id) as user_email,
                   forums_forum__name(forums_messages.forum_id) as forum_name, 
                   forums_message__root_message_id(forums_messages.message_id) as root_message_id,
                   (select fm2.subject
                    from forums_messages fm2 
                    where fm2.message_id = forums_message__root_message_id(forums_messages.message_id)) as root_subject, 
                   to_char(forums_messages.posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date
            from forums_messages
            where forums_messages.message_id= :message_id
        
2 ms subquery&