explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9BjZ : Testing

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 8.643 ↓ 0.0 0 1

Nested Loop (cost=19.40..12,177.11 rows=454 width=2,018) (actual time=8.643..8.643 rows=0 loops=1)

2. 0.000 8.642 ↓ 0.0 0 1

Nested Loop (cost=18.98..11,429.63 rows=454 width=1,123) (actual time=8.642..8.642 rows=0 loops=1)

3. 0.004 8.642 ↓ 0.0 0 1

Nested Loop (cost=18.55..8,138.23 rows=454 width=1,078) (actual time=8.642..8.642 rows=0 loops=1)

4. 0.034 0.034 ↑ 1.0 1 1

Seq Scan on instrument i (cost=0.00..5.34 rows=1 width=20) (actual time=0.018..0.034 rows=1 loops=1)

  • Filter: (id = '9f688a31-18b4-44f5-b046-d590ed7557b7'::uuid)
  • Rows Removed by Filter: 186
5. 0.046 8.604 ↓ 0.0 0 1

Nested Loop (cost=18.55..8,128.35 rows=454 width=1,074) (actual time=8.604..8.604 rows=0 loops=1)

6. 1.961 2.326 ↓ 2.1 1,558 1

Bitmap Heap Scan on client_order co (cost=18.13..2,161.15 rows=736 width=128) (actual time=0.554..2.326 rows=1,558 loops=1)

  • Recheck Cond: (instrument_id = '9f688a31-18b4-44f5-b046-d590ed7557b7'::uuid)
  • Heap Blocks: exact=1344
7. 0.365 0.365 ↓ 2.1 1,558 1

Bitmap Index Scan on idx_client_order_instrument_id (cost=0.00..17.94 rows=736 width=0) (actual time=0.365..0.365 rows=1,558 loops=1)

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

Index Scan using client_order_revision_pkey on client_order_revision cor (cost=0.43..8.11 rows=1 width=950) (actual time=0.004..0.004 rows=0 loops=1,558)

  • 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
9. 0.000 0.000 ↓ 0.0 0

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

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

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

  • Index Cond: (id = mo.current_revision_id)