explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6fxI

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

Nested Loop (cost=22,466.68..157,226.34 rows=1 width=67) (actual time=1,082.090..1,082.090 rows=0 loops=1)

2. 918.757 1,248.136 ↓ 0.0 0 1

Gather (cost=22,466.25..157,219.17 rows=1 width=20) (actual time=1,082.089..1,248.136 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.003 329.379 ↓ 0.0 0 3 / 3

Nested Loop (cost=21,466.25..156,219.07 rows=1 width=20) (actual time=329.379..329.379 rows=0 loops=3)

4. 329.376 329.376 ↓ 0.0 0 3 / 3

Parallel Bitmap Heap Scan on "Orders" ord (cost=21,465.82..156,213.76 rows=2 width=36) (actual time=329.376..329.376 rows=0 loops=3)

  • Recheck Cond: (("Counterparty")::text = 'SOMA Fundo de Investimento em Direitos Creditorios'::text)
  • Filter: (("TradeDate" <= '2020-08-03'::date) AND (("ExternalId")::text = '45'::text) AND ("Status" = ANY ('{executed,on_assignment,assignment_rejected}'::"ORDER_STATUS"[])))
  • Rows Removed by Filter: 496,892
  • Heap Blocks: exact=33,763
  • -> Bitmap Index Scan on orders_counterparty_idx (cost=0.00..21465.82 rows=1,468,115 width=0) (actual time=204.032..204.032 rows=1,490,676loops=1)
  • Index Cond: (("Counterparty")::text = 'SOMA Fundo de Investimento em Direitos Creditorios'::text)
5. 0.000 0.000 ↓ 0.0 0 / 3

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))
6. 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 : 20.068 ms
Execution time : 1,248.224 ms