explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Hsb8

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

Index Scan using index_investments_on_status on investments (cost=0.14..8.16 rows=1 width=3,522) (actual time=0.034..0.034 rows=0 loops=1)

  • Index Cond: ((status)::text = 'posted_in'::text)
  • Filter: (verified AND (allocations_order_id IS NULL) AND ((type)::text = ANY ('{CreditInvestment,DividendInvestment}'::text[])) AND (investment_batch_id = 'e7d533e2-11cd-4c66-bce4-ee403b5a1c77'::uuid))
  • Execution Time: 0.088 ms +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
Planning time : 1.696 ms