<?php
include_once $_SERVER['DOCUMENT_ROOT'] . '/include/shared-manual.inc';
$TOC = array();
$TOC_DEPRECATED = array();
$PARENTS = array();
include_once dirname(__FILE__) ."/toc/ref.pgsql.inc";
$setup = array (
  'home' => 
  array (
    0 => 'index.php',
    1 => 'PHP Manual',
  ),
  'head' => 
  array (
    0 => 'UTF-8',
    1 => 'en',
  ),
  'this' => 
  array (
    0 => 'function.pg-result-memory-size.php',
    1 => 'pg_result_memory_size',
    2 => 'Returns the amount of memory allocated for a query result',
  ),
  'up' => 
  array (
    0 => 'ref.pgsql.php',
    1 => 'PostgreSQL Functions',
  ),
  'prev' => 
  array (
    0 => 'function.pg-result-error-field.php',
    1 => 'pg_result_error_field',
  ),
  'next' => 
  array (
    0 => 'function.pg-result-seek.php',
    1 => 'pg_result_seek',
  ),
  'alternatives' => 
  array (
  ),
  'source' => 
  array (
    'lang' => 'en',
    'path' => 'reference/pgsql/functions/pg-result-memory-size.xml',
  ),
  'history' => 
  array (
  ),
);
$setup["toc"] = $TOC;
$setup["toc_deprecated"] = $TOC_DEPRECATED;
$setup["parents"] = $PARENTS;
manual_setup($setup);

contributors($setup);

?>
<div id="function.pg-result-memory-size" class="refentry">
 <div class="refnamediv">
  <h1 class="refname">pg_result_memory_size</h1>
  <p class="verinfo">(PHP 8 &gt;= 8.4.0)</p><p class="refpurpose"><span class="refname">pg_result_memory_size</span> &mdash; <span class="dc-title">Returns the amount of memory allocated for a query result</span></p>

 </div>

 <div class="refsect1 description" id="refsect1-function.pg-result-memory-size-description">
  <h3 class="title">Description</h3>
  <div class="methodsynopsis dc-description">
   <span class="methodname"><strong>pg_result_memory_size</strong></span>(<span class="methodparam"><span class="type"><a href="class.pgsql-result.php" class="type PgSql\Result">PgSql\Result</a></span> <code class="parameter">$result</code></span>): <span class="type"><a href="language.types.integer.php" class="type int">int</a></span></div>

  <p class="simpara">
   Returns the amount of memory, in bytes, allocated to the specified query result
   <span class="classname"><a href="class.pgsql-result.php" class="classname">PgSql\Result</a></span> instance.
   This value is the same amount that would be freed by <span class="function"><a href="function.pg-free-result.php" class="function">pg_free_result()</a></span>.
  </p>
 </div>


 <div class="refsect1 parameters" id="refsect1-function.pg-result-memory-size-parameters">
  <h3 class="title">Parameters</h3>
  <dl>
   
    <dt><code class="parameter">result</code></dt>
    <dd>
     <p class="para">An <span class="classname"><a href="class.pgsql-result.php" class="classname">PgSql\Result</a></span> instance, returned by <span class="function"><a href="function.pg-query.php" class="function">pg_query()</a></span>,
<span class="function"><a href="function.pg-query-params.php" class="function">pg_query_params()</a></span> or <span class="function"><a href="function.pg-execute.php" class="function">pg_execute()</a></span>(among others).</p>
    </dd>
   
  </dl>
 </div>


 <div class="refsect1 returnvalues" id="refsect1-function.pg-result-memory-size-returnvalues">
  <h3 class="title">Return Values</h3>
  <p class="simpara">
   Returns the memory amount in bytes.
  </p>
 </div>


 <div class="refsect1 examples" id="refsect1-function.pg-result-memory-size-examples">
  <h3 class="title">Examples</h3>
  <div class="example" id="example-1">
   <p><strong>Example #1 <span class="function"><strong>pg_result_memory_size()</strong></span> example</strong></p>
   <div class="example-contents">
<div class="phpcode"><code><span style="color: #000000"><span style="color: #0000BB">&lt;?php<br />$db </span><span style="color: #007700">= </span><span style="color: #0000BB">pg_connect</span><span style="color: #007700">(</span><span style="color: #DD0000">"dbname=users user=me"</span><span style="color: #007700">);<br /><br /></span><span style="color: #0000BB">$res </span><span style="color: #007700">= </span><span style="color: #0000BB">pg_query</span><span style="color: #007700">(</span><span style="color: #0000BB">$db</span><span style="color: #007700">, </span><span style="color: #DD0000">'SELECT 1'</span><span style="color: #007700">);<br /><br /></span><span style="color: #0000BB">$size </span><span style="color: #007700">= </span><span style="color: #0000BB">pg_result_memory_size</span><span style="color: #007700">(</span><span style="color: #0000BB">$res</span><span style="color: #007700">);<br /><br /></span><span style="color: #0000BB">var_dump</span><span style="color: #007700">(</span><span style="color: #0000BB">$size</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">?&gt;</span></span></code></div>
   </div>

   <div class="example-contents"><p>The above example will output
something similar to:</p></div>
   <div class="example-contents screen">
<div class="examplescode"><pre class="examplescode">int(3288)</pre>
</div>
   </div>
  </div>
 </div>


 <div class="refsect1 seealso" id="refsect1-function.pg-result-memory-size-seealso">
  <h3 class="title">See Also</h3>
  <ul class="simplelist">
   <li><span class="function"><a href="function.pg-free-result.php" class="function" rel="rdfs-seeAlso">pg_free_result()</a> - Free result memory</span></li>
  </ul>
 </div>

</div><?php manual_footer($setup); ?>