explain.depesz.com

PostgreSQL's explain analyze made readable

Result: r5xJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 602.738 ↑ 1.0 1 1

Result (cost=3,813.42..3,813.43 rows=1 width=32) (actual time=602.738..602.738 rows=1 loops=1)

2.          

Initplan (for Result)

3. 0.018 602.723 ↓ 5.0 5 1

Unique (cost=3,813.41..3,813.42 rows=1 width=32) (actual time=602.706..602.723 rows=5 loops=1)

4. 0.058 602.705 ↓ 8.0 8 1

Sort (cost=3,813.41..3,813.41 rows=1 width=32) (actual time=602.704..602.705 rows=8 loops=1)

  • Sort Key: (ROW((op.bill_order_id)::character varying(50), op.order_create_dt)::orders.order_with_order_dt)
  • Sort Method: quicksort Memory: 26kB
5. 0.092 602.647 ↓ 8.0 8 1

Nested Loop Semi Join (cost=9.23..3,813.40 rows=1 width=32) (actual time=0.198..602.647 rows=8 loops=1)

6. 0.093 0.667 ↓ 8.0 8 1

Nested Loop (cost=0.28..3,795.00 rows=1 width=33) (actual time=0.069..0.667 rows=8 loops=1)

7. 0.022 0.022 ↑ 12.5 8 1

Function Scan on unnest t (cost=0.00..1.00 rows=100 width=16) (actual time=0.013..0.022 rows=8 loops=1)

8. 0.148 0.552 ↑ 22.0 1 8

Append (cost=0.28..37.72 rows=22 width=33) (actual time=0.054..0.069 rows=1 loops=8)

9. 0.000 0.000 ↓ 0.0 0

Index Only Scan using online_order_object_part_old_pkey on online_order_object_part_old op (cost=0.28..0.76 rows=1 width=32) (never executed)

  • Index Cond: ((obj = t.rid) AND (obj_type = $19) AND (order_create_dt = t.order_dt))
  • Heap Fetches: 0
10. 0.000 0.000 ↓ 0.0 0

Index Only Scan using online_order_object_part_2020_04_28_pkey on online_order_object_part_2020_04_28 op_1 (cost=0.41..1.61 rows=1 width=33) (never executed)

  • Index Cond: ((obj = t.rid) AND (obj_type = $19) AND (order_create_dt = t.order_dt))
  • Heap Fetches: 0
11. 0.000 0.000 ↓ 0.0 0

Index Only Scan using online_order_object_part_2020_04_29_pkey on online_order_object_part_2020_04_29 op_2 (cost=0.41..1.35 rows=1 width=33) (never executed)

  • Index Cond: ((obj = t.rid) AND (obj_type = $19) AND (order_create_dt = t.order_dt))
  • Heap Fetches: 0
12. 0.000 0.000 ↓ 0.0 0

Index Only Scan using online_order_object_part_2020_04_30_pkey on online_order_object_part_2020_04_30 op_3 (cost=0.41..1.48 rows=1 width=33) (never executed)

  • Index Cond: ((obj = t.rid) AND (obj_type = $19) AND (order_create_dt = t.order_dt))
  • Heap Fetches: 0
13. 0.000 0.000 ↓ 0.0 0

Index Only Scan using online_order_object_part_2020_05_01_pkey on online_order_object_part_2020_05_01 op_4 (cost=0.41..1.46 rows=1 width=33) (never executed)

  • Index Cond: ((obj = t.rid) AND (obj_type = $19) AND (order_create_dt = t.order_dt))
  • Heap Fetches: 0
14. 0.000 0.000 ↓ 0.0 0

Index Only Scan using online_order_object_part_2020_05_02_pkey on online_order_object_part_2020_05_02 op_5 (cost=0.41..1.25 rows=1 width=33) (never executed)

  • Index Cond: ((obj = t.rid) AND (obj_type = $19) AND (order_create_dt = t.order_dt))
  • Heap Fetches: 0
15. 0.000 0.000 ↓ 0.0 0

Index Only Scan using online_order_object_part_2020_05_03_pkey on online_order_object_part_2020_05_03 op_6 (cost=0.41..1.39 rows=1 width=33) (never executed)

  • Index Cond: ((obj = t.rid) AND (obj_type = $19) AND (order_create_dt = t.order_dt))
  • Heap Fetches: 0
16. 0.000 0.000 ↓ 0.0 0

Index Only Scan using online_order_object_part_2020_05_04_pkey on online_order_object_part_2020_05_04 op_7 (cost=0.41..1.39 rows=1 width=33) (never executed)

  • Index Cond: ((obj = t.rid) AND (obj_type = $19) AND (order_create_dt = t.order_dt))
  • Heap Fetches: 0
17. 0.000 0.000 ↓ 0.0 0

Index Only Scan using online_order_object_part_2020_05_05_pkey on online_order_object_part_2020_05_05 op_8 (cost=0.41..1.50 rows=1 width=33) (never executed)

  • Index Cond: ((obj = t.rid) AND (obj_type = $19) AND (order_create_dt = t.order_dt))
  • Heap Fetches: 0
18. 0.000 0.000 ↓ 0.0 0

Index Only Scan using online_order_object_part_2020_05_06_pkey on online_order_object_part_2020_05_06 op_9 (cost=0.41..1.58 rows=1 width=33) (never executed)

  • Index Cond: ((obj = t.rid) AND (obj_type = $19) AND (order_create_dt = t.order_dt))
  • Heap Fetches: 0
19. 0.000 0.000 ↓ 0.0 0

Index Only Scan using online_order_object_part_2020_05_07_pkey on online_order_object_part_2020_05_07 op_10 (cost=0.41..1.30 rows=1 width=33) (never executed)

  • Index Cond: ((obj = t.rid) AND (obj_type = $19) AND (order_create_dt = t.order_dt))
  • Heap Fetches: 0
20. 0.040 0.040 ↑ 1.0 1 1

Index Only Scan using online_order_object_part_2020_05_08_pkey on online_order_object_part_2020_05_08 op_11 (cost=0.42..2.58 rows=1 width=33) (actual time=0.035..0.040 rows=1 loops=1)

  • Index Cond: ((obj = t.rid) AND (obj_type = $19) AND (order_create_dt = t.order_dt))
  • Heap Fetches: 1
21. 0.000 0.000 ↓ 0.0 0

Index Only Scan using online_order_object_part_2020_05_09_pkey on online_order_object_part_2020_05_09 op_12 (cost=0.42..2.56 rows=1 width=33) (never executed)

  • Index Cond: ((obj = t.rid) AND (obj_type = $19) AND (order_create_dt = t.order_dt))
  • Heap Fetches: 0
22. 0.000 0.000 ↓ 0.0 0

Index Only Scan using online_order_object_part_2020_05_10_pkey on online_order_object_part_2020_05_10 op_13 (cost=0.43..2.28 rows=1 width=33) (never executed)

  • Index Cond: ((obj = t.rid) AND (obj_type = $19) AND (order_create_dt = t.order_dt))
  • Heap Fetches: 0
23. 0.000 0.000 ↓ 0.0 0

Index Only Scan using online_order_object_part_2020_05_11_pkey on online_order_object_part_2020_05_11 op_14 (cost=0.43..2.08 rows=1 width=33) (never executed)

  • Index Cond: ((obj = t.rid) AND (obj_type = $19) AND (order_create_dt = t.order_dt))
  • Heap Fetches: 0
24. 0.000 0.000 ↓ 0.0 0

Index Only Scan using online_order_object_part_2020_05_12_pkey on online_order_object_part_2020_05_12 op_15 (cost=0.43..2.16 rows=1 width=33) (never executed)

  • Index Cond: ((obj = t.rid) AND (obj_type = $19) AND (order_create_dt = t.order_dt))
  • Heap Fetches: 0
25. 0.000 0.000 ↓ 0.0 0

Index Only Scan using online_order_object_part_2020_05_13_pkey on online_order_object_part_2020_05_13 op_16 (cost=0.43..1.60 rows=1 width=33) (never executed)

  • Index Cond: ((obj = t.rid) AND (obj_type = $19) AND (order_create_dt = t.order_dt))
  • Heap Fetches: 0
26. 0.000 0.000 ↓ 0.0 0

Index Only Scan using online_order_object_part_2020_05_14_pkey on online_order_object_part_2020_05_14 op_17 (cost=0.55..1.72 rows=1 width=33) (never executed)

  • Index Cond: ((obj = t.rid) AND (obj_type = $19) AND (order_create_dt = t.order_dt))
  • Heap Fetches: 0
27. 0.000 0.000 ↓ 0.0 0

Index Only Scan using online_order_object_part_2020_05_15_pkey on online_order_object_part_2020_05_15 op_18 (cost=0.55..1.93 rows=1 width=33) (never executed)

  • Index Cond: ((obj = t.rid) AND (obj_type = $19) AND (order_create_dt = t.order_dt))
  • Heap Fetches: 0
28. 0.000 0.000 ↓ 0.0 0

Index Only Scan using online_order_object_part_2020_05_16_pkey on online_order_object_part_2020_05_16 op_19 (cost=0.43..1.60 rows=1 width=33) (never executed)

  • Index Cond: ((obj = t.rid) AND (obj_type = $19) AND (order_create_dt = t.order_dt))
  • Heap Fetches: 0
29. 0.000 0.000 ↓ 0.0 0

Index Only Scan using online_order_object_part_2020_05_17_pkey on online_order_object_part_2020_05_17 op_20 (cost=0.43..1.81 rows=1 width=33) (never executed)

  • Index Cond: ((obj = t.rid) AND (obj_type = $19) AND (order_create_dt = t.order_dt))
  • Heap Fetches: 0
30. 0.364 0.364 ↑ 1.0 1 7

Index Only Scan using online_order_object_part_2020_05_18_pkey on online_order_object_part_2020_05_18 op_21 (cost=0.42..2.22 rows=1 width=33) (actual time=0.043..0.052 rows=1 loops=7)

  • Index Cond: ((obj = t.rid) AND (obj_type = $19) AND (order_create_dt = t.order_dt))
  • Heap Fetches: 7
31. 0.248 601.888 ↑ 1.0 1 8

Hash Join (cost=8.95..18.38 rows=1 width=50) (actual time=75.236..75.236 rows=1 loops=8)

  • Hash Cond: ((ooo1.order_create_dt = oo.create_dt) AND ((ooo1.bill_order_id)::text = (oo.bill_order_id)::text))
  • Join Filter: ((NOT oo.srv_exists) OR (oo.srv_exists AND (ooo1.obj_type = $20)))
32. 0.091 600.704 ↑ 22.0 1 8

Append (cost=0.28..9.54 rows=22 width=29) (actual time=75.088..75.088 rows=1 loops=8)

33. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_online_order_object_part_old_bill_order_id on online_order_object_part_old ooo1 (cost=0.28..0.34 rows=1 width=28) (never executed)

  • Index Cond: ((bill_order_id)::text = (op.bill_order_id)::text)
  • Filter: (op.order_create_dt = order_create_dt)
34. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_online_order_object_part_2020_04_28_bill_order_id on online_order_object_part_2020_04_28 ooo1_1 (cost=0.29..0.33 rows=1 width=29) (never executed)

  • Index Cond: ((bill_order_id)::text = (op.bill_order_id)::text)
  • Filter: (op.order_create_dt = order_create_dt)
35. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_online_order_object_part_2020_04_29_bill_order_id on online_order_object_part_2020_04_29 ooo1_2 (cost=0.29..0.33 rows=1 width=29) (never executed)

  • Index Cond: ((bill_order_id)::text = (op.bill_order_id)::text)
  • Filter: (op.order_create_dt = order_create_dt)
36. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_online_order_object_part_2020_04_30_bill_order_id on online_order_object_part_2020_04_30 ooo1_3 (cost=0.29..0.33 rows=1 width=29) (never executed)

  • Index Cond: ((bill_order_id)::text = (op.bill_order_id)::text)
  • Filter: (op.order_create_dt = order_create_dt)
37. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_online_order_object_part_2020_05_01_bill_order_id on online_order_object_part_2020_05_01 ooo1_4 (cost=0.29..0.33 rows=1 width=29) (never executed)

  • Index Cond: ((bill_order_id)::text = (op.bill_order_id)::text)
  • Filter: (op.order_create_dt = order_create_dt)
38. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_online_order_object_part_2020_05_02_bill_order_id on online_order_object_part_2020_05_02 ooo1_5 (cost=0.29..0.33 rows=1 width=29) (never executed)

  • Index Cond: ((bill_order_id)::text = (op.bill_order_id)::text)
  • Filter: (op.order_create_dt = order_create_dt)
39. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_online_order_object_part_2020_05_03_bill_order_id on online_order_object_part_2020_05_03 ooo1_6 (cost=0.29..0.33 rows=1 width=29) (never executed)

  • Index Cond: ((bill_order_id)::text = (op.bill_order_id)::text)
  • Filter: (op.order_create_dt = order_create_dt)
40. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_online_order_object_part_2020_05_04_bill_order_id on online_order_object_part_2020_05_04 ooo1_7 (cost=0.29..0.33 rows=1 width=29) (never executed)

  • Index Cond: ((bill_order_id)::text = (op.bill_order_id)::text)
  • Filter: (op.order_create_dt = order_create_dt)
41. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_online_order_object_part_2020_05_05_bill_order_id on online_order_object_part_2020_05_05 ooo1_8 (cost=0.29..0.33 rows=1 width=29) (never executed)

  • Index Cond: ((bill_order_id)::text = (op.bill_order_id)::text)
  • Filter: (op.order_create_dt = order_create_dt)
42. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_online_order_object_part_2020_05_06_bill_order_id on online_order_object_part_2020_05_06 ooo1_9 (cost=0.29..0.33 rows=1 width=29) (never executed)

  • Index Cond: ((bill_order_id)::text = (op.bill_order_id)::text)
  • Filter: (op.order_create_dt = order_create_dt)
43. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_online_order_object_part_2020_05_07_bill_order_id on online_order_object_part_2020_05_07 ooo1_10 (cost=0.29..0.33 rows=1 width=29) (never executed)

  • Index Cond: ((bill_order_id)::text = (op.bill_order_id)::text)
  • Filter: (op.order_create_dt = order_create_dt)
44. 600.354 600.354 ↑ 1.0 1 1

Index Scan using ix_online_order_object_part_2020_05_08_bill_order_id on online_order_object_part_2020_05_08 ooo1_11 (cost=0.42..0.50 rows=1 width=29) (actual time=600.354..600.354 rows=1 loops=1)

  • Index Cond: ((bill_order_id)::text = (op.bill_order_id)::text)
  • Filter: (op.order_create_dt = order_create_dt)
45. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_online_order_object_part_2020_05_09_bill_order_id on online_order_object_part_2020_05_09 ooo1_12 (cost=0.42..0.53 rows=1 width=29) (never executed)

  • Index Cond: ((bill_order_id)::text = (op.bill_order_id)::text)
  • Filter: (op.order_create_dt = order_create_dt)
46. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_online_order_object_part_2020_05_10_bill_order_id on online_order_object_part_2020_05_10 ooo1_13 (cost=0.43..0.53 rows=1 width=29) (never executed)

  • Index Cond: ((bill_order_id)::text = (op.bill_order_id)::text)
  • Filter: (op.order_create_dt = order_create_dt)
47. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_online_order_object_part_2020_05_11_bill_order_id on online_order_object_part_2020_05_11 ooo1_14 (cost=0.43..0.53 rows=1 width=29) (never executed)

  • Index Cond: ((bill_order_id)::text = (op.bill_order_id)::text)
  • Filter: (op.order_create_dt = order_create_dt)
48. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_online_order_object_part_2020_05_12_bill_order_id on online_order_object_part_2020_05_12 ooo1_15 (cost=0.43..0.55 rows=1 width=29) (never executed)

  • Index Cond: ((bill_order_id)::text = (op.bill_order_id)::text)
  • Filter: (op.order_create_dt = order_create_dt)
49. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_online_order_object_part_2020_05_13_bill_order_id on online_order_object_part_2020_05_13 ooo1_16 (cost=0.43..0.53 rows=1 width=29) (never executed)

  • Index Cond: ((bill_order_id)::text = (op.bill_order_id)::text)
  • Filter: (op.order_create_dt = order_create_dt)
50. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_online_order_object_part_2020_05_14_bill_order_id on online_order_object_part_2020_05_14 ooo1_17 (cost=0.43..0.53 rows=1 width=29) (never executed)

  • Index Cond: ((bill_order_id)::text = (op.bill_order_id)::text)
  • Filter: (op.order_create_dt = order_create_dt)
51. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_online_order_object_part_2020_05_15_bill_order_id on online_order_object_part_2020_05_15 ooo1_18 (cost=0.43..0.53 rows=1 width=29) (never executed)

  • Index Cond: ((bill_order_id)::text = (op.bill_order_id)::text)
  • Filter: (op.order_create_dt = order_create_dt)
52. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_online_order_object_part_2020_05_16_bill_order_id on online_order_object_part_2020_05_16 ooo1_19 (cost=0.43..0.53 rows=1 width=29) (never executed)

  • Index Cond: ((bill_order_id)::text = (op.bill_order_id)::text)
  • Filter: (op.order_create_dt = order_create_dt)
53. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_online_order_object_part_2020_05_17_bill_order_id on online_order_object_part_2020_05_17 ooo1_20 (cost=0.43..0.53 rows=1 width=29) (never executed)

  • Index Cond: ((bill_order_id)::text = (op.bill_order_id)::text)
  • Filter: (op.order_create_dt = order_create_dt)
54. 0.259 0.259 ↑ 1.0 1 7

Index Scan using ix_online_order_object_part_2020_05_18_bill_order_id on online_order_object_part_2020_05_18 ooo1_21 (cost=0.42..0.52 rows=1 width=29) (actual time=0.037..0.037 rows=1 loops=7)

  • Index Cond: ((bill_order_id)::text = (op.bill_order_id)::text)
  • Filter: (op.order_create_dt = order_create_dt)
55. 0.264 0.936 ↑ 22.0 1 8

Hash (cost=8.34..8.34 rows=22 width=26) (actual time=0.117..0.117 rows=1 loops=8)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
56. 0.123 0.672 ↑ 22.0 1 8

Append (cost=0.28..8.34 rows=22 width=26) (actual time=0.082..0.084 rows=1 loops=8)

57. 0.000 0.000 ↓ 0.0 0

Index Scan using online_order_part_old_pkey on online_order_part_old oo (cost=0.28..0.30 rows=1 width=25) (never executed)

  • Index Cond: (((bill_order_id)::text = (op.bill_order_id)::text) AND (create_dt = op.order_create_dt))
  • Filter: has_hold
58. 0.000 0.000 ↓ 0.0 0

Index Scan using online_order_part_2020_04_28_pkey on online_order_part_2020_04_28 oo_1 (cost=0.29..0.31 rows=1 width=26) (never executed)

  • Index Cond: (((bill_order_id)::text = (op.bill_order_id)::text) AND (create_dt = op.order_create_dt))
  • Filter: has_hold
59. 0.000 0.000 ↓ 0.0 0

Index Scan using online_order_part_2020_04_29_pkey on online_order_part_2020_04_29 oo_2 (cost=0.29..0.31 rows=1 width=26) (never executed)

  • Index Cond: (((bill_order_id)::text = (op.bill_order_id)::text) AND (create_dt = op.order_create_dt))
  • Filter: has_hold
60. 0.000 0.000 ↓ 0.0 0

Index Scan using online_order_part_2020_04_30_pkey on online_order_part_2020_04_30 oo_3 (cost=0.29..0.31 rows=1 width=26) (never executed)

  • Index Cond: (((bill_order_id)::text = (op.bill_order_id)::text) AND (create_dt = op.order_create_dt))
  • Filter: has_hold
61. 0.000 0.000 ↓ 0.0 0

Index Scan using online_order_part_2020_05_01_pkey on online_order_part_2020_05_01 oo_4 (cost=0.29..0.31 rows=1 width=26) (never executed)

  • Index Cond: (((bill_order_id)::text = (op.bill_order_id)::text) AND (create_dt = op.order_create_dt))
  • Filter: has_hold
62. 0.000 0.000 ↓ 0.0 0

Index Scan using online_order_part_2020_05_02_pkey on online_order_part_2020_05_02 oo_5 (cost=0.29..0.31 rows=1 width=26) (never executed)

  • Index Cond: (((bill_order_id)::text = (op.bill_order_id)::text) AND (create_dt = op.order_create_dt))
  • Filter: has_hold
63. 0.000 0.000 ↓ 0.0 0

Index Scan using online_order_part_2020_05_03_pkey on online_order_part_2020_05_03 oo_6 (cost=0.29..0.31 rows=1 width=26) (never executed)

  • Index Cond: (((bill_order_id)::text = (op.bill_order_id)::text) AND (create_dt = op.order_create_dt))
  • Filter: has_hold
64. 0.000 0.000 ↓ 0.0 0

Index Scan using online_order_part_2020_05_04_pkey on online_order_part_2020_05_04 oo_7 (cost=0.29..0.31 rows=1 width=26) (never executed)

  • Index Cond: (((bill_order_id)::text = (op.bill_order_id)::text) AND (create_dt = op.order_create_dt))
  • Filter: has_hold
65. 0.000 0.000 ↓ 0.0 0

Index Scan using online_order_part_2020_05_05_pkey on online_order_part_2020_05_05 oo_8 (cost=0.29..0.31 rows=1 width=26) (never executed)

  • Index Cond: (((bill_order_id)::text = (op.bill_order_id)::text) AND (create_dt = op.order_create_dt))
  • Filter: has_hold
66. 0.000 0.000 ↓ 0.0 0

Index Scan using online_order_part_2020_05_06_pkey on online_order_part_2020_05_06 oo_9 (cost=0.29..0.31 rows=1 width=26) (never executed)

  • Index Cond: (((bill_order_id)::text = (op.bill_order_id)::text) AND (create_dt = op.order_create_dt))
  • Filter: has_hold
67. 0.000 0.000 ↓ 0.0 0

Index Scan using online_order_part_2020_05_07_pkey on online_order_part_2020_05_07 oo_10 (cost=0.29..0.31 rows=1 width=26) (never executed)

  • Index Cond: (((bill_order_id)::text = (op.bill_order_id)::text) AND (create_dt = op.order_create_dt))
  • Filter: has_hold
68. 0.045 0.045 ↑ 1.0 1 1

Index Scan using online_order_part_2020_05_08_pkey on online_order_part_2020_05_08 oo_11 (cost=0.42..0.44 rows=1 width=26) (actual time=0.044..0.045 rows=1 loops=1)

  • Index Cond: (((bill_order_id)::text = (op.bill_order_id)::text) AND (create_dt = op.order_create_dt))
  • Filter: has_hold
69. 0.000 0.000 ↓ 0.0 0

Index Scan using online_order_part_2020_05_09_pkey on online_order_part_2020_05_09 oo_12 (cost=0.42..0.44 rows=1 width=26) (never executed)

  • Index Cond: (((bill_order_id)::text = (op.bill_order_id)::text) AND (create_dt = op.order_create_dt))
  • Filter: has_hold
70. 0.000 0.000 ↓ 0.0 0

Index Scan using online_order_part_2020_05_10_pkey on online_order_part_2020_05_10 oo_13 (cost=0.42..0.44 rows=1 width=26) (never executed)

  • Index Cond: (((bill_order_id)::text = (op.bill_order_id)::text) AND (create_dt = op.order_create_dt))
  • Filter: has_hold
71. 0.000 0.000 ↓ 0.0 0

Index Scan using online_order_part_2020_05_11_pkey on online_order_part_2020_05_11 oo_14 (cost=0.42..0.44 rows=1 width=26) (never executed)

  • Index Cond: (((bill_order_id)::text = (op.bill_order_id)::text) AND (create_dt = op.order_create_dt))
  • Filter: has_hold
72. 0.000 0.000 ↓ 0.0 0

Index Scan using online_order_part_2020_05_12_pkey on online_order_part_2020_05_12 oo_15 (cost=0.42..0.44 rows=1 width=26) (never executed)

  • Index Cond: (((bill_order_id)::text = (op.bill_order_id)::text) AND (create_dt = op.order_create_dt))
  • Filter: has_hold
73. 0.000 0.000 ↓ 0.0 0

Index Scan using online_order_part_2020_05_13_pkey on online_order_part_2020_05_13 oo_16 (cost=0.42..0.44 rows=1 width=26) (never executed)

  • Index Cond: (((bill_order_id)::text = (op.bill_order_id)::text) AND (create_dt = op.order_create_dt))
  • Filter: has_hold
74. 0.000 0.000 ↓ 0.0 0

Index Scan using online_order_part_2020_05_14_pkey on online_order_part_2020_05_14 oo_17 (cost=0.42..0.45 rows=1 width=26) (never executed)

  • Index Cond: (((bill_order_id)::text = (op.bill_order_id)::text) AND (create_dt = op.order_create_dt))
  • Filter: has_hold
75. 0.000 0.000 ↓ 0.0 0

Index Scan using online_order_part_2020_05_15_pkey on online_order_part_2020_05_15 oo_18 (cost=0.42..0.45 rows=1 width=26) (never executed)

  • Index Cond: (((bill_order_id)::text = (op.bill_order_id)::text) AND (create_dt = op.order_create_dt))
  • Filter: has_hold
76. 0.000 0.000 ↓ 0.0 0

Index Scan using online_order_part_2020_05_16_pkey on online_order_part_2020_05_16 oo_19 (cost=0.42..0.45 rows=1 width=26) (never executed)

  • Index Cond: (((bill_order_id)::text = (op.bill_order_id)::text) AND (create_dt = op.order_create_dt))
  • Filter: has_hold
77. 0.000 0.000 ↓ 0.0 0

Index Scan using online_order_part_2020_05_17_pkey on online_order_part_2020_05_17 oo_20 (cost=0.42..0.45 rows=1 width=26) (never executed)

  • Index Cond: (((bill_order_id)::text = (op.bill_order_id)::text) AND (create_dt = op.order_create_dt))
  • Filter: has_hold
78. 0.504 0.504 ↑ 1.0 1 7

Index Scan using online_order_part_2020_05_18_pkey on online_order_part_2020_05_18 oo_21 (cost=0.42..0.44 rows=1 width=26) (actual time=0.070..0.072 rows=1 loops=7)

  • Index Cond: (((bill_order_id)::text = (op.bill_order_id)::text) AND (create_dt = op.order_create_dt))
  • Filter: has_hold