explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IuET : SQL

Settings
# exclusive inclusive rows x rows loops node
1. 92.256 4,021.682 ↓ 3.9 27,309 1

Sort (cost=411,504.94..411,522.28 rows=6,937 width=2,698) (actual time=4,000.136..4,021.682 rows=27,309 loops=1)

  • Sort Key: "*SELECT* 1".value0, "*SELECT* 1".dateacct
  • Sort Method: external merge Disk: 8,920kB
  • Buffers: shared hit=1,100,565, temp read=3,418 written=3,436
  • Functions: 472
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 100.301 ms, Inlining 0.000 ms, Optimization 42.156 ms, Emission 587.261 ms, Total 729.717 ms"Execution Time: 4,091.597 ms
2. 30.694 3,929.426 ↓ 3.9 27,309 1

Unique (cost=401,049.64..401,587.25 rows=6,937 width=2,698) (actual time=3,882.209..3,929.426 rows=27,309 loops=1)

  • Buffers: shared hit=1,100,565, temp read=1,712 written=1,721
3. 90.911 3,898.732 ↓ 3.9 27,309 1

Sort (cost=401,049.64..401,066.98 rows=6,937 width=2,698) (actual time=3,882.207..3,898.732 rows=27,309 loops=1)

  • Sort Key: "*SELECT* 1".fact_acct_id, "*SELECT* 1".saldosa, ((0)::numeric), ((0)::numeric), "*SELECT* 1".saldof, "*SELECT* 1".documentno, "*SELECT* 1".record_id, "*SELECT* 1".c_period_id, "*SELECT* 1".name1, "*SELECT* 1".dateacct, "*SELECT* 1".amtacctdr, "*SELECT* 1".amtacctcr, "*SELECT* 1".saldos, "*SELECT* 1".description1, "*SELECT* 1".account_id, "*SELECT* 1".gr1, "*SELECT* 1".name9, "*SELECT* 1".gr2, "*SELECT* 1".name10, "*SELECT* 1".gr3, "*SELECT* 1".name11, "*SELECT* 1".gr4, "*SELECT* 1".name12, "*SELECT* 1".value0, "*SELECT* 1".name13, "*SELECT* 1".description2, "*SELECT* 1".ad_table_id, "*SELECT* 1".tablename, "*SELECT* 1".name3, "*SELECT* 1".empre99
  • Sort Method: external merge Disk: 8,928kB
  • Buffers: shared hit=1,100,565, temp read=1,712 written=1,721
4. 5.237 3,807.821 ↓ 3.9 27,309 1

Append (cost=16,711.05..391,131.95 rows=6,937 width=2,698) (actual time=376.907..3,807.821 rows=27,309 loops=1)

  • Buffers: shared hit=1,100,565
5. 3.074 1,278.948 ↓ 1.1 7,847 1

Subquery Scan on *SELECT* 1 (cost=16,711.05..382,289.97 rows=6,835 width=1,092) (actual time=376.906..1,278.948 rows=7,847 loops=1)

  • Buffers: shared hit=290,002
6. 166.069 1,275.874 ↓ 1.1 7,847 1

Gather (cost=16,711.05..382,187.44 rows=6,835 width=1,036) (actual time=376.902..1,275.874 rows=7,847 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
  • Buffers: shared hit=290,002
7. 0.966 249.663 ↑ 1.1 1,569 5 / 5

Hash Left Join (cost=15,711.05..87,675.45 rows=1,709 width=297) (actual time=238.912..249.663 rows=1,569 loops=5)

  • Hash Cond: (f.ad_table_id = ad.ad_table_id)
  • Buffers: shared hit=41,926
8. 0.940 247.400 ↑ 1.1 1,569 5 / 5

Hash Left Join (cost=15,625.43..87,585.34 rows=1,709 width=264) (actual time=237.600..247.400 rows=1,569 loops=5)

  • Hash Cond: (f.c_period_id = per.c_period_id)
  • Buffers: shared hit=41,641
9. 1.715 246.039 ↑ 1.1 1,569 5 / 5

Nested Loop (cost=15,586.83..87,542.23 rows=1,709 width=256) (actual time=237.162..246.039 rows=1,569 loops=5)

  • Buffers: shared hit=41,556
10. 2.381 239.616 ↑ 1.1 1,569 5 / 5

Hash Join (cost=15,586.40..84,998.28 rows=1,709 width=245) (actual time=237.102..239.616 rows=1,569 loops=5)

  • Hash Cond: (f.account_id = ce.c_elementvalue_id)
  • Buffers: shared hit=10,164
11. 79.136 108.376 ↑ 10.5 1,569 5 / 5

Parallel Bitmap Heap Scan on fact_acct f (cost=15,422.62..84,755.76 rows=16,442 width=115) (actual time=107.613..108.376 rows=1,569 loops=5)

  • Recheck Cond: ((ad_client_id = '1000001'::numeric) AND (date_trunc('day'::text, dateacct) < to_date('2019-01-01'::text, 'YYYY-MM-DD'::text)))
  • Rows Removed by Index Recheck: 3,227
  • Filter: (isactive = 'Y'::bpchar)
  • Heap Blocks: exact=1
  • Buffers: shared hit=9,838
12. 0.397 29.240 ↓ 0.0 0 1 / 5

BitmapAnd (cost=15,422.62..15,422.62 rows=65,766 width=0) (actual time=146.199..146.199 rows=0 loops=1)

  • Buffers: shared hit=6,638
13. 5.083 5.083 ↓ 1.1 210,723 1 / 5

Bitmap Index Scan on fact_acct_table_record (cost=0.00..2,598.86 rows=197,298 width=0) (actual time=25.413..25.414 rows=210,723 loops=1)

  • Index Cond: (ad_client_id = '1000001'::numeric)
  • Buffers: shared hit=1,129
14. 23.760 23.760 ↓ 1.7 2,015,066 1 / 5

Bitmap Index Scan on fact_acct_dateacct_trunc (cost=0.00..12,790.62 rows=1,215,639 width=0) (actual time=118.801..118.801 rows=2,015,066 loops=1)

  • Index Cond: (date_trunc('day'::text, dateacct) < to_date('2019-01-01'::text, 'YYYY-MM-DD'::text))
  • Buffers: shared hit=5,509
15. 0.219 128.859 ↓ 1.0 633 5 / 5

Hash (cost=155.88..155.88 rows=632 width=158) (actual time=128.858..128.859 rows=633 loops=5)

  • Buckets: 1,024 Batches: 1 Memory Usage: 71kB
  • Buffers: shared hit=214
16. 0.220 128.640 ↓ 1.0 633 5 / 5

Nested Loop (cost=9.58..155.88 rows=632 width=158) (actual time=128.191..128.640 rows=633 loops=5)

  • Buffers: shared hit=214
17. 127.928 127.928 ↑ 1.0 1 5 / 5

Seq Scan on ad_client cl (cost=0.00..1.07 rows=1 width=114) (actual time=127.926..127.928 rows=1 loops=5)

  • Filter: (ad_client_id = '1000001'::numeric)
  • Rows Removed by Filter: 5
  • Buffers: shared hit=5
18. 0.265 0.492 ↓ 1.0 633 5 / 5

Bitmap Heap Scan on c_elementvalue ce (cost=9.58..148.48 rows=632 width=44) (actual time=0.245..0.492 rows=633 loops=5)

  • Recheck Cond: (c_element_id = '1000001'::numeric)
  • Heap Blocks: exact=20
  • Buffers: shared hit=209
19. 0.227 0.227 ↓ 1.8 1,153 5 / 5

Bitmap Index Scan on c_elementvalue_value (cost=0.00..9.42 rows=632 width=0) (actual time=0.227..0.227 rows=1,153 loops=5)

  • Index Cond: (c_element_id = '1000001'::numeric)
  • Buffers: shared hit=44
20. 4.708 4.708 ↑ 1.0 1 7,847 / 5

Index Scan using fact_acct_pkey on fact_acct f_1 (cost=0.43..1.49 rows=1 width=18) (actual time=0.003..0.003 rows=1 loops=7,847)

  • Index Cond: (fact_acct_id = f.fact_acct_id)
  • Buffers: shared hit=31,392
21. 0.186 0.421 ↑ 1.2 770 5 / 5

Hash (cost=26.60..26.60 rows=960 width=14) (actual time=0.420..0.421 rows=770 loops=5)

  • Buckets: 1,024 Batches: 1 Memory Usage: 44kB
  • Buffers: shared hit=85
22. 0.235 0.235 ↑ 1.2 770 5 / 5

Seq Scan on c_period per (cost=0.00..26.60 rows=960 width=14) (actual time=0.031..0.235 rows=770 loops=5)

  • Buffers: shared hit=85
23. 0.356 1.297 ↓ 1.0 1,275 5 / 5

Hash (cost=69.72..69.72 rows=1,272 width=38) (actual time=1.297..1.297 rows=1,275 loops=5)

  • Buckets: 2,048 Batches: 1 Memory Usage: 106kB
  • Buffers: shared hit=285
24. 0.941 0.941 ↓ 1.0 1,275 5 / 5

Seq Scan on ad_table ad (cost=0.00..69.72 rows=1,272 width=38) (actual time=0.476..0.941 rows=1,275 loops=5)

  • Buffers: shared hit=285
25.          

SubPlan (for Gather)

26. 0.000 0.000 ↓ 0.0 0

Index Scan using c_order_pkey on c_order (cost=0.42..2.64 rows=1 width=11) (never executed)

  • Index Cond: (c_order_id = f_1.record_id)
27. 0.000 0.000 ↓ 0.0 0

Index Scan using m_inout_pkey on m_inout (cost=0.42..2.64 rows=1 width=13) (never executed)

  • Index Cond: (m_inout_id = f_1.record_id)
28. 7.500 7.500 ↑ 1.0 1 2,500

Index Scan using m_inventory_pkey on m_inventory (cost=0.28..2.50 rows=1 width=9) (actual time=0.002..0.003 rows=1 loops=2,500)

  • Index Cond: (m_inventory_id = f_1.record_id)
  • Buffers: shared hit=7,500
29. 19.276 19.276 ↑ 1.0 1 4,819

Index Scan using c_invoice_key on c_invoice (cost=0.42..2.64 rows=1 width=10) (actual time=0.003..0.004 rows=1 loops=4,819)

  • Index Cond: (c_invoice_id = f_1.record_id)
  • Buffers: shared hit=19,276
30. 0.000 0.000 ↓ 0.0 0

Index Scan using c_payment_pkey on c_payment (cost=0.42..2.64 rows=1 width=7) (never executed)

  • Index Cond: (c_payment_id = f_1.record_id)
31. 0.000 0.000 ↓ 0.0 0

Seq Scan on hr_process (cost=0.00..1.07 rows=1 width=198) (never executed)

  • Filter: (hr_process_id = f_1.record_id)
32. 1.584 1.584 ↑ 1.0 1 528

Index Scan using gl_journal_pkey on gl_journal (cost=0.29..2.50 rows=1 width=11) (actual time=0.003..0.003 rows=1 loops=528)

  • Index Cond: (gl_journal_id = f_1.record_id)
  • Buffers: shared hit=1,584
33. 0.000 0.000 ↓ 0.0 0

Seq Scan on m_requisition (cost=0.00..1.11 rows=1 width=78) (never executed)

  • Filter: (m_requisition_id = f_1.record_id)
34. 0.000 0.000 ↓ 0.0 0

Index Scan using c_invoicebatch_pkey on c_invoicebatch (cost=0.14..2.36 rows=1 width=78) (never executed)

  • Index Cond: (c_invoicebatch_id = f_1.record_id)
35. 0.000 0.000 ↓ 0.0 0

Index Scan using c_allocationhdr_pkey on c_allocationhdr (cost=0.42..2.64 rows=1 width=7) (never executed)

  • Index Cond: (c_allocationhdr_id = f_1.record_id)
36. 0.000 0.000 ↓ 0.0 0

Index Scan using pp_cost_collector_pkey on pp_cost_collector (cost=0.29..2.51 rows=1 width=6) (never executed)

  • Index Cond: (pp_cost_collector_id = f_1.record_id)
37. 0.000 0.000 ↓ 0.0 0

Index Scan using m_movement_pkey on m_movement (cost=0.29..2.51 rows=1 width=9) (never executed)

  • Index Cond: (m_movement_id = f_1.record_id)
38. 0.000 0.000 ↓ 0.0 0

Index Scan using m_matchinv_pkey on m_matchinv (cost=0.29..2.50 rows=1 width=7) (never executed)

  • Index Cond: (m_matchinv_id = f_1.record_id)
39. 0.000 0.000 ↓ 0.0 0

Index Scan using c_bankstatement_pkey on c_bankstatement (cost=0.28..2.50 rows=1 width=7) (never executed)

  • Index Cond: (c_bankstatement_id = f_1.record_id)
40. 54.929 54.929 ↑ 1.0 1 7,847

Index Scan using c_elementvalue_description on c_elementvalue ev (cost=0.28..2.51 rows=1 width=25) (actual time=0.004..0.007 rows=1 loops=7,847)

  • Index Cond: ((description)::text = '1'::text)
  • Filter: ((c_element_id = '1000001'::numeric) AND ("substring"((value)::text, 1, 2) = "substring"((ce.value)::text, 1, 2)))
  • Rows Removed by Filter: 7
  • Buffers: shared hit=23,541
41. 94.164 94.164 ↑ 1.0 1 7,847

Index Scan using c_elementvalue_description on c_elementvalue ev_1 (cost=0.28..2.51 rows=1 width=25) (actual time=0.007..0.012 rows=1 loops=7,847)

  • Index Cond: ((description)::text = '2'::text)
  • Filter: ((c_element_id = '1000001'::numeric) AND ("substring"((value)::text, 1, 4) = "substring"((ce.value)::text, 1, 4)))
  • Rows Removed by Filter: 16
  • Buffers: shared hit=54,929
42. 204.022 204.022 ↑ 1.0 1 7,847

Index Scan using c_elementvalue_description on c_elementvalue ev_2 (cost=0.28..2.51 rows=1 width=25) (actual time=0.007..0.026 rows=1 loops=7,847)

  • Index Cond: ((description)::text = '3'::text)
  • Filter: ((c_element_id = '1000001'::numeric) AND ("substring"((value)::text, 1, 7) = "substring"((ce.value)::text, 1, 7)))
  • Rows Removed by Filter: 42
  • Buffers: shared hit=47,082
43. 478.667 478.667 ↑ 1.0 1 7,847

Index Scan using c_elementvalue_description on c_elementvalue ev_3 (cost=0.28..2.51 rows=1 width=25) (actual time=0.033..0.061 rows=1 loops=7,847)

  • Index Cond: ((description)::text = '4'::text)
  • Filter: ((c_element_id = '1000001'::numeric) AND ("substring"((value)::text, 1, 10) = "substring"((ce.value)::text, 1, 10)))
  • Rows Removed by Filter: 100
  • Buffers: shared hit=94,164
44. 10.097 2,523.636 ↓ 190.8 19,462 1

Subquery Scan on *SELECT* 2 (cost=2,995.86..8,807.30 rows=102 width=1,036) (actual time=32.932..2,523.636 rows=19,462 loops=1)

  • Buffers: shared hit=810,563
45. 126.694 2,513.539 ↓ 190.8 19,462 1

Nested Loop Left Join (cost=2,995.86..8,806.03 rows=102 width=1,008) (actual time=32.928..2,513.539 rows=19,462 loops=1)

  • Buffers: shared hit=810,563
46. 20.040 222.282 ↓ 190.8 19,462 1

Nested Loop Left Join (cost=2,995.58..4,398.75 rows=102 width=264) (actual time=32.655..222.282 rows=19,462 loops=1)

  • Buffers: shared hit=139,030
47. 6.075 163.318 ↓ 190.8 19,462 1

Nested Loop (cost=2,995.30..4,366.29 rows=102 width=256) (actual time=32.624..163.318 rows=19,462 loops=1)

  • Buffers: shared hit=80,644
48. 0.037 0.037 ↑ 1.0 1 1

Seq Scan on ad_client cl_1 (cost=0.00..1.07 rows=1 width=114) (actual time=0.033..0.037 rows=1 loops=1)

  • Filter: (ad_client_id = '1000001'::numeric)
  • Rows Removed by Filter: 5
  • Buffers: shared hit=1
49. 30.396 157.206 ↓ 190.8 19,462 1

Nested Loop (cost=2,995.30..4,364.20 rows=102 width=164) (actual time=32.570..157.206 rows=19,462 loops=1)

  • Buffers: shared hit=80,643
50. 25.363 68.424 ↓ 190.8 19,462 1

Hash Join (cost=2,994.87..4,099.62 rows=102 width=153) (actual time=32.525..68.424 rows=19,462 loops=1)

  • Hash Cond: (f_2.account_id = ce_1.c_elementvalue_id)
  • Buffers: shared hit=2,795
51. 10.812 42.500 ↓ 19.7 19,462 1

Bitmap Heap Scan on fact_acct f_2 (cost=2,838.49..3,940.65 rows=986 width=115) (actual time=31.937..42.500 rows=19,462 loops=1)

  • Recheck Cond: ((date_trunc('day'::text, dateacct) >= to_date('2019-01-01'::text, 'YYYY-MM-DD'::text)) AND (date_trunc('day'::text, dateacct) <= to_date('2019-01-31'::text, 'YYYY-MM-DD'::text)) AND (ad_client_id = '1000001'::numeric))
  • Filter: (isactive = 'Y'::bpchar)
  • Heap Blocks: exact=1,229
  • Buffers: shared hit=2,754
52. 0.604 31.688 ↓ 0.0 0 1

BitmapAnd (cost=2,838.49..2,838.49 rows=986 width=0) (actual time=31.688..31.688 rows=0 loops=1)

  • Buffers: shared hit=1,525
53. 9.810 9.810 ↓ 7.9 144,029 1

Bitmap Index Scan on fact_acct_dateacct_trunc (cost=0.00..238.88 rows=18,235 width=0) (actual time=9.810..9.810 rows=144,029 loops=1)

  • Index Cond: ((date_trunc('day'::text, dateacct) >= to_date('2019-01-01'::text, 'YYYY-MM-DD'::text)) AND (date_trunc('day'::text, dateacct) <= to_date('2019-01-31'::text, 'YYYY-MM-DD'::text)))
  • Buffers: shared hit=397
54. 21.274 21.274 ↓ 1.1 210,723 1

Bitmap Index Scan on fact_acct_table_record (cost=0.00..2,598.86 rows=197,298 width=0) (actual time=21.274..21.274 rows=210,723 loops=1)

  • Index Cond: (ad_client_id = '1000001'::numeric)
  • Buffers: shared hit=1,128
55. 0.175 0.561 ↓ 1.0 633 1

Hash (cost=148.48..148.48 rows=632 width=44) (actual time=0.561..0.561 rows=633 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 59kB
  • Buffers: shared hit=41
56. 0.236 0.386 ↓ 1.0 633 1

Bitmap Heap Scan on c_elementvalue ce_1 (cost=9.58..148.48 rows=632 width=44) (actual time=0.166..0.386 rows=633 loops=1)

  • Recheck Cond: (c_element_id = '1000001'::numeric)
  • Heap Blocks: exact=20
  • Buffers: shared hit=41
57. 0.150 0.150 ↓ 1.8 1,153 1

Bitmap Index Scan on c_elementvalue_value (cost=0.00..9.42 rows=632 width=0) (actual time=0.150..0.150 rows=1,153 loops=1)

  • Index Cond: (c_element_id = '1000001'::numeric)
  • Buffers: shared hit=8
58. 58.386 58.386 ↑ 1.0 1 19,462

Index Scan using fact_acct_pkey on fact_acct f_3 (cost=0.43..2.59 rows=1 width=18) (actual time=0.003..0.003 rows=1 loops=19,462)

  • Index Cond: (fact_acct_id = f_2.fact_acct_id)
  • Buffers: shared hit=77,848
59. 38.924 38.924 ↑ 1.0 1 19,462

Index Scan using c_period_pkey on c_period per_1 (cost=0.28..0.32 rows=1 width=14) (actual time=0.002..0.002 rows=1 loops=19,462)

  • Index Cond: (c_period_id = f_2.c_period_id)
  • Buffers: shared hit=58,386
60. 38.924 38.924 ↑ 1.0 1 19,462

Index Scan using ad_table_pkey on ad_table ad_1 (cost=0.28..0.37 rows=1 width=38) (actual time=0.002..0.002 rows=1 loops=19,462)

  • Index Cond: (ad_table_id = f_2.ad_table_id)
  • Buffers: shared hit=58,386
61.          

SubPlan (for Nested Loop Left Join)

62. 0.000 0.000 ↓ 0.0 0

Index Scan using c_order_pkey on c_order c_order_1 (cost=0.42..2.64 rows=1 width=11) (never executed)

  • Index Cond: (c_order_id = f_3.record_id)
63. 7.374 7.374 ↑ 1.0 1 2,458

Index Scan using m_inout_pkey on m_inout m_inout_1 (cost=0.42..2.64 rows=1 width=13) (actual time=0.003..0.003 rows=1 loops=2,458)

  • Index Cond: (m_inout_id = f_3.record_id)
  • Buffers: shared hit=9,832
64. 0.600 0.600 ↑ 1.0 1 200

Index Scan using m_inventory_pkey on m_inventory m_inventory_1 (cost=0.28..2.50 rows=1 width=9) (actual time=0.002..0.003 rows=1 loops=200)

  • Index Cond: (m_inventory_id = f_3.record_id)
  • Buffers: shared hit=600
65. 17.292 17.292 ↑ 1.0 1 4,323

Index Scan using c_invoice_key on c_invoice c_invoice_1 (cost=0.42..2.64 rows=1 width=10) (actual time=0.003..0.004 rows=1 loops=4,323)

  • Index Cond: (c_invoice_id = f_3.record_id)
  • Buffers: shared hit=17,292
66. 7.560 7.560 ↑ 1.0 1 1,890

Index Scan using c_payment_pkey on c_payment c_payment_1 (cost=0.42..2.64 rows=1 width=7) (actual time=0.003..0.004 rows=1 loops=1,890)

  • Index Cond: (c_payment_id = f_3.record_id)
  • Buffers: shared hit=7,560
67. 0.000 0.000 ↓ 0.0 0

Seq Scan on hr_process hr_process_1 (cost=0.00..1.07 rows=1 width=198) (never executed)

  • Filter: (hr_process_id = f_3.record_id)
68. 2.376 2.376 ↑ 1.0 1 792

Index Scan using gl_journal_pkey on gl_journal gl_journal_1 (cost=0.29..2.50 rows=1 width=11) (actual time=0.002..0.003 rows=1 loops=792)

  • Index Cond: (gl_journal_id = f_3.record_id)
  • Buffers: shared hit=2,376
69. 0.000 0.000 ↓ 0.0 0

Seq Scan on m_requisition m_requisition_1 (cost=0.00..1.11 rows=1 width=78) (never executed)

  • Filter: (m_requisition_id = f_3.record_id)
70. 0.000 0.000 ↓ 0.0 0

Index Scan using c_invoicebatch_pkey on c_invoicebatch c_invoicebatch_1 (cost=0.14..2.36 rows=1 width=78) (never executed)

  • Index Cond: (c_invoicebatch_id = f_3.record_id)
71. 9.438 9.438 ↑ 1.0 1 3,146

Index Scan using c_allocationhdr_pkey on c_allocationhdr c_allocationhdr_1 (cost=0.42..2.64 rows=1 width=7) (actual time=0.003..0.003 rows=1 loops=3,146)

  • Index Cond: (c_allocationhdr_id = f_3.record_id)
  • Buffers: shared hit=12,584
72. 11.712 11.712 ↑ 1.0 1 3,904

Index Scan using pp_cost_collector_pkey on pp_cost_collector pp_cost_collector_1 (cost=0.29..2.51 rows=1 width=6) (actual time=0.003..0.003 rows=1 loops=3,904)

  • Index Cond: (pp_cost_collector_id = f_3.record_id)
  • Buffers: shared hit=11,712
73. 0.240 0.240 ↑ 1.0 1 60

Index Scan using m_movement_pkey on m_movement m_movement_1 (cost=0.29..2.51 rows=1 width=9) (actual time=0.003..0.004 rows=1 loops=60)

  • Index Cond: (m_movement_id = f_3.record_id)
  • Buffers: shared hit=180
74. 1.215 1.215 ↑ 1.0 1 405

Index Scan using m_matchinv_pkey on m_matchinv m_matchinv_1 (cost=0.29..2.50 rows=1 width=7) (actual time=0.003..0.003 rows=1 loops=405)

  • Index Cond: (m_matchinv_id = f_3.record_id)
  • Buffers: shared hit=1,215
75. 4.860 4.860 ↑ 1.0 1 1,620

Index Scan using c_bankstatement_pkey on c_bankstatement c_bankstatement_1 (cost=0.28..2.50 rows=1 width=7) (actual time=0.003..0.003 rows=1 loops=1,620)

  • Index Cond: (c_bankstatement_id = f_3.record_id)
  • Buffers: shared hit=4,860
76. 136.234 136.234 ↑ 1.0 1 19,462

Index Scan using c_elementvalue_description on c_elementvalue ev_4 (cost=0.28..2.51 rows=1 width=25) (actual time=0.004..0.007 rows=1 loops=19,462)

  • Index Cond: ((description)::text = '1'::text)
  • Filter: ((c_element_id = '1000001'::numeric) AND ("substring"((value)::text, 1, 2) = "substring"((ce_1.value)::text, 1, 2)))
  • Rows Removed by Filter: 7
  • Buffers: shared hit=58,386
77. 233.544 233.544 ↑ 1.0 1 19,462

Index Scan using c_elementvalue_description on c_elementvalue ev_5 (cost=0.28..2.51 rows=1 width=25) (actual time=0.007..0.012 rows=1 loops=19,462)

  • Index Cond: ((description)::text = '2'::text)
  • Filter: ((c_element_id = '1000001'::numeric) AND ("substring"((value)::text, 1, 4) = "substring"((ce_1.value)::text, 1, 4)))
  • Rows Removed by Filter: 16
  • Buffers: shared hit=136,234
78. 506.012 506.012 ↑ 1.0 1 19,462

Index Scan using c_elementvalue_description on c_elementvalue ev_6 (cost=0.28..2.51 rows=1 width=25) (actual time=0.010..0.026 rows=1 loops=19,462)

  • Index Cond: ((description)::text = '3'::text)
  • Filter: ((c_element_id = '1000001'::numeric) AND ("substring"((value)::text, 1, 7) = "substring"((ce_1.value)::text, 1, 7)))
  • Rows Removed by Filter: 42
  • Buffers: shared hit=116,772
79. 1,187.182 1,187.182 ↑ 1.0 1 19,462

Index Scan using c_elementvalue_description on c_elementvalue ev_7 (cost=0.28..2.51 rows=1 width=25) (actual time=0.025..0.061 rows=1 loops=19,462)

  • Index Cond: ((description)::text = '4'::text)
  • Filter: ((c_element_id = '1000001'::numeric) AND ("substring"((value)::text, 1, 10) = "substring"((ce_1.value)::text, 1, 10)))
  • Rows Removed by Filter: 100
  • Buffers: shared hit=233,544