explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aiY5 : findOrdersByClient

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Seq Scan on cyc_order o_1 (cost=0.00..45.36 rows=1,629 width=54) (actual rows= loops=)

  • Filter: ((ordercountryid)::text = 'CL'::text)
  • -> Hash (cost=45.72..45.72 rows=545 width=29) (actual time=0.334..
  • Buckets: 1024 Batches: 1 Memory Usage: 42kB
  • -> Bitmap Heap Scan on cyc_client ct (cost=8.90..45.72 rows=
  • Recheck Cond: ((clientclientid)::text = '189395876'::tex
  • Heap Blocks: exact=25
  • -> Bitmap Index Scan on clientclientid_idx (cost=0.00.
  • Index Cond: ((clientclientid)::text = '189395876':
Planning time : 0.855 ms
Execution time : 2.346 ms