explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FDJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 105,539.918 ↓ 0.0 0 1

Nested Loop (cost=1.42..124,798.75 rows=1 width=67) (actual time=105,539.918..105,539.918 rows=0 loops=1)

  • ("TradeDate" <= '2020-08-03'::date))
2. 0.001 105,539.917 ↓ 0.0 0 1

Nested Loop (cost=0.99..124,791.58 rows=1 width=20) (actual time=105,539.917..105,539.917 rows=0 loops=1)

3. 105,539.916 105,539.916 ↓ 0.0 0 1

Index Scan using comp_orders_ix2 on "Orders" ord (cost=0.56..124,775.65 rows=6 width=36) (actual time=105,539.916..105,539.916 rows=0 loops=1)

  • Index Cond: ((("ExternalId")::text = '45'::text) AND (("Counterparty")::text = 'SOMA Fundo de Investimento em Direitos Creditorios'::text) AND
  • Filter: ("Status" = ANY ('{executed,on_assignment,assignment_rejected}'::"ORDER_STATUS"[]))
4. 0.000 0.000 ↓ 0.0 0

Index Scan using "Assets_pkey" on "Assets" ast (cost=0.43..2.66 rows=1 width=16) (never executed)

  • Index Cond: ("Id" = ord."AssetId")
  • Filter: ((("Type")::text = 'Bond'::text) AND (("Name")::text = 'CCB'::text) AND ("MemberId" = '261beb0f-9942-4d23-aabc-e484180c1896'::uuid))
5. 0.000 0.000 ↓ 0.0 0

Index Scan using order_cashflows_order_id_fkey_idx on "OrderCashflows" ocf (cost=0.43..7.12 rows=5 width=63) (never executed)

  • Index Cond: ("OrderId" = ord."Id")
Planning time : 2.720 ms
Execution time : 105,540.010 ms