explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iZxA : Test2

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

Nested Loop (cost=1,041.55..16,708.83 rows=928 width=2,024) (actual time=7.847..7.847 rows=0 loops=1)

2. 0.006 0.006 ↑ 1.0 1 1

Index Scan using instrument_pkey on instrument i (cost=0.14..8.16 rows=1 width=20) (actual time=0.005..0.006 rows=1 loops=1)

  • Index Cond: (id = '9f688a31-18b4-44f5-b046-d590ed7557b7'::uuid)
3. 4.004 9.032 ↓ 0.0 0 1

Gather (cost=1,041.40..16,691.38 rows=928 width=2,000) (actual time=7.840..9.032 rows=0 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
4. 0.001 5.028 ↓ 0.0 0 2

Nested Loop (cost=41.40..15,598.58 rows=546 width=2,000) (actual time=5.028..5.028 rows=0 loops=2)

5. 0.001 5.027 ↓ 0.0 0 2

Nested Loop (cost=40.98..14,482.02 rows=546 width=1,120) (actual time=5.027..5.027 rows=0 loops=2)

6. 3.179 5.026 ↓ 0.0 0 2

Nested Loop (cost=40.55..10,780.64 rows=546 width=1,075) (actual time=5.026..5.026 rows=0 loops=2)

7. 1.186 1.843 ↑ 1.1 785 2

Parallel Bitmap Heap Scan on client_order co (cost=40.12..3,855.71 rows=888 width=128) (actual time=0.475..1.843 rows=785 loops=2)

  • Recheck Cond: (instrument_id = '9f688a31-18b4-44f5-b046-d590ed7557b7'::uuid)
  • Heap Blocks: exact=1001
8. 0.657 0.657 ↓ 1.1 1,671 1

Bitmap Index Scan on idx_client_order_instrument_id (cost=0.00..39.75 rows=1,510 width=0) (actual time=0.657..0.657 rows=1,671 loops=1)

  • Index Cond: (instrument_id = '9f688a31-18b4-44f5-b046-d590ed7557b7'::uuid)
9. 0.004 0.004 ↓ 0.0 0 1,570

Index Scan using client_order_revision_pkey on client_order_revision cor (cost=0.43..7.80 rows=1 width=951) (actual time=0.004..0.004 rows=0 loops=1,570)

  • Index Cond: (id = co.current_revision_id)
  • Filter: ((state = 'stepping'::client_order_revision_state) OR (objective = ANY ('{wait,cancel}'::client_order_revision_objective[])))
  • Rows Removed by Filter: 1
10. 0.000 0.000 ↓ 0.0 0

Index Scan using market_order_pkey on market_order mo (cost=0.42..6.78 rows=1 width=61) (never executed)

  • Index Cond: (id = co.current_market_order_id)
11. 0.000 0.000 ↓ 0.0 0

Index Scan using market_order_revision_pkey on market_order_revision mor (cost=0.43..2.04 rows=1 width=884) (never executed)

  • Index Cond: (id = mo.current_revision_id)