Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:93102 Return-Path: Mailing-List: contact internals-help@lists.php.net; run by ezmlm Delivered-To: mailing list internals@lists.php.net Received: (qmail 82365 invoked from network); 7 May 2016 00:06:24 -0000 Received: from unknown (HELO lists.php.net) (127.0.0.1) by localhost with SMTP; 7 May 2016 00:06:24 -0000 Authentication-Results: pb1.pair.com smtp.mail=smalyshev@gmail.com; spf=pass; sender-id=pass Authentication-Results: pb1.pair.com header.from=smalyshev@gmail.com; sender-id=pass Received-SPF: pass (pb1.pair.com: domain gmail.com designates 209.85.220.51 as permitted sender) X-PHP-List-Original-Sender: smalyshev@gmail.com X-Host-Fingerprint: 209.85.220.51 mail-pa0-f51.google.com Received: from [209.85.220.51] ([209.85.220.51:34317] helo=mail-pa0-f51.google.com) by pb1.pair.com (ecelerity 2.1.1.9-wez r(12769M)) with ESMTP id 72/81-53854-F713D275 for ; Fri, 06 May 2016 20:06:23 -0400 Received: by mail-pa0-f51.google.com with SMTP id r5so53511606pag.1 for ; Fri, 06 May 2016 17:06:23 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-transfer-encoding; bh=TmpwV5hYKe1zzhR8AYW+JLk6c3ElpHUwLq0C7LxmtH0=; b=Amk7Q1b8HhsxtA6+O7Vyu57O4/CisbJG0CrUM7Lng9+vQvew8Tuh3mqHm65jrQnC3f oxduxXp5TsxQha2kfi2cnzn9IsdglGBCsrPNZ/+JyKQiiYgsjVxE2wHtSjF+I3kO5LW+ 4T8Cu6DjxIrM6tKoko4McHZuWC5Qb6YLETxSFkttSMlduFC5/cuDrM4RwQ5W+KsF7MBQ myUakq60g/tP7VL0VQVyFftSeCq3NxjP5aNQGHCrOLB9lTxXC7VHmFpF1x3kZQpYf36G IKaiNALr/a1t2XRbbkMp9tLExhf18SbTq4Mlpq82+8fXX/BdZbUygWc/I8N0AaU2jnEB U1SQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding; bh=TmpwV5hYKe1zzhR8AYW+JLk6c3ElpHUwLq0C7LxmtH0=; b=kGEo+TCJ8ECwiqO05oP0YIsSTzrLCEuzK4RLAwL3+Qz+fGzTmDb5v3bb18bUU3nQaF sqX1W770G1u3ut0p8Hz2/T7+PL5JYOYxVMU0aF5wIuv7MKNinb6APJaHszKjnOTLn4/O nmizN86A8gIaasmk447foefzStb+02UJyJeH349YvYmVQkcUaSiYuk7DESPQxPsc3S8O x9wHC2d7miLeOurE3nxgpCI0hYeOLxS47SEUizhmibMN8DrjfwRyn0SpXqkImvUYOcF0 zD9BbQV1gyvD98/2Ikp/f7ndWBg4o7vHLtAbWJkcn5LwpdEEEmX3y82w4sDAZ+ETD/il BtWQ== X-Gm-Message-State: AOPr4FWNpSCwcELbEkNH4ayjpOS2G3Rcy6nyWe5U7j31E96lo3QwtPV+I5LmuoZlLgm18Q== X-Received: by 10.66.119.177 with SMTP id kv17mr32636717pab.57.1462579580770; Fri, 06 May 2016 17:06:20 -0700 (PDT) Received: from Stas-Air.local (76-220-46-95.lightspeed.sntcca.sbcglobal.net. [76.220.46.95]) by smtp.gmail.com with ESMTPSA id to9sm23605689pab.27.2016.05.06.17.06.19 (version=TLSv1/SSLv3 cipher=OTHER); Fri, 06 May 2016 17:06:19 -0700 (PDT) To: Raja Kulasekaran , internals@lists.php.net References: Message-ID: Date: Fri, 6 May 2016 17:06:17 -0700 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:45.0) Gecko/20100101 Thunderbird/45.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Subject: Re: [PHP-DEV] How to get trace of all database queries executed by php From: smalyshev@gmail.com (Stanislav Malyshev) Hi! > Is there any php extension available which help me out to give the > statistics of > all the queries execution details ? I'm not sure there is an extension doing specifically that, but any profiler or debugger extension would be able to capture database calls, and thus have access to this data. They usually would not dump this information though, so one would need to modify them to do it. Also, you may have better luck just enabling query logging in your database, most databases allow to do that. -- Stas Malyshev smalyshev@gmail.com