explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ju2G

Settings
# exclusive inclusive rows x rows loops node
1. 164.168 14,957.110 ↑ 5.4 61,142 1

Sort (cost=4,759,174.39..4,759,997.36 rows=329,189 width=4,940) (actual time=14,918.105..14,957.110 rows=61,142 loops=1)

  • Sort Key: "*SELECT* 1".value0, "*SELECT* 1".dateacct
  • Sort Method: external merge Disk: 25,672kB
  • Buffers: shared hit=369,798 read=116,052, temp read=6,419 written=6,436
2. 51.059 14,792.942 ↑ 5.4 61,142 1

Unique (cost=2,592,502.94..2,632,828.60 rows=329,189 width=4,940) (actual time=14,636.310..14,792.942 rows=61,142 loops=1)

  • Buffers: shared hit=369,798 read=116,052, temp read=3,210 written=3,218
3. 601.498 14,741.883 ↑ 5.4 61,142 1

Sort (cost=2,592,502.94..2,593,325.92 rows=329,189 width=4,940) (actual time=14,636.308..14,741.883 rows=61,142 loops=1)

  • Sort Key: "*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".c_bpartner_id, "*SELECT* 1".value1, "*SELECT* 1".name2, "*SELECT* 1".ad_table_id, "*SELECT* 1".tablename, "*SELECT* 1".name3, "*SELECT* 1".m_product_id, "*SELECT* 1".value2, "*SELECT* 1".name4, "*SELECT* 1".qty, "*SELECT* 1".c_project_id, "*SELECT* 1".value3, "*SELECT* 1".name5, "*SELECT* 1".c_projecttask_id, "*SELECT* 1".name6, "*SELECT* 1".user1_id, "*SELECT* 1".value4, "*SELECT* 1".name7, "*SELECT* 1".user2_id, "*SELECT* 1".value5, "*SELECT* 1".name8, "*SELECT* 1".empre99, "*SELECT* 1".fact_acct_id
  • Sort Method: external merge Disk: 25,680kB
  • Buffers: shared hit=369,798 read=116,052, temp read=3,210 written=3,218
4. 15.986 14,140.385 ↑ 5.4 61,142 1

Append (cost=3,560.06..466,157.15 rows=329,189 width=4,940) (actual time=681.574..14,140.385 rows=61,142 loops=1)

  • Buffers: shared hit=369,798 read=116,052
5. 1.729 1,374.780 ↑ 140.3 2,196 1

Subquery Scan on *SELECT* 1 (cost=3,560.06..376,139.51 rows=308,164 width=875) (actual time=681.573..1,374.780 rows=2,196 loops=1)

  • Buffers: shared hit=18,737 read=116,052
6. 392.249 1,373.051 ↑ 140.3 2,196 1

Hash Left Join (cost=3,560.06..371,517.05 rows=308,164 width=819) (actual time=681.569..1,373.051 rows=2,196 loops=1)

  • Hash Cond: ("substring"((ce.value)::text, 1, 10) = (ce6.value)::text)
  • Buffers: shared hit=18,737 read=116,052
7. 2.081 979.793 ↑ 140.3 2,196 1

Hash Left Join (cost=3,351.38..207,378.52 rows=308,164 width=504) (actual time=680.049..979.793 rows=2,196 loops=1)

  • Hash Cond: ("substring"((ce.value)::text, 1, 7) = (ce5.value)::text)
  • Buffers: shared hit=7,607 read=116,052
8. 2.104 976.708 ↑ 140.3 2,196 1

Hash Left Join (cost=3,142.71..203,485.26 rows=308,164 width=479) (actual time=679.037..976.708 rows=2,196 loops=1)

  • Hash Cond: ("substring"((ce.value)::text, 1, 4) = (ce4.value)::text)
  • Buffers: shared hit=7,487 read=116,052
9. 2.803 973.563 ↑ 140.3 2,196 1

Hash Left Join (cost=2,934.03..199,592.01 rows=308,164 width=454) (actual time=677.988..973.563 rows=2,196 loops=1)

  • Hash Cond: ("substring"((ce.value)::text, 1, 2) = (ce3.value)::text)
  • Buffers: shared hit=7,367 read=116,052
10. 0.952 969.530 ↑ 140.3 2,196 1

Hash Left Join (cost=2,725.36..195,698.75 rows=308,164 width=429) (actual time=676.745..969.530 rows=2,196 loops=1)

  • Hash Cond: (f.c_projecttask_id = cpt.c_projecttask_id)
  • Buffers: shared hit=7,247 read=116,052
11. 0.909 968.532 ↑ 140.3 2,196 1

Hash Left Join (cost=2,721.13..194,885.60 rows=308,164 width=412) (actual time=676.693..968.532 rows=2,196 loops=1)

  • Hash Cond: (f.c_project_id = cp.c_project_id)
  • Buffers: shared hit=7,245 read=116,052
12. 1.167 966.504 ↑ 140.3 2,196 1

Hash Left Join (cost=2,559.06..193,914.56 rows=308,164 width=395) (actual time=675.562..966.504 rows=2,196 loops=1)

  • Hash Cond: (f.m_product_id = mp.m_product_id)
  • Buffers: shared hit=7,148 read=116,052
13. 1.721 962.168 ↑ 140.3 2,196 1

Hash Left Join (cost=2,085.61..192,632.00 rows=308,164 width=356) (actual time=672.372..962.168 rows=2,196 loops=1)

  • Hash Cond: (f.c_bpartner_id = bp.c_bpartner_id)
  • Buffers: shared hit=6,837 read=116,052
14. 0.877 951.248 ↑ 140.3 2,196 1

Hash Left Join (cost=856.02..190,593.28 rows=308,164 width=315) (actual time=663.144..951.248 rows=2,196 loops=1)

  • Hash Cond: (f.user2_id = ce2.c_elementvalue_id)
  • Buffers: shared hit=5,949 read=116,052
15. 0.821 948.171 ↑ 140.3 2,196 1

Hash Left Join (cost=599.31..189,527.63 rows=308,164 width=281) (actual time=660.926..948.171 rows=2,196 loops=1)

  • Hash Cond: (f.user1_id = ce1.c_elementvalue_id)
  • Buffers: shared hit=5,829 read=116,052
16. 1.548 945.035 ↑ 140.3 2,196 1

Hash Left Join (cost=342.59..188,461.95 rows=308,164 width=247) (actual time=658.595..945.035 rows=2,196 loops=1)

  • Hash Cond: (f.account_id = ce.c_elementvalue_id)
  • Buffers: shared hit=5,709 read=116,052
17. 1.428 940.981 ↑ 140.3 2,196 1

Hash Left Join (cost=85.89..187,395.74 rows=308,164 width=209) (actual time=656.072..940.981 rows=2,196 loops=1)

  • Hash Cond: (f.ad_table_id = ad.ad_table_id)
  • Buffers: shared hit=5,589 read=116,052
18. 2.375 939.055 ↑ 140.3 2,196 1

Hash Left Join (cost=29.52..186,527.52 rows=308,164 width=176) (actual time=655.567..939.055 rows=2,196 loops=1)

  • Hash Cond: (f.c_period_id = per.c_period_id)
  • Buffers: shared hit=5,559 read=116,052
19. 936.398 936.398 ↑ 140.3 2,196 1

Seq Scan on fact_acct f (cost=0.00..185,684.40 rows=308,164 width=168) (actual time=655.263..936.398 rows=2,196 loops=1)

  • Filter: ((dateacct < '2019-01-01 00:00:00'::timestamp without time zone) AND (isactive = 'Y'::bpchar) AND (ad_client_id = '1000000'::numeric))
  • Rows Removed by Filter: 3,527,830
  • Buffers: shared hit=5,546 read=116,052
20. 0.138 0.282 ↑ 1.0 734 1

Hash (cost=20.34..20.34 rows=734 width=14) (actual time=0.282..0.282 rows=734 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 42kB
  • Buffers: shared hit=13
21. 0.144 0.144 ↑ 1.0 734 1

Seq Scan on c_period per (cost=0.00..20.34 rows=734 width=14) (actual time=0.011..0.144 rows=734 loops=1)

  • Buffers: shared hit=13
22. 0.242 0.498 ↓ 1.0 1,187 1

Hash (cost=41.72..41.72 rows=1,172 width=38) (actual time=0.498..0.498 rows=1,187 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 99kB
  • Buffers: shared hit=30
23. 0.256 0.256 ↓ 1.0 1,187 1

Seq Scan on ad_table ad (cost=0.00..41.72 rows=1,172 width=38) (actual time=0.007..0.256 rows=1,187 loops=1)

  • Buffers: shared hit=30
24. 1.287 2.506 ↓ 1.0 6,078 1

Hash (cost=180.76..180.76 rows=6,076 width=44) (actual time=2.506..2.506 rows=6,078 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 532kB
  • Buffers: shared hit=120
25. 1.219 1.219 ↓ 1.0 6,078 1

Seq Scan on c_elementvalue ce (cost=0.00..180.76 rows=6,076 width=44) (actual time=0.006..1.219 rows=6,078 loops=1)

  • Buffers: shared hit=120
26. 1.236 2.315 ↓ 1.0 6,078 1

Hash (cost=180.76..180.76 rows=6,076 width=40) (actual time=2.315..2.315 rows=6,078 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 505kB
  • Buffers: shared hit=120
27. 1.079 1.079 ↓ 1.0 6,078 1

Seq Scan on c_elementvalue ce1 (cost=0.00..180.76 rows=6,076 width=40) (actual time=0.008..1.079 rows=6,078 loops=1)

  • Buffers: shared hit=120
28. 1.203 2.200 ↓ 1.0 6,078 1

Hash (cost=180.76..180.76 rows=6,076 width=40) (actual time=2.200..2.200 rows=6,078 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 505kB
  • Buffers: shared hit=120
29. 0.997 0.997 ↓ 1.0 6,078 1

Seq Scan on c_elementvalue ce2 (cost=0.00..180.76 rows=6,076 width=40) (actual time=0.006..0.997 rows=6,078 loops=1)

  • Buffers: shared hit=120
30. 3.426 9.199 ↑ 1.0 15,151 1

Hash (cost=1,039.82..1,039.82 rows=15,182 width=47) (actual time=9.199..9.199 rows=15,151 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 1,326kB
  • Buffers: shared hit=888
31. 5.773 5.773 ↑ 1.0 15,151 1

Seq Scan on c_bpartner bp (cost=0.00..1,039.82 rows=15,182 width=47) (actual time=0.008..5.773 rows=15,151 loops=1)

  • Buffers: shared hit=888
32. 1.501 3.169 ↑ 1.0 7,040 1

Hash (cost=383.20..383.20 rows=7,220 width=45) (actual time=3.169..3.169 rows=7,040 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 603kB
  • Buffers: shared hit=311
33. 1.668 1.668 ↑ 1.0 7,040 1

Seq Scan on m_product mp (cost=0.00..383.20 rows=7,220 width=45) (actual time=0.007..1.668 rows=7,040 loops=1)

  • Buffers: shared hit=311
34. 0.518 1.119 ↑ 1.1 2,715 1

Hash (cost=125.92..125.92 rows=2,892 width=23) (actual time=1.119..1.119 rows=2,715 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 184kB
  • Buffers: shared hit=97
35. 0.601 0.601 ↑ 1.1 2,715 1

Seq Scan on c_project cp (cost=0.00..125.92 rows=2,892 width=23) (actual time=0.010..0.601 rows=2,715 loops=1)

  • Buffers: shared hit=97
36. 0.020 0.046 ↑ 1.0 99 1

Hash (cost=2.99..2.99 rows=99 width=23) (actual time=0.046..0.046 rows=99 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 14kB
  • Buffers: shared hit=2
37. 0.026 0.026 ↑ 1.0 99 1

Seq Scan on c_projecttask cpt (cost=0.00..2.99 rows=99 width=23) (actual time=0.009..0.026 rows=99 loops=1)

  • Buffers: shared hit=2
38. 0.204 1.230 ↑ 1.0 1,018 1

Hash (cost=195.95..195.95 rows=1,018 width=34) (actual time=1.229..1.230 rows=1,018 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 80kB
  • Buffers: shared hit=120
39. 1.026 1.026 ↑ 1.0 1,018 1

Seq Scan on c_elementvalue ce3 (cost=0.00..195.95 rows=1,018 width=34) (actual time=0.010..1.026 rows=1,018 loops=1)

  • Filter: (ad_client_id = '1000000'::numeric)
  • Rows Removed by Filter: 5,060
  • Buffers: shared hit=120
40. 0.178 1.041 ↑ 1.0 1,018 1

Hash (cost=195.95..195.95 rows=1,018 width=34) (actual time=1.041..1.041 rows=1,018 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 80kB
  • Buffers: shared hit=120
41. 0.863 0.863 ↑ 1.0 1,018 1

Seq Scan on c_elementvalue ce4 (cost=0.00..195.95 rows=1,018 width=34) (actual time=0.009..0.863 rows=1,018 loops=1)

  • Filter: (ad_client_id = '1000000'::numeric)
  • Rows Removed by Filter: 5,060
  • Buffers: shared hit=120
42. 0.179 1.004 ↑ 1.0 1,018 1

Hash (cost=195.95..195.95 rows=1,018 width=34) (actual time=1.004..1.004 rows=1,018 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 80kB
  • Buffers: shared hit=120
43. 0.825 0.825 ↑ 1.0 1,018 1

Seq Scan on c_elementvalue ce5 (cost=0.00..195.95 rows=1,018 width=34) (actual time=0.006..0.825 rows=1,018 loops=1)

  • Filter: (ad_client_id = '1000000'::numeric)
  • Rows Removed by Filter: 5,060
  • Buffers: shared hit=120
44. 0.200 1.009 ↑ 1.0 1,018 1

Hash (cost=195.95..195.95 rows=1,018 width=34) (actual time=1.009..1.009 rows=1,018 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 80kB
  • Buffers: shared hit=120
45. 0.809 0.809 ↑ 1.0 1,018 1

Seq Scan on c_elementvalue ce6 (cost=0.00..195.95 rows=1,018 width=34) (actual time=0.005..0.809 rows=1,018 loops=1)

  • Filter: (ad_client_id = '1000000'::numeric)
  • Rows Removed by Filter: 5,060
  • Buffers: shared hit=120
46. 43.989 12,749.619 ↓ 2.8 58,946 1

Subquery Scan on *SELECT* 2 (cost=20,952.40..88,371.69 rows=21,025 width=819) (actual time=85.003..12,749.619 rows=58,946 loops=1)

  • Buffers: shared hit=351,061
47. 11,981.527 12,705.630 ↓ 2.8 58,946 1

Hash Left Join (cost=20,952.40..88,108.88 rows=21,025 width=791) (actual time=85.000..12,705.630 rows=58,946 loops=1)

  • Hash Cond: ("substring"((ce_1.value)::text, 1, 10) = (ce6_1.value)::text)
  • Buffers: shared hit=351,061
48. 62.324 723.087 ↓ 2.8 58,946 1

Hash Left Join (cost=20,743.72..76,768.37 rows=21,025 width=504) (actual time=83.531..723.087 rows=58,946 loops=1)

  • Hash Cond: ("substring"((ce_1.value)::text, 1, 7) = (ce5_1.value)::text)
  • Buffers: shared hit=10,252
49. 62.669 659.766 ↓ 2.8 58,946 1

Hash Left Join (cost=20,535.05..76,308.31 rows=21,025 width=479) (actual time=82.527..659.766 rows=58,946 loops=1)

  • Hash Cond: ("substring"((ce_1.value)::text, 1, 4) = (ce4_1.value)::text)
  • Buffers: shared hit=10,132
50. 80.724 596.005 ↓ 2.8 58,946 1

Hash Left Join (cost=20,326.38..75,848.24 rows=21,025 width=454) (actual time=81.425..596.005 rows=58,946 loops=1)

  • Hash Cond: ("substring"((ce_1.value)::text, 1, 2) = (ce3_1.value)::text)
  • Buffers: shared hit=10,012
51. 27.505 513.796 ↓ 2.8 58,946 1

Hash Left Join (cost=20,117.70..75,388.18 rows=21,025 width=429) (actual time=79.927..513.796 rows=58,946 loops=1)

  • Hash Cond: (f_1.c_projecttask_id = cpt_1.c_projecttask_id)
  • Buffers: shared hit=9,892
52. 29.643 486.244 ↓ 2.8 58,946 1

Hash Left Join (cost=20,113.47..75,328.76 rows=21,025 width=412) (actual time=79.871..486.244 rows=58,946 loops=1)

  • Hash Cond: (f_1.c_project_id = cp_1.c_project_id)
  • Buffers: shared hit=9,890
53. 41.713 455.473 ↓ 2.8 58,946 1

Hash Left Join (cost=19,951.40..75,111.50 rows=21,025 width=395) (actual time=78.725..455.473 rows=58,946 loops=1)

  • Hash Cond: (f_1.m_product_id = mp_1.m_product_id)
  • Buffers: shared hit=9,793
54. 48.572 410.367 ↓ 2.8 58,946 1

Hash Left Join (cost=19,477.95..74,582.85 rows=21,025 width=356) (actual time=75.306..410.367 rows=58,946 loops=1)

  • Hash Cond: (f_1.c_bpartner_id = bp_1.c_bpartner_id)
  • Buffers: shared hit=9,482
55. 29.911 350.142 ↓ 2.8 58,946 1

Hash Left Join (cost=18,248.36..73,298.05 rows=21,025 width=315) (actual time=63.613..350.142 rows=58,946 loops=1)

  • Hash Cond: (f_1.user2_id = ce2_1.c_elementvalue_id)
  • Buffers: shared hit=8,594
56. 28.308 316.385 ↓ 2.8 58,946 1

Hash Left Join (cost=17,991.65..72,986.15 rows=21,025 width=281) (actual time=59.745..316.385 rows=58,946 loops=1)

  • Hash Cond: (f_1.user1_id = ce1_1.c_elementvalue_id)
  • Buffers: shared hit=8,474
57. 45.299 285.499 ↓ 2.8 58,946 1

Hash Left Join (cost=17,734.94..72,674.25 rows=21,025 width=247) (actual time=57.148..285.499 rows=58,946 loops=1)

  • Hash Cond: (f_1.account_id = ce_1.c_elementvalue_id)
  • Buffers: shared hit=8,354
58. 41.957 237.619 ↓ 2.8 58,946 1

Hash Left Join (cost=17,478.23..72,362.32 rows=21,025 width=209) (actual time=54.551..237.619 rows=58,946 loops=1)

  • Hash Cond: (f_1.ad_table_id = ad_1.ad_table_id)
  • Buffers: shared hit=8,234
59. 84.056 195.159 ↓ 2.8 58,946 1

Hash Left Join (cost=17,421.86..72,250.55 rows=21,025 width=176) (actual time=54.038..195.159 rows=58,946 loops=1)

  • Hash Cond: (f_1.c_period_id = per_1.c_period_id)
  • Buffers: shared hit=8,204
60. 57.887 110.815 ↓ 2.8 58,946 1

Bitmap Heap Scan on fact_acct f_1 (cost=17,392.34..72,165.53 rows=21,025 width=168) (actual time=53.733..110.815 rows=58,946 loops=1)

  • Recheck Cond: ((dateacct >= to_date('01/01/2019'::text, 'MM/DD/YYYY'::text)) AND (dateacct <= to_date('01/31/2019'::text, 'MM/DD/YYYY'::text)) AND (ad_client_id = '1000000'::numeric))
  • Filter: (isactive = 'Y'::bpchar)
  • Heap Blocks: exact=5,096
  • Buffers: shared hit=8,191
61. 0.987 52.928 ↓ 0.0 0 1

BitmapAnd (cost=17,392.34..17,392.34 rows=21,025 width=0) (actual time=52.928..52.928 rows=0 loops=1)

  • Buffers: shared hit=3,095
62. 7.514 7.514 ↑ 1.0 144,029 1

Bitmap Index Scan on fact_acct_dateacct (cost=0.00..3,114.62 rows=147,819 width=0) (actual time=7.514..7.514 rows=144,029 loops=1)

  • Index Cond: ((dateacct >= to_date('01/01/2019'::text, 'MM/DD/YYYY'::text)) AND (dateacct <= to_date('01/31/2019'::text, 'MM/DD/YYYY'::text)))
  • Buffers: shared hit=397
63. 44.427 44.427 ↓ 1.0 524,600 1

Bitmap Index Scan on fact_acct_table_record (cost=0.00..14,266.95 rows=520,870 width=0) (actual time=44.427..44.427 rows=524,600 loops=1)

  • Index Cond: (ad_client_id = '1000000'::numeric)
  • Buffers: shared hit=2,698
64. 0.140 0.288 ↑ 1.0 734 1

Hash (cost=20.34..20.34 rows=734 width=14) (actual time=0.287..0.288 rows=734 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 42kB
  • Buffers: shared hit=13
65. 0.148 0.148 ↑ 1.0 734 1

Seq Scan on c_period per_1 (cost=0.00..20.34 rows=734 width=14) (actual time=0.017..0.148 rows=734 loops=1)

  • Buffers: shared hit=13
66. 0.244 0.503 ↓ 1.0 1,187 1

Hash (cost=41.72..41.72 rows=1,172 width=38) (actual time=0.503..0.503 rows=1,187 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 99kB
  • Buffers: shared hit=30
67. 0.259 0.259 ↓ 1.0 1,187 1

Seq Scan on ad_table ad_1 (cost=0.00..41.72 rows=1,172 width=38) (actual time=0.007..0.259 rows=1,187 loops=1)

  • Buffers: shared hit=30
68. 1.309 2.581 ↓ 1.0 6,078 1

Hash (cost=180.76..180.76 rows=6,076 width=44) (actual time=2.581..2.581 rows=6,078 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 532kB
  • Buffers: shared hit=120
69. 1.272 1.272 ↓ 1.0 6,078 1

Seq Scan on c_elementvalue ce_1 (cost=0.00..180.76 rows=6,076 width=44) (actual time=0.007..1.272 rows=6,078 loops=1)

  • Buffers: shared hit=120
70. 1.316 2.578 ↓ 1.0 6,078 1

Hash (cost=180.76..180.76 rows=6,076 width=40) (actual time=2.578..2.578 rows=6,078 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 505kB
  • Buffers: shared hit=120
71. 1.262 1.262 ↓ 1.0 6,078 1

Seq Scan on c_elementvalue ce1_1 (cost=0.00..180.76 rows=6,076 width=40) (actual time=0.010..1.262 rows=6,078 loops=1)

  • Buffers: shared hit=120
72. 1.872 3.846 ↓ 1.0 6,078 1

Hash (cost=180.76..180.76 rows=6,076 width=40) (actual time=3.846..3.846 rows=6,078 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 505kB
  • Buffers: shared hit=120
73. 1.974 1.974 ↓ 1.0 6,078 1

Seq Scan on c_elementvalue ce2_1 (cost=0.00..180.76 rows=6,076 width=40) (actual time=0.012..1.974 rows=6,078 loops=1)

  • Buffers: shared hit=120
74. 4.421 11.653 ↑ 1.0 15,151 1

Hash (cost=1,039.82..1,039.82 rows=15,182 width=47) (actual time=11.653..11.653 rows=15,151 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 1,326kB
  • Buffers: shared hit=888
75. 7.232 7.232 ↑ 1.0 15,151 1

Seq Scan on c_bpartner bp_1 (cost=0.00..1,039.82 rows=15,182 width=47) (actual time=0.019..7.232 rows=15,151 loops=1)

  • Buffers: shared hit=888
76. 1.612 3.393 ↑ 1.0 7,040 1

Hash (cost=383.20..383.20 rows=7,220 width=45) (actual time=3.392..3.393 rows=7,040 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 603kB
  • Buffers: shared hit=311
77. 1.781 1.781 ↑ 1.0 7,040 1

Seq Scan on m_product mp_1 (cost=0.00..383.20 rows=7,220 width=45) (actual time=0.009..1.781 rows=7,040 loops=1)

  • Buffers: shared hit=311
78. 0.526 1.128 ↑ 1.1 2,715 1

Hash (cost=125.92..125.92 rows=2,892 width=23) (actual time=1.128..1.128 rows=2,715 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 184kB
  • Buffers: shared hit=97
79. 0.602 0.602 ↑ 1.1 2,715 1

Seq Scan on c_project cp_1 (cost=0.00..125.92 rows=2,892 width=23) (actual time=0.012..0.602 rows=2,715 loops=1)

  • Buffers: shared hit=97
80. 0.020 0.047 ↑ 1.0 99 1

Hash (cost=2.99..2.99 rows=99 width=23) (actual time=0.047..0.047 rows=99 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 14kB
  • Buffers: shared hit=2
81. 0.027 0.027 ↑ 1.0 99 1

Seq Scan on c_projecttask cpt_1 (cost=0.00..2.99 rows=99 width=23) (actual time=0.010..0.027 rows=99 loops=1)

  • Buffers: shared hit=2
82. 0.228 1.485 ↑ 1.0 1,018 1

Hash (cost=195.95..195.95 rows=1,018 width=34) (actual time=1.485..1.485 rows=1,018 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 80kB
  • Buffers: shared hit=120
83. 1.257 1.257 ↑ 1.0 1,018 1

Seq Scan on c_elementvalue ce3_1 (cost=0.00..195.95 rows=1,018 width=34) (actual time=0.010..1.257 rows=1,018 loops=1)

  • Filter: (ad_client_id = '1000000'::numeric)
  • Rows Removed by Filter: 5,060
  • Buffers: shared hit=120
84. 0.184 1.092 ↑ 1.0 1,018 1

Hash (cost=195.95..195.95 rows=1,018 width=34) (actual time=1.092..1.092 rows=1,018 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 80kB
  • Buffers: shared hit=120
85. 0.908 0.908 ↑ 1.0 1,018 1

Seq Scan on c_elementvalue ce4_1 (cost=0.00..195.95 rows=1,018 width=34) (actual time=0.009..0.908 rows=1,018 loops=1)

  • Filter: (ad_client_id = '1000000'::numeric)
  • Rows Removed by Filter: 5,060
  • Buffers: shared hit=120
86. 0.181 0.997 ↑ 1.0 1,018 1

Hash (cost=195.95..195.95 rows=1,018 width=34) (actual time=0.996..0.997 rows=1,018 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 80kB
  • Buffers: shared hit=120
87. 0.816 0.816 ↑ 1.0 1,018 1

Seq Scan on c_elementvalue ce5_1 (cost=0.00..195.95 rows=1,018 width=34) (actual time=0.007..0.816 rows=1,018 loops=1)

  • Filter: (ad_client_id = '1000000'::numeric)
  • Rows Removed by Filter: 5,060
  • Buffers: shared hit=120
88. 0.183 1.016 ↑ 1.0 1,018 1

Hash (cost=195.95..195.95 rows=1,018 width=34) (actual time=1.016..1.016 rows=1,018 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 80kB
  • Buffers: shared hit=120
89. 0.833 0.833 ↑ 1.0 1,018 1

Seq Scan on c_elementvalue ce6_1 (cost=0.00..195.95 rows=1,018 width=34) (actual time=0.005..0.833 rows=1,018 loops=1)

  • Filter: (ad_client_id = '1000000'::numeric)
  • Rows Removed by Filter: 5,060
  • Buffers: shared hit=120
Planning time : 11.913 ms
Execution time : 14,967.990 ms