Skip to content

Instantly share code, notes, and snippets.

@orlandov

orlandov/node-sqlite profile

Created March 18, 2010 00:57
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save orlandov/335924 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save orlandov/335924 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
node-sqlite profile
line 730: unknown command: .str.split.
line 731: unknown command: .map.join.
line 732: unknown command: /usr/local/lib/node/libraries/sys.js:139"
Statistical profiling result from v8.log, (9844 ticks, 633 unaccounted, 0 excluded).
[Unknown]:
ticks total nonlib name
633 6.4%
[Shared libraries]:
ticks total nonlib name
[JavaScript]:
ticks total nonlib name
114 1.2% 1.2% Function: _doStep /Users/orlando/projects/node-sqlite/sqlite.js:91
53 0.5% 0.5% Function: Database.executeQuery /Users/orlando/projects/node-sqlite/sqlite.js:121
47 0.5% 0.5% LazyCompile: <anonymous> node.js:1
47 0.5% 0.5% Function: _queryDone /Users/orlando/projects/node-sqlite/sqlite.js:76
20 0.2% 0.2% Stub: FastNewContextStub {1}
17 0.2% 0.2% Function: <anonymous> /Users/orlando/projects/node-sqlite/sqlite.js:92
16 0.2% 0.2% Stub: JSEntry {1}
14 0.1% 0.1% Builtin: A builtin from the snapshot
13 0.1% 0.1% Stub: CEntry
11 0.1% 0.1% Stub: FastNewClosure
11 0.1% 0.1% Function: <anonymous> /Users/orlando/projects/node-sqlite/sqlite.js:84
6 0.1% 0.1% Function: _onPrepare /Users/orlando/projects/node-sqlite/sqlite.js:106
6 0.1% 0.1% Function: Database.dispatch /Users/orlando/projects/node-sqlite/sqlite.js:30
5 0.1% 0.1% Stub: CallFunction {1}
5 0.1% 0.1% Function: <anonymous> /Users/orlando/projects/node-sqlite/sqlite.js:129
4 0.0% 0.0% Stub: FastNewContextStub
4 0.0% 0.0% LazyCompile: ConfigureTemplateInstance native apinatives.js:93
4 0.0% 0.0% LazyCompile: APPLY_PREPARE native runtime.js:415
4 0.0% 0.0% Builtin: A builtin from the snapshot {4}
4 0.0% 0.0% Builtin: A builtin from the snapshot {1}
3 0.0% 0.0% Stub: JSEntry
3 0.0% 0.0% Stub: CallFunction {2}
3 0.0% 0.0% Stub: CallFunction
3 0.0% 0.0% Function: Database.query /Users/orlando/projects/node-sqlite/sqlite.js:51
3 0.0% 0.0% Function: <anonymous> /Users/orlando/projects/node-sqlite/test3.js:30
3 0.0% 0.0% Function: <anonymous> /Users/orlando/projects/node-sqlite/test3.js:12
2 0.0% 0.0% Stub: FastCloneShallowArrayStub
2 0.0% 0.0% Stub: FastCloneShallowArray
2 0.0% 0.0% Stub: CallFunction {3}
2 0.0% 0.0% LazyCompile: isArray native array.js:1087
2 0.0% 0.0% Function: innerFunction /Users/orlando/projects/node-sqlite/test3.js:29
2 0.0% 0.0% Builtin: A builtin from the snapshot {2}
1 0.0% 0.0% Stub: ToBoolean
1 0.0% 0.0% KeyedLoadIC: A keyed load IC from the snapshot
1 0.0% 0.0% Function: process.EventEmitter.addListener node.js:172
1 0.0% 0.0% Function: <anonymous> /Users/orlando/projects/node-sqlite/sqlite.js:25
1 0.0% 0.0% Builtin: A builtin from the snapshot {6}
1 0.0% 0.0% Builtin: A builtin from the snapshot {5}
1 0.0% 0.0% Builtin: A builtin from the snapshot {3}
[C++]:
ticks total nonlib name
4673 47.5% 47.5% _csinh$fenv_access_off
1117 11.3% 11.3% __mh_dylib_header
543 5.5% 5.5% _szone_free
383 3.9% 3.9% node::Loop
383 3.9% 3.9% ___sfvwrite
228 2.3% 2.3% _szone_malloc_should_clear
213 2.2% 2.2% _ev_loop
90 0.9% 0.9% _eio_poll
85 0.9% 0.9% _select_poll
54 0.5% 0.5% v8::internal::Builtin_HandleApiCall
52 0.5% 0.5% _ev_invoke_pending
51 0.5% 0.5% _pthread_mutex_lock
50 0.5% 0.5% v8::internal::Invoke
40 0.4% 0.4% _szone_free_definite_size
39 0.4% 0.4% v8::Function::Call
38 0.4% 0.4% _create_scalable_zone
37 0.4% 0.4% _ev_feed_event
35 0.4% 0.4% _pipecb
31 0.3% 0.3% v8::HandleScope::HandleScope
26 0.3% 0.3% v8::internal::StackFrameIterator::StackFrameIterator
25 0.3% 0.3% v8::internal::DescriptorArray::BinarySearch
20 0.2% 0.2% v8::internal::Heap::ScavengeObjectSlow
20 0.2% 0.2% _etp_submit
19 0.2% 0.2% v8::internal::Logger::ApiEntryCall
19 0.2% 0.2% v8::internal::GlobalHandles::ClearWeakness
18 0.2% 0.2% ___svfscanf_l
17 0.2% 0.2% v8::internal::Heap::AllocateStringFromUtf8
17 0.2% 0.2% _semaphore_create
17 0.2% 0.2% _extract_service
16 0.2% 0.2% v8::internal::ScavengeVisitor::VisitPointer
16 0.2% 0.2% v8::internal::JSObject::SetProperty
16 0.2% 0.2% v8::internal::HashTable<v8::internal::NumberDictionaryShape, unsigned int>::FindEntry
16 0.2% 0.2% v8::Undefined
16 0.2% 0.2% _tiny_malloc_from_free_list
16 0.2% 0.2% __dispatch_queue_set_width_init
15 0.2% 0.2% v8::internal::ScavengeVisitor::VisitPointers
15 0.2% 0.2% v8::internal::JSObject::LocalLookupRealNamedProperty
15 0.2% 0.2% v8::internal::GlobalHandles::Create
14 0.1% 0.1% v8::internal::StackFrameIterator::AdvanceWithHandler
14 0.1% 0.1% v8::internal::Heap::AllocateFixedArray
14 0.1% 0.1% _eio_finish
13 0.1% 0.1% v8::internal::String::ReadBlock
13 0.1% 0.1% v8::internal::JSObject::LookupInDescriptor
13 0.1% 0.1% v8::TryCatch::HasCaught
12 0.1% 0.1% v8::TryCatch::~TryCatch
12 0.1% 0.1% v8::TryCatch::TryCatch
12 0.1% 0.1% v8::Object::SetInternalField
12 0.1% 0.1% v8::Object::InternalFieldCount
12 0.1% 0.1% _pthread_mutex_unlock
12 0.1% 0.1% _eio_custom
11 0.1% 0.1% v8::internal::Top::UnregisterTryCatchHandler
11 0.1% 0.1% v8::internal::String::ComputeHashField
11 0.1% 0.1% v8::internal::Runtime::GetObjectProperty
11 0.1% 0.1% v8::internal::Logger::HandleEvent
11 0.1% 0.1% v8::V8::GlobalizeReference
11 0.1% 0.1% v8::Object::Set
11 0.1% 0.1% v8::HandleScope::~HandleScope
11 0.1% 0.1% node::ObjectWrap::Unref
11 0.1% 0.1% _malloc_zone_malloc
11 0.1% 0.1% _ev_unref
11 0.1% 0.1% _calloc
10 0.1% 0.1% v8::internal::JSObject::LocalLookup
10 0.1% 0.1% _DNSServiceProcessResult
9 0.1% 0.1% node::DonePollNotifier
9 0.1% 0.1% _szone_calloc
9 0.1% 0.1% _strcmp
9 0.1% 0.1% _catanh$fenv_access_off
9 0.1% 0.1% __keymgr_set_and_unlock_processwide_ptr
8 0.1% 0.1% v8::internal::String::SlowEquals
8 0.1% 0.1% v8::internal::Runtime::SetObjectProperty
8 0.1% 0.1% v8::internal::JSObject::AddFastPropertyUsingMap
8 0.1% 0.1% v8::internal::GlobalHandles::Destroy
8 0.1% 0.1% v8::String::New
8 0.1% 0.1% v8::HandleScope::RawClose
8 0.1% 0.1% node::ObjectWrap::Ref
8 0.1% 0.1% _szone_size
8 0.1% 0.1% _ev_ref
8 0.1% 0.1% _dyld_register_image_state_change_handler
8 0.1% 0.1% __mdns_search
7 0.1% 0.1% v8::internal::Object::GetProperty
7 0.1% 0.1% v8::internal::MarkCompactCollector::SweepSpaces
7 0.1% 0.1% v8::internal::Heap::AllocateProxy
7 0.1% 0.1% v8::internal::GlobalHandles::MakeWeak
7 0.1% 0.1% v8::internal::Builtin_HandleApiCallConstruct
7 0.1% 0.1% v8::String::WriteUtf8
7 0.1% 0.1% node::WantPollNotifier
7 0.1% 0.1% _malloc_zone_calloc
7 0.1% 0.1% _getsectdatafromheader
7 0.1% 0.1% _arc4random
7 0.1% 0.1% _arc4_stir
6 0.1% 0.1% v8::internal::Top::global_context
6 0.1% 0.1% v8::internal::String::SlowAsArrayIndex
6 0.1% 0.1% v8::internal::StackFrame::ComputeType
6 0.1% 0.1% v8::internal::MarkingVisitor::VisitPointers
6 0.1% 0.1% v8::internal::Logger::ApiObjectAccess
6 0.1% 0.1% v8::internal::JavaScriptFrame::type
6 0.1% 0.1% v8::internal::Heap::DoScavenge
6 0.1% 0.1% v8::internal::ExitFrame::ComputeCallerState
6 0.1% 0.1% v8::internal::Execution::InstantiateFunction
6 0.1% 0.1% v8::internal::CodeStub::FindCodeInCache
6 0.1% 0.1% v8::Value::IsFunction
6 0.1% 0.1% v8::Integer::New
6 0.1% 0.1% dyldGlobalLockAcquire
6 0.1% 0.1% _y1
6 0.1% 0.1% _libdispatch_init
6 0.1% 0.1% _ev_async_send
5 0.1% 0.1% v8::internal::SetProperty
5 0.1% 0.1% v8::internal::ExitFrame::GetStateForFramePointer
5 0.1% 0.1% v8::internal::Execution::Call
5 0.1% 0.1% v8::internal::ComputeIntegerHash
5 0.1% 0.1% v8::internal::CodeStub::has_custom_cache
5 0.1% 0.1% v8::V8::DisposeGlobal
5 0.1% 0.1% v8::True
5 0.1% 0.1% unibrow::Utf8::ReadBlock
5 0.1% 0.1% _malloc_zone_register_while_locked
5 0.1% 0.1% LockHelper::LockHelper
4 0.0% 0.0% v8::internal::Top::RegisterTryCatchHandler
4 0.0% 0.0% v8::internal::StackFrame::GetCallerState
4 0.0% 0.0% v8::internal::Object::Lookup
4 0.0% 0.0% v8::internal::JSObject::GetElementWithReceiver
4 0.0% 0.0% v8::internal::Heap::AllocateRaw
4 0.0% 0.0% v8::internal::ExitFrame::GetCallerStackPointer
4 0.0% 0.0% v8::Value::ToString
4 0.0% 0.0% v8::V8::MakeWeak
4 0.0% 0.0% v8::String::Utf8Value::Utf8Value
4 0.0% 0.0% v8::External::Value
4 0.0% 0.0% dyldGlobalLockInitialize
4 0.0% 0.0% _mag_lock_zine_for_region_trailer
4 0.0% 0.0% _host_info
4 0.0% 0.0% _getsectbynamefromheader
4 0.0% 0.0% _get_uint32
4 0.0% 0.0% _atexit_register
4 0.0% 0.0% __pthread_mutex_init
4 0.0% 0.0% __dyld_register_func_for_add_image
3 0.0% 0.0% v8::internal::SweepSpace
3 0.0% 0.0% v8::internal::Runtime_GetTemplateField
3 0.0% 0.0% v8::internal::Runtime::GetElementOrCharAt
3 0.0% 0.0% v8::internal::Object::GetPrototype
3 0.0% 0.0% v8::internal::Object::GetElementWithReceiver
3 0.0% 0.0% v8::internal::HeapObject::IterateBody
3 0.0% 0.0% v8::internal::Heap::AllocateJSObject
3 0.0% 0.0% v8::internal::Factory::NewProxy
3 0.0% 0.0% v8::internal::CodeStub::GetCode
3 0.0% 0.0% v8::internal::ArrayPrototypeHasNoElements
3 0.0% 0.0% v8::Value::IsExternal
3 0.0% 0.0% v8::V8::ClearWeak
3 0.0% 0.0% v8::Context::Global
3 0.0% 0.0% unibrow::InputBuffer<v8::internal::String, v8::internal::String*, 1024u>::FillBuffer
3 0.0% 0.0% node::ReallyEmit
3 0.0% 0.0% _strrchr
3 0.0% 0.0% _pthread_mutexattr_init
3 0.0% 0.0% _malloc_set_zone_name
3 0.0% 0.0% _eio_api_destroy
3 0.0% 0.0% __malloc_initialize
3 0.0% 0.0% ___cxa_get_globals
2 0.0% 0.0% v8::internal::Utf8SymbolKey::Hash
2 0.0% 0.0% v8::internal::Scanner::ScanIdentifier
2 0.0% 0.0% v8::internal::RootMarkingVisitor::VisitPointer
2 0.0% 0.0% v8::internal::OldSpace::SlowAllocateRaw
2 0.0% 0.0% v8::internal::InternalFrame::type
2 0.0% 0.0% v8::internal::Heap::UpdateRSet
2 0.0% 0.0% v8::internal::GlobalHandles::IterateAllRoots
2 0.0% 0.0% v8::internal::FreeListNode::set_size
2 0.0% 0.0% v8::internal::Execution::New
2 0.0% 0.0% v8::internal::Execution::ConfigureInstance
2 0.0% 0.0% v8::internal::Context::global_proxy
2 0.0% 0.0% v8::internal::Builtin_ArrayShift
2 0.0% 0.0% v8::String::Utf8Value::~Utf8Value
2 0.0% 0.0% v8::Object::Get
2 0.0% 0.0% v8::Function::NewInstance
2 0.0% 0.0% unibrow::InputBuffer<unibrow::Utf8, unibrow::Buffer<char const*>, 1024u>::FillBuffer
2 0.0% 0.0% read_encoded_value_with_base
2 0.0% 0.0% node::EIODonePoll
2 0.0% 0.0% names_match
2 0.0% 0.0% _strcpy
2 0.0% 0.0% _pthread_mutex_init
2 0.0% 0.0% _ev_idle_stop
2 0.0% 0.0% _d_print_comp
2 0.0% 0.0% __dyld_initializer
1 0.0% 0.0% v8::internal::WithEnterStatement::Accept
1 0.0% 0.0% v8::internal::VirtualFrame::PrepareForReturn
1 0.0% 0.0% v8::internal::UpdateRSetVisitor::VisitPointer
1 0.0% 0.0% v8::internal::SymbolTable::LookupSymbol
1 0.0% 0.0% v8::internal::String::ToAsciiVector
1 0.0% 0.0% v8::internal::String::IsEqualTo
1 0.0% 0.0% v8::internal::Scanner::ScanJavaScript
1 0.0% 0.0% v8::internal::Result::ToRegister
1 0.0% 0.0% v8::internal::RelocIterator::next
1 0.0% 0.0% v8::internal::Parser::ParseSourceElements
1 0.0% 0.0% v8::internal::OldSpaceFreeList::Allocate
1 0.0% 0.0% v8::internal::OldSpace::PageAllocationTop
1 0.0% 0.0% v8::internal::Object::GetPropertyWithReceiver
1 0.0% 0.0% v8::internal::MoveElements
1 0.0% 0.0% v8::internal::MemoryAllocator::AllocatePages
1 0.0% 0.0% v8::internal::MarkingVisitor::VisitPointer
1 0.0% 0.0% v8::internal::MarkCompactCollector::MarkUnmarkedObject
1 0.0% 0.0% v8::internal::MarkCompactCollector::IsUnmarkedHeapObject
1 0.0% 0.0% v8::internal::MarkCompactCollector::EmptyMarkingStack
1 0.0% 0.0% v8::internal::MarkCompactCollector::DeallocateOldPointerBlock
1 0.0% 0.0% v8::internal::Logger::CodeCreateEvent
1 0.0% 0.0% v8::internal::LoadIC::Load
1 0.0% 0.0% v8::internal::JumpTarget::DoBranch
1 0.0% 0.0% v8::internal::JumpTarget::DoBind
1 0.0% 0.0% v8::internal::JumpTarget::ComputeEntryFrame
1 0.0% 0.0% v8::internal::JumpTarget::AddReachingFrame
1 0.0% 0.0% v8::internal::JSEntryStub::MinorKey
1 0.0% 0.0% v8::internal::Heap::IterateRSet
1 0.0% 0.0% v8::internal::HashTable<v8::internal::StringDictionaryShape, v8::internal::String*>::FindEntry
1 0.0% 0.0% v8::internal::GlobalHandles::PostGarbageCollectionProcessing
1 0.0% 0.0% v8::internal::GlobalHandles::IterateStrongRoots
1 0.0% 0.0% v8::internal::GlobalHandles::IdentifyWeakHandles
1 0.0% 0.0% v8::internal::Factory::NewStringFromUtf8
1 0.0% 0.0% v8::internal::Factory::NewJSObject
1 0.0% 0.0% v8::internal::Factory::ConfigureInstance
1 0.0% 0.0% v8::internal::ExternalStringUTF16Buffer<v8::internal::ExternalAsciiString, char>::Advance
1 0.0% 0.0% v8::internal::ExitFrame::type
1 0.0% 0.0% v8::internal::ExecutionAccess::ExecutionAccess
1 0.0% 0.0% v8::internal::Context::global_context
1 0.0% 0.0% v8::internal::Context::builtins
1 0.0% 0.0% v8::internal::CodeGenerator::Load
1 0.0% 0.0% v8::internal::CallIC::UpdateCaches
1 0.0% 0.0% v8::internal::Builtin_ArrayPush
1 0.0% 0.0% v8::internal::Assembler::movq
1 0.0% 0.0% v8::Value::IsObject
1 0.0% 0.0% v8::V8::IsGlobalNearDeath
1 0.0% 0.0% v8::Object::New
1 0.0% 0.0% v8::HandleScope::CreateHandle
1 0.0% 0.0% v8::FunctionTemplate::GetFunction
1 0.0% 0.0% v8::Context::GetCurrent
1 0.0% 0.0% node::ObjectWrap::WeakCallback
1 0.0% 0.0% node::EventEmitter::Emit
1 0.0% 0.0% get_adjusted_ptr
1 0.0% 0.0% _select$NOCANCEL$UNIX2003
1 0.0% 0.0% _powl$fenv_access_off
1 0.0% 0.0% _d_print_cast
1 0.0% 0.0% _casinhl$fenv_access_off
1 0.0% 0.0% __dyld_register_func_for_remove_image
1 0.0% 0.0% ___vfprintf
1 0.0% 0.0% ___cxa_atexit
[GC]:
ticks total nonlib name
99 1.0%
[Bottom up (heavy) profile]:
Note: percentage shows a share of a particular caller in the total
amount of its parent calls.
Callers occupying less than 2.0% are not shown.
ticks parent name
4673 47.5% _csinh$fenv_access_off
4673 100.0% node::Loop
4673 100.0% LazyCompile: <anonymous> node.js:1
1117 11.3% __mh_dylib_header
404 36.2% Function: _doStep /Users/orlando/projects/node-sqlite/sqlite.js:91
229 56.7% Function: _onPrepare /Users/orlando/projects/node-sqlite/sqlite.js:106
229 100.0% Function: <anonymous> /Users/orlando/projects/node-sqlite/sqlite.js:129
229 100.0% LazyCompile: <anonymous> node.js:1
175 43.3% Function: <anonymous> /Users/orlando/projects/node-sqlite/sqlite.js:92
175 100.0% LazyCompile: <anonymous> node.js:1
396 35.5% node::Loop
396 100.0% LazyCompile: <anonymous> node.js:1
162 14.5% Function: _queryDone /Users/orlando/projects/node-sqlite/sqlite.js:76
162 100.0% Function: <anonymous> /Users/orlando/projects/node-sqlite/sqlite.js:92
162 100.0% LazyCompile: <anonymous> node.js:1
154 13.8% Function: Database.executeQuery /Users/orlando/projects/node-sqlite/sqlite.js:121
154 100.0% Function: Database.dispatch /Users/orlando/projects/node-sqlite/sqlite.js:30
154 100.0% Function: <anonymous> /Users/orlando/projects/node-sqlite/sqlite.js:25
154 100.0% Function: <anonymous> /Users/orlando/projects/node-sqlite/sqlite.js:84
154 100.0% LazyCompile: <anonymous> node.js:1
543 5.5% _szone_free
528 97.2% node::Loop
528 100.0% LazyCompile: <anonymous> node.js:1
383 3.9% node::Loop
383 100.0% LazyCompile: <anonymous> node.js:1
383 3.9% ___sfvwrite
383 100.0% node::Loop
383 100.0% LazyCompile: <anonymous> node.js:1
228 2.3% _szone_malloc_should_clear
170 74.6% node::Loop
170 100.0% LazyCompile: <anonymous> node.js:1
29 12.7% Function: _doStep /Users/orlando/projects/node-sqlite/sqlite.js:91
16 55.2% Function: _onPrepare /Users/orlando/projects/node-sqlite/sqlite.js:106
16 100.0% Function: <anonymous> /Users/orlando/projects/node-sqlite/sqlite.js:129
16 100.0% LazyCompile: <anonymous> node.js:1
13 44.8% Function: <anonymous> /Users/orlando/projects/node-sqlite/sqlite.js:92
13 100.0% LazyCompile: <anonymous> node.js:1
15 6.6% Function: Database.executeQuery /Users/orlando/projects/node-sqlite/sqlite.js:121
15 100.0% Function: Database.dispatch /Users/orlando/projects/node-sqlite/sqlite.js:30
15 100.0% Function: <anonymous> /Users/orlando/projects/node-sqlite/sqlite.js:25
15 100.0% Function: <anonymous> /Users/orlando/projects/node-sqlite/sqlite.js:84
15 100.0% LazyCompile: <anonymous> node.js:1
12 5.3% Function: _queryDone /Users/orlando/projects/node-sqlite/sqlite.js:76
12 100.0% Function: <anonymous> /Users/orlando/projects/node-sqlite/sqlite.js:92
12 100.0% LazyCompile: <anonymous> node.js:1
213 2.2% _ev_loop
213 100.0% node::Loop
213 100.0% LazyCompile: <anonymous> node.js:1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment