explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eypH : Optimization for: cek; plan #hwlV

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.154 3,760.251 ↑ 1.0 1 1

Result (cost=1,508,630.26..1,508,630.33 rows=1 width=32) (actual time=3,760.250..3,760.251 rows=1 loops=1)

2.          

Initplan (forResult)

3. 0.042 0.042 ↑ 1.0 1 1

Index Scan using acc_daily_balance_idx on acc_daily_balance (cost=0.29..2.51 rows=1 width=3) (actual time=0.041..0.042 rows=1 loops=1)

  • Index Cond: (account_id = 4024)
4. 0.005 24.287 ↑ 1.0 1 1

Aggregate (cost=7,530.30..7,530.31 rows=1 width=32) (actual time=24.287..24.287 rows=1 loops=1)

5. 24.282 24.282 ↓ 0.0 0 1

Seq Scan on cash_in (cost=0.00..7,530.27 rows=2 width=23) (actual time=24.282..24.282 rows=0 loops=1)

  • Filter: ((cash_in_date >= '2018-10-01'::date) AND (account_id = 4024) AND ((status)::text = 'CONFIRMED'::text))
  • Rows Removed by Filter: 109188
6. 0.004 22.431 ↑ 1.0 1 1

Aggregate (cost=7,250.21..7,250.22 rows=1 width=32) (actual time=22.431..22.431 rows=1 loops=1)

7. 22.427 22.427 ↓ 0.0 0 1

Seq Scan on cash_out (cost=0.00..7,250.20 rows=2 width=5) (actual time=22.427..22.427 rows=0 loops=1)

  • Filter: ((cash_out_date >= '2018-10-01'::date) AND (account_id = 4024) AND (((status)::text <> 'REJECTED'::text) OR ((status)::text = 'REJECTED'::text)))
  • Rows Removed by Filter: 91117
8. 0.004 23.026 ↑ 1.0 1 1

Aggregate (cost=7,024.43..7,024.44 rows=1 width=32) (actual time=23.026..23.026 rows=1 loops=1)

9. 23.022 23.022 ↓ 0.0 0 1

Seq Scan on cash_out cash_out_1 (cost=0.00..7,024.43 rows=1 width=5) (actual time=23.022..23.022 rows=0 loops=1)

  • Filter: ((cash_out_date >= '2018-10-01'::date) AND (account_id = 4024) AND ((status)::text = 'REJECTED'::text))
  • Rows Removed by Filter: 91117
10. 0.001 0.054 ↑ 1.0 1 1

Aggregate (cost=1,762.64..1,762.65 rows=1 width=32) (actual time=0.054..0.054 rows=1 loops=1)

11. 0.002 0.053 ↓ 0.0 0 1

Nested Loop (cost=0.98..1,762.32 rows=125 width=7) (actual time=0.053..0.053 rows=0 loops=1)

12. 0.051 0.051 ↓ 0.0 0 1

Index Scan using idx3_loan_funding on loan_funding a (cost=0.56..529.87 rows=470 width=15) (actual time=0.051..0.051 rows=0 loops=1)

  • Index Cond: ((lender_id = 4024) AND (funding_date >= '2018-10-01'::date))
13. 0.000 0.000 ↓ 0.0 0

Index Scan using loan_pkey on loan b (cost=0.42..2.61 rows=1 width=8) (never executed)

  • Index Cond: (loan_id = a.loan_id)
  • Filter: ((status)::text = 'APPROVED'::text)
14. 0.002 14.703 ↑ 1.0 1 1

Aggregate (cost=7,897.28..7,897.29 rows=1 width=32) (actual time=14.703..14.703 rows=1 loops=1)

15. 0.002 14.701 ↓ 0.0 0 1

Nested Loop (cost=0.85..7,897.15 rows=52 width=5) (actual time=14.701..14.701 rows=0 loops=1)

16. 14.699 14.699 ↓ 0.0 0 1

Index Scan using loan_drawdown_idx on loan_drawdown a_1 (cost=0.42..7,591.54 rows=115 width=13) (actual time=14.699..14.699 rows=0 loops=1)

  • Index Cond: (lender_id = 4024)
17. 0.000 0.000 ↓ 0.0 0

Index Scan using loan_pkey on loan b_1 (cost=0.42..2.65 rows=1 width=8) (never executed)

  • Index Cond: (loan_id = a_1.loan_id)
  • Filter: ((drawdown_date >= '2018-10-01'::date) AND ((funding_status)::text <> 'CANCELED'::text))
18. 0.007 385.289 ↑ 1.0 1 1

Aggregate (cost=300,385.29..300,385.30 rows=1 width=32) (actual time=385.289..385.289 rows=1 loops=1)

19. 3.253 385.282 ↓ 0.0 0 1

Nested Loop (cost=0.56..300,384.70 rows=238 width=7) (actual time=385.282..385.282 rows=0 loops=1)

20. 332.484 332.484 ↑ 4.7 16,515 1

Seq Scan on payment b_2 (cost=0.00..100,148.60 rows=76,814 width=8) (actual time=0.014..332.484 rows=16,515 loops=1)

  • Filter: ((loan_amortization_id IS NULL) AND (payment_date >= '2018-10-01'::date) AND ((status)::text = 'CONFIRMED'::text))
  • Rows Removed by Filter: 1084203
21. 49.545 49.545 ↓ 0.0 0 16,515

Index Scan using payment_detail_idx on payment_detail a_2 (cost=0.56..2.60 rows=1 width=15) (actual time=0.003..0.003 rows=0 loops=16,515)

  • Index Cond: ((payment_id = b_2.payment_id) AND (lender_id = 4024))
  • Filter: (amount > '0'::numeric)
22. 0.004 1,772.636 ↑ 1.0 1 1

Aggregate (cost=414,766.06..414,766.07 rows=1 width=32) (actual time=1,772.636..1,772.636 rows=1 loops=1)

23. 1.456 1,772.632 ↓ 0.0 0 1

Nested Loop (cost=168,166.64..414,765.26 rows=318 width=6) (actual time=1,772.632..1,772.632 rows=0 loops=1)

24. 203.421 1,761.032 ↑ 40.0 2,536 1

Hash Join (cost=168,166.08..278,590.96 rows=101,332 width=14) (actual time=933.819..1,761.032 rows=2,536 loops=1)

  • Hash Cond: (b_3.loan_id = l.loan_id)
25. 639.708 639.708 ↓ 1.4 509,125 1

Seq Scan on payment b_3 (cost=0.00..102,877.70 rows=375,165 width=22) (actual time=0.039..639.708 rows=509,125 loops=1)

  • Filter: ((loan_amortization_id IS NOT NULL) AND (principal_payment > '0'::numeric) AND (payment_date >= '2018-10-01'::date) AND ((status)::text = 'CONFIRMED'::text))
  • Rows Removed by Filter: 591593
26. 62.515 917.903 ↓ 1.1 200,484 1

Hash (cost=165,104.81..165,104.81 rows=186,581 width=8) (actual time=917.903..917.903 rows=200,484 loops=1)

  • Buckets: 32768 Batches: 8 Memory Usage: 1255kB
27. 855.388 855.388 ↓ 1.1 200,484 1

Seq Scan on loan l (cost=0.00..165,104.81 rows=186,581 width=8) (actual time=0.010..855.388 rows=200,484 loops=1)

  • Filter: ((status)::text <> 'GROUP'::text)
  • Rows Removed by Filter: 528765
28. 10.144 10.144 ↓ 0.0 0 2,536

Index Only Scan using payment_detail_idx on payment_detail a_3 (cost=0.56..1.33 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=2,536)

  • Index Cond: ((payment_id = b_3.payment_id) AND (lender_id = 4024))
  • Heap Fetches: 0
29. 0.006 754.022 ↑ 1.0 1 1

Aggregate (cost=504,142.77..504,142.78 rows=1 width=32) (actual time=754.021..754.022 rows=1 loops=1)

30. 0.002 754.016 ↓ 0.0 0 1

Nested Loop (cost=1.41..504,140.62 rows=859 width=7) (actual time=754.016..754.016 rows=0 loops=1)

31. 0.001 754.014 ↓ 0.0 0 1

Nested Loop (cost=0.99..503,039.22 rows=1,177 width=15) (actual time=754.014..754.014 rows=0 loops=1)

32. 754.013 754.013 ↓ 0.0 0 1

Index Scan using payment_detail_idx on payment_detail a_4 (cost=0.56..494,516.82 rows=3,424 width=15) (actual time=754.013..754.013 rows=0 loops=1)

  • Index Cond: (lender_id = 4024)
33. 0.000 0.000 ↓ 0.0 0

Index Scan using payment_pkey on payment b_4 (cost=0.43..2.48 rows=1 width=16) (never executed)

  • Index Cond: (payment_id = a_4.payment_id)
  • Filter: ((loan_amortization_id IS NOT NULL) AND (principal_payment > '0'::numeric) AND (payment_date >= '2018-10-01'::date) AND ((status)::text = 'CONFIRMED'::text))
34. 0.000 0.000 ↓ 0.0 0

Index Scan using loan_pkey on loan l_1 (cost=0.42..0.93 rows=1 width=8) (never executed)

  • Index Cond: (loan_id = b_4.loan_id)
  • Filter: ((status)::text = 'GROUP'::text)
35. 0.002 0.071 ↑ 1.0 1 1

Aggregate (cost=6,366.76..6,366.77 rows=1 width=32) (actual time=0.071..0.071 rows=1 loops=1)

36. 0.001 0.069 ↓ 0.0 0 1

Nested Loop (cost=1.41..6,366.57 rows=26 width=16) (actual time=0.069..0.069 rows=0 loops=1)

  • Join Filter: (b_5.loan_id = a_5.loan_id)
37. 0.000 0.068 ↓ 0.0 0 1

Nested Loop (cost=0.98..5,344.04 rows=1,456 width=29) (actual time=0.068..0.068 rows=0 loops=1)

38. 0.068 0.068 ↓ 0.0 0 1

Index Scan using idx3_loan_funding on loan_funding b_5 (cost=0.56..1,629.40 rows=1,456 width=15) (actual time=0.068..0.068 rows=0 loops=1)

  • Index Cond: (lender_id = 4024)
39. 0.000 0.000 ↓ 0.0 0

Index Scan using loan_pkey on loan c (cost=0.42..2.54 rows=1 width=14) (never executed)

  • Index Cond: (loan_id = b_5.loan_id)
40. 0.000 0.000 ↓ 0.0 0

Index Scan using payment_idx_2 on payment a_5 (cost=0.43..0.69 rows=1 width=11) (never executed)

  • Index Cond: (loan_id = c.loan_id)
  • Filter: ((penalty_payment IS NOT NULL) AND (loan_amortization_id IS NULL) AND (penalty_payment > '0'::numeric) AND (payment_date >= '2018-10-01'::date) AND ((status)::text <> 'REJECTED'::text))
41. 0.002 0.008 ↑ 1.0 1 1

Aggregate (cost=6,367.71..6,367.72 rows=1 width=32) (actual time=0.008..0.008 rows=1 loops=1)

42. 0.001 0.006 ↓ 0.0 0 1

Nested Loop (cost=1.41..6,366.57 rows=152 width=16) (actual time=0.006..0.006 rows=0 loops=1)

  • Join Filter: (b_6.loan_id = a_6.loan_id)
43. 0.001 0.005 ↓ 0.0 0 1

Nested Loop (cost=0.98..5,344.04 rows=1,456 width=29) (actual time=0.005..0.005 rows=0 loops=1)

44. 0.004 0.004 ↓ 0.0 0 1

Index Scan using idx3_loan_funding on loan_funding b_6 (cost=0.56..1,629.40 rows=1,456 width=15) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (lender_id = 4024)
45. 0.000 0.000 ↓ 0.0 0

Index Scan using loan_pkey on loan c_1 (cost=0.42..2.54 rows=1 width=14) (never executed)

  • Index Cond: (loan_id = b_6.loan_id)
46. 0.000 0.000 ↓ 0.0 0

Index Scan using payment_idx_2 on payment a_6 (cost=0.43..0.69 rows=1 width=11) (never executed)

  • Index Cond: (loan_id = c_1.loan_id)
  • Filter: ((penalty_payment IS NOT NULL) AND (loan_amortization_id IS NOT NULL) AND (penalty_payment > '0'::numeric) AND (payment_date >= '2018-10-01'::date) AND ((status)::text <> 'REJECTED'::text))
47. 0.005 429.054 ↑ 1.0 1 1

Aggregate (cost=107,151.65..107,151.66 rows=1 width=32) (actual time=429.053..429.054 rows=1 loops=1)

48. 0.001 429.049 ↓ 0.0 0 1

Nested Loop (cost=1.42..107,151.59 rows=4 width=14) (actual time=429.049..429.049 rows=0 loops=1)

49. 0.001 429.048 ↓ 0.0 0 1

Nested Loop (cost=0.99..107,149.25 rows=4 width=11) (actual time=429.048..429.048 rows=0 loops=1)

50. 0.057 429.047 ↓ 0.0 0 1

Nested Loop (cost=0.56..107,129.21 rows=8 width=11) (actual time=429.047..429.047 rows=0 loops=1)

51. 428.803 428.803 ↑ 146.4 17 1

Seq Scan on payment b_7 (cost=0.00..102,877.70 rows=2,489 width=19) (actual time=9.707..428.803 rows=17 loops=1)

  • Filter: ((payment_date >= '2018-10-01'::date) AND (interest_payment > '0'::numeric) AND ((status)::text = 'CONFIRMED'::text))
  • Rows Removed by Filter: 1100701
52. 0.187 0.187 ↓ 0.0 0 17

Index Only Scan using payment_detail_idx on payment_detail c_2 (cost=0.56..1.70 rows=1 width=8) (actual time=0.011..0.011 rows=0 loops=17)

  • Index Cond: ((payment_id = b_7.payment_id) AND (lender_id = 4024))
  • Heap Fetches: 0
53. 0.000 0.000 ↓ 0.0 0

Index Scan using loan_amortization_pkey on loan_amortization a_7 (cost=0.43..2.50 rows=1 width=16) (never executed)

  • Index Cond: (loan_amortization_id = b_7.loan_amortization_id)
  • Filter: (payment_date IS NOT NULL)
54. 0.000 0.000 ↓ 0.0 0

Index Scan using loan_pkey on loan d (cost=0.42..0.57 rows=1 width=19) (never executed)

  • Index Cond: (loan_id = a_7.loan_id)
55. 0.003 1.410 ↑ 1.0 1 1

Aggregate (cost=679.33..679.34 rows=1 width=32) (actual time=1.410..1.410 rows=1 loops=1)

56. 0.001 1.407 ↓ 0.0 0 1

Nested Loop (cost=0.42..679.33 rows=1 width=8) (actual time=1.407..1.407 rows=0 loops=1)

57. 1.406 1.406 ↓ 0.0 0 1

Seq Scan on investment_redeem a_8 (cost=0.00..676.68 rows=1 width=16) (actual time=1.406..1.406 rows=0 loops=1)

  • Filter: ((account_id = 4024) AND ((transaction_type)::text = '1'::text) AND (date(create_on) >= '2018-10-01'::date))
  • Rows Removed by Filter: 4472
58. 0.000 0.000 ↓ 0.0 0

Index Only Scan using account_pkey on account b_8 (cost=0.42..2.64 rows=1 width=8) (never executed)

  • Index Cond: (account_id = 4024)
  • Heap Fetches: 0
59. 0.002 1.312 ↑ 1.0 1 1

Aggregate (cost=712.59..712.60 rows=1 width=32) (actual time=1.311..1.312 rows=1 loops=1)

60. 0.002 1.310 ↓ 0.0 0 1

Nested Loop (cost=0.42..712.58 rows=1 width=8) (actual time=1.310..1.310 rows=0 loops=1)

61. 1.308 1.308 ↓ 0.0 0 1

Seq Scan on investment_redeem a_9 (cost=0.00..709.94 rows=1 width=16) (actual time=1.308..1.308 rows=0 loops=1)

  • Filter: ((nav IS NOT NULL) AND (account_id = 4024) AND ((transaction_type)::text = '2'::text) AND (is_use_danamas_ifua = 'T'::bpchar) AND (date(transaction_date) >= '2018-10-01'::date) AND (date(transaction_date) <= '2018-12-31'::date))
  • Rows Removed by Filter: 4472
62. 0.000 0.000 ↓ 0.0 0

Index Only Scan using account_pkey on account b_9 (cost=0.42..2.64 rows=1 width=8) (never executed)

  • Index Cond: (account_id = 4024)
  • Heap Fetches: 0
63. 0.003 1.449 ↑ 1.0 1 1

Aggregate (cost=723.67..723.68 rows=1 width=32) (actual time=1.449..1.449 rows=1 loops=1)

64. 0.001 1.446 ↓ 0.0 0 1

Nested Loop (cost=0.42..723.67 rows=1 width=8) (actual time=1.446..1.446 rows=0 loops=1)

65. 1.445 1.445 ↓ 0.0 0 1

Seq Scan on investment_redeem a_10 (cost=0.00..721.02 rows=1 width=16) (actual time=1.445..1.445 rows=0 loops=1)

  • Filter: ((nav IS NOT NULL) AND (va_date_time IS NOT NULL) AND (account_id = 4024) AND ((transaction_type)::text = '2'::text) AND (is_direct_liquid_funds = 'F'::bpchar) AND (is_use_danamas_ifua = 'F'::bpchar) AND (date(transaction_date) >= '2018-10-01'::date) AND ((notify_sent_status IS NULL) OR (substr((notify_sent_status)::text, 1, 1) <> '1'::text)))
  • Rows Removed by Filter: 4472
66. 0.000 0.000 ↓ 0.0 0

Index Only Scan using account_pkey on account b_10 (cost=0.42..2.64 rows=1 width=8) (never executed)

  • Index Cond: (account_id = 4024)
  • Heap Fetches: 0
67. 0.001 0.735 ↑ 1.0 1 1

Aggregate (cost=723.67..723.68 rows=1 width=32) (actual time=0.735..0.735 rows=1 loops=1)

68. 0.002 0.734 ↓ 0.0 0 1

Nested Loop (cost=0.42..723.67 rows=1 width=6) (actual time=0.734..0.734 rows=0 loops=1)

69. 0.732 0.732 ↓ 0.0 0 1

Seq Scan on investment_redeem a_11 (cost=0.00..721.02 rows=1 width=14) (actual time=0.732..0.732 rows=0 loops=1)

  • Filter: ((account_id = 4024) AND ((transaction_type)::text = '2'::text) AND (is_direct_liquid_funds = 'T'::bpchar) AND (is_use_danamas_ifua = 'F'::bpchar) AND (date(create_on) >= '2018-10-01'::date) AND ((notify_sent_status IS NULL) OR (substr((notify_sent_status)::text, 1, 1) <> '1'::text)))
  • Rows Removed by Filter: 4472
70. 0.000 0.000 ↓ 0.0 0

Index Only Scan using account_pkey on account b_11 (cost=0.42..2.64 rows=1 width=8) (never executed)

  • Index Cond: (account_id = 4024)
  • Heap Fetches: 0
71. 0.002 0.942 ↑ 1.0 1 1

Aggregate (cost=544.68..544.69 rows=1 width=32) (actual time=0.942..0.942 rows=1 loops=1)

72. 0.940 0.940 ↓ 0.0 0 1

Index Scan using uk_mndvu6yqr9ayrw5swlmicegs5 on cash_transfer (cost=0.41..544.67 rows=1 width=5) (actual time=0.940..0.940 rows=0 loops=1)

  • Index Cond: ((from_account_id = 4024) AND (cash_transfer_date >= '2018-10-01'::date))
73. 0.002 0.655 ↑ 1.0 1 1

Aggregate (cost=544.68..544.69 rows=1 width=32) (actual time=0.655..0.655 rows=1 loops=1)

74. 0.653 0.653 ↓ 0.0 0 1

Index Scan using uk_mndvu6yqr9ayrw5swlmicegs5 on cash_transfer cash_transfer_1 (cost=0.41..544.67 rows=1 width=5) (actual time=0.653..0.653 rows=0 loops=1)

  • Index Cond: ((to_account_id = 4024) AND (cash_transfer_date >= '2018-10-01'::date))
75. 0.004 109.031 ↑ 1.0 1 1

Aggregate (cost=43,546.30..43,546.31 rows=1 width=32) (actual time=109.031..109.031 rows=1 loops=1)

76. 109.027 109.027 ↓ 0.0 0 1

Index Scan using other_trans_idx2 on other_transaction (cost=0.55..43,546.30 rows=1 width=5) (actual time=109.027..109.027 rows=0 loops=1)

  • Index Cond: ((account_id = 4024) AND (is_debit = 'F'::bpchar))
  • Filter: (date(transaction_date) >= '2018-10-01'::date)
77. 0.004 109.519 ↑ 1.0 1 1

Aggregate (cost=43,643.08..43,643.09 rows=1 width=32) (actual time=109.519..109.519 rows=1 loops=1)

78. 109.515 109.515 ↓ 0.0 0 1

Index Scan using other_trans_idx2 on other_transaction other_transaction_1 (cost=0.55..43,643.00 rows=30 width=5) (actual time=109.515..109.515 rows=0 loops=1)

  • Index Cond: ((account_id = 4024) AND (is_debit = 'T'::bpchar))
  • Filter: (date(transaction_date) >= '2018-10-01'::date)
79. 0.005 109.401 ↑ 1.0 1 1

Aggregate (cost=46,842.45..46,842.46 rows=1 width=32) (actual time=109.400..109.401 rows=1 loops=1)

80. 109.396 109.396 ↓ 0.0 0 1

Index Scan using other_trans_idx2 on other_transaction other_transaction_2 (cost=0.55..46,842.45 rows=1 width=5) (actual time=109.396..109.396 rows=0 loops=1)

  • Index Cond: ((account_id = 4024) AND (is_debit = 'T'::bpchar) AND (is_reversal = 'T'::bpchar))
  • Filter: (date(reversal_date_time) >= '2018-10-01'::date)
81. 0.004 0.010 ↑ 1.0 1 1

Aggregate (cost=6.80..6.81 rows=1 width=32) (actual time=0.009..0.010 rows=1 loops=1)

82. 0.001 0.006 ↓ 0.0 0 1

Nested Loop (cost=0.84..6.79 rows=1 width=18) (actual time=0.006..0.006 rows=0 loops=1)

83. 0.001 0.005 ↓ 0.0 0 1

Nested Loop (cost=0.43..4.14 rows=1 width=26) (actual time=0.005..0.005 rows=0 loops=1)

84. 0.004 0.004 ↓ 0.0 0 1

Index Scan using cashback_idx on cashback a_12 (cost=0.14..2.73 rows=1 width=34) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (account_id = 4024)
  • Filter: (date(cashback_date) >= '2018-10-01'::date)
85. 0.000 0.000 ↓ 0.0 0

Index Only Scan using cash_transfer_pkey on cash_transfer b_12 (cost=0.29..1.40 rows=1 width=8) (never executed)

  • Index Cond: (cash_transfer_id = a_12.transaction_id)
  • Heap Fetches: 0
86. 0.000 0.000 ↓ 0.0 0

Index Only Scan using account_pkey on account c_3 (cost=0.42..2.64 rows=1 width=8) (never executed)

  • Index Cond: (account_id = a_12.to_account_id)
  • Heap Fetches: 0
87. 0.002 0.010 ↑ 1.0 1 1

Aggregate (cost=15.20..15.21 rows=1 width=32) (actual time=0.010..0.010 rows=1 loops=1)

88. 0.001 0.008 ↓ 0.0 0 1

Nested Loop (cost=0.71..15.18 rows=1 width=36) (actual time=0.008..0.008 rows=0 loops=1)

89. 0.001 0.007 ↓ 0.0 0 1

Nested Loop (cost=0.29..12.54 rows=1 width=44) (actual time=0.007..0.007 rows=0 loops=1)

90. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on cashback a_13 (cost=0.00..11.12 rows=1 width=52) (actual time=0.006..0.006 rows=0 loops=1)

  • Filter: ((to_account_id = 4024) AND (('100'::numeric - cashback_responsible) > '0'::numeric) AND (date(cashback_date) >= '2018-10-01'::date))
91. 0.000 0.000 ↓ 0.0 0

Index Only Scan using cash_transfer_pkey on cash_transfer b_13 (cost=0.29..1.40 rows=1 width=8) (never executed)

  • Index Cond: (cash_transfer_id = a_13.transaction_id)
  • Heap Fetches: 0
92. 0.000 0.000 ↓ 0.0 0

Index Only Scan using account_pkey on account c_4 (cost=0.42..2.64 rows=1 width=8) (never executed)

  • Index Cond: (account_id = a_13.account_id)
  • Heap Fetches: 0
Planning time : 5.444 ms