explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uTVv

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

Nested Loop (cost=22,472.70..157,235.56 rows=1 width=67) (actual time=833.428..833.428 rows=0 loops=1)

2. 569.755 939.518 ↓ 0.0 0 1

Gather (cost=22,472.27..157,228.39 rows=1 width=20) (actual time=833.427..939.518 rows=0 loops=1)

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

Nested Loop (cost=21,472.27..156,228.29 rows=1 width=20) (actual time=369.763..369.763 rows=0 loops=3)

4. 369.760 369.760 ↓ 0.0 0 3 / 3

Parallel Bitmap Heap Scan on "Orders" ord (cost=21,471.84..156,222.98 rows=2 width=36) (actual time=369.760..369.760 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,893
  • Heap Blocks: exact=28,775
  • -> Bitmap Index Scan on orders_counterparty_idx (cost=0.00..21471.83 rows=1,468,477 width=0) (actual time=220.002..220.002 rows=1,490,680loops=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 : 0.942 ms
Execution time : 939.650 ms