explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FmwC

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 10,665.736 ↓ 0.0 0 1

Nested Loop (cost=1.42..110,252.55 rows=1 width=67) (actual time=10,665.736..10,665.736 rows=0 loops=1)

2. 0.002 10,665.736 ↓ 0.0 0 1

Nested Loop (cost=0.99..110,245.38 rows=1 width=20) (actual time=10,665.736..10,665.736 rows=0 loops=1)

3. 10,665.734 10,665.734 ↓ 0.0 0 1

Index Scan using comp_orders_ix on "Orders" ord (cost=0.56..110,232.10 rows=5 width=36) (actual time=10,665.734..10,665.734 rows=0 loops=1)

  • Index Cond: ((("Counterparty")::text = 'SOMA Fundo de Investimento em Direitos Creditorios'::text) AND (("ExternalId")::text = '45'::text))
  • Filter: (("TradeDate" <= '2020-08-03'::date) AND ("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 : 1.769 ms
Execution time : 10,665.850 ms