explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QwHA

Settings
# exclusive inclusive rows x rows loops node
1. 327.951 463,032.277 ↑ 5.7 61,142 1

Sort (cost=3,934,975.33..3,935,839.84 rows=345,805 width=4,940) (actual time=462,969.428..463,032.277 rows=61,142 loops=1)

  • Sort Key: "*SELECT* 1".value0, "*SELECT* 1".dateacct
  • Sort Method: external merge Disk: 25,664kB
  • Buffers: shared hit=383,050, temp read=13,888 written=13,932
  • Functions: 239
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 33.319 ms, Inlining 21.743 ms, Optimization 2615.930 ms, Emission 1941.900 ms, Total 4612.891 ms
2. 64.815 462,704.326 ↑ 5.7 61,142 1

Unique (cost=2,141,162.45..2,183,523.57 rows=345,805 width=4,940) (actual time=462,531.751..462,704.326 rows=61,142 loops=1)

  • Buffers: shared hit=383,050, temp read=6,942 written=6,964
3. 1,085.958 462,639.511 ↑ 5.7 61,142 1

Sort (cost=2,141,162.45..2,142,026.97 rows=345,805 width=4,940) (actual time=462,531.748..462,639.511 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,664kB
  • Buffers: shared hit=383,050, temp read=6,942 written=6,964
4. 83.532 461,553.553 ↑ 5.7 61,142 1

Append (cost=5,948.52..389,710.69 rows=345,805 width=4,940) (actual time=4,630.458..461,553.553 rows=61,142 loops=1)

  • Buffers: shared hit=383,050
5. 7.172 19,631.568 ↑ 148.0 2,196 1

Subquery Scan on *SELECT* 1 (cost=5,948.52..339,409.35 rows=325,082 width=876) (actual time=4,630.456..19,631.568 rows=2,196 loops=1)

  • Buffers: shared hit=19,527
6. 14,838.841 19,624.396 ↑ 148.0 2,196 1

Hash Left Join (cost=5,948.52..334,533.12 rows=325,082 width=820) (actual time=4,630.447..19,624.396 rows=2,196 loops=1)

  • Hash Cond: ("substring"((ce.value)::text, 1, 10) = (ce6.value)::text)
  • Buffers: shared hit=19,527
7. 8.865 4,784.181 ↑ 148.0 2,196 1

Hash Left Join (cost=5,739.82..161,395.16 rows=325,082 width=505) (actual time=4,621.385..4,784.181 rows=2,196 loops=1)

  • Hash Cond: ("substring"((ce.value)::text, 1, 7) = (ce5.value)::text)
  • Buffers: shared hit=8,397
8. 9.259 4,774.019 ↑ 148.0 2,196 1

Hash Left Join (cost=5,531.12..157,299.84 rows=325,082 width=480) (actual time=4,620.062..4,774.019 rows=2,196 loops=1)

  • Hash Cond: ("substring"((ce.value)::text, 1, 4) = (ce4.value)::text)
  • Buffers: shared hit=8,277
9. 10.299 4,763.281 ↑ 148.0 2,196 1

Hash Left Join (cost=5,322.42..153,204.52 rows=325,082 width=455) (actual time=4,618.553..4,763.281 rows=2,196 loops=1)

  • Hash Cond: ("substring"((ce.value)::text, 1, 2) = (ce3.value)::text)
  • Buffers: shared hit=8,157
10. 4.518 4,751.629 ↑ 148.0 2,196 1

Hash Left Join (cost=5,113.72..149,109.20 rows=325,082 width=430) (actual time=4,617.176..4,751.629 rows=2,196 loops=1)

  • Hash Cond: (f.c_projecttask_id = cpt.c_projecttask_id)
  • Buffers: shared hit=8,037
11. 5.130 4,747.041 ↑ 148.0 2,196 1

Hash Left Join (cost=5,109.50..148,251.63 rows=325,082 width=413) (actual time=4,617.082..4,747.041 rows=2,196 loops=1)

  • Hash Cond: (f.c_project_id = cp.c_project_id)
  • Buffers: shared hit=8,035
12. 6.685 4,740.330 ↑ 148.0 2,196 1

Hash Left Join (cost=4,947.38..147,236.14 rows=325,082 width=396) (actual time=4,615.469..4,740.330 rows=2,196 loops=1)

  • Hash Cond: (f.m_product_id = mp.m_product_id)
  • Buffers: shared hit=7,938
13. 8.487 4,729.526 ↑ 148.0 2,196 1

Hash Left Join (cost=4,471.74..145,906.97 rows=325,082 width=357) (actual time=4,611.295..4,729.526 rows=2,196 loops=1)

  • Hash Cond: (f.c_bpartner_id = bp.c_bpartner_id)
  • Buffers: shared hit=7,626
14. 5.077 4,708.340 ↑ 148.0 2,196 1

Hash Left Join (cost=895.04..141,476.72 rows=325,082 width=316) (actual time=4,598.524..4,708.340 rows=2,196 loops=1)

  • Hash Cond: (f.user2_id = ce2.c_elementvalue_id)
  • Buffers: shared hit=4,392
15. 6.530 4,699.103 ↑ 148.0 2,196 1

Hash Left Join (cost=638.29..140,366.61 rows=325,082 width=282) (actual time=4,594.313..4,699.103 rows=2,196 loops=1)

  • Hash Cond: (f.user1_id = ce1.c_elementvalue_id)
  • Buffers: shared hit=4,272
16. 9.402 4,689.207 ↑ 148.0 2,196 1

Hash Left Join (cost=381.53..139,256.48 rows=325,082 width=248) (actual time=4,590.904..4,689.207 rows=2,196 loops=1)

  • Hash Cond: (f.account_id = ce.c_elementvalue_id)
  • Buffers: shared hit=4,152
17. 8.238 4,676.454 ↑ 148.0 2,196 1

Hash Left Join (cost=124.78..138,145.80 rows=325,082 width=210) (actual time=4,587.519..4,676.454 rows=2,196 loops=1)

  • Hash Cond: (f.ad_table_id = ad.ad_table_id)
  • Buffers: shared hit=4,032
18. 15.247 4,667.475 ↑ 148.0 2,196 1

Hash Left Join (cost=39.16..137,203.99 rows=325,082 width=177) (actual time=4,586.761..4,667.475 rows=2,196 loops=1)

  • Hash Cond: (f.c_period_id = per.c_period_id)
  • Buffers: shared hit=3,975
19. 4,651.816 4,651.816 ↑ 148.0 2,196 1

Index Scan using fact_acct_record_dateacct on fact_acct f (cost=0.56..136,308.28 rows=325,082 width=169) (actual time=4,586.272..4,651.816 rows=2,196 loops=1)

  • Index Cond: ((ad_client_id = '1000000'::numeric) AND (dateacct < '2019-01-01 00:00:00'::timestamp without time zone))
  • Filter: (isactive = 'Y'::bpchar)
  • Buffers: shared hit=3,958
20. 0.205 0.412 ↑ 1.2 770 1

Hash (cost=26.60..26.60 rows=960 width=14) (actual time=0.411..0.412 rows=770 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 44kB
  • Buffers: shared hit=17
21. 0.207 0.207 ↑ 1.2 770 1

Seq Scan on c_period per (cost=0.00..26.60 rows=960 width=14) (actual time=0.032..0.207 rows=770 loops=1)

  • Buffers: shared hit=17
22. 0.327 0.741 ↓ 1.0 1,275 1

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

  • Buckets: 2,048 Batches: 1 Memory Usage: 106kB
  • Buffers: shared hit=57
23. 0.414 0.414 ↓ 1.0 1,275 1

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

  • Buffers: shared hit=57
24. 1.887 3.351 ↓ 1.0 6,081 1

Hash (cost=180.78..180.78 rows=6,078 width=44) (actual time=3.351..3.351 rows=6,081 loops=1)

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

Seq Scan on c_elementvalue ce (cost=0.00..180.78 rows=6,078 width=44) (actual time=0.009..1.464 rows=6,081 loops=1)

  • Buffers: shared hit=120
26. 1.961 3.366 ↓ 1.0 6,081 1

Hash (cost=180.78..180.78 rows=6,078 width=40) (actual time=3.366..3.366 rows=6,081 loops=1)

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

Seq Scan on c_elementvalue ce1 (cost=0.00..180.78 rows=6,078 width=40) (actual time=0.017..1.405 rows=6,081 loops=1)

  • Buffers: shared hit=120
28. 2.487 4.160 ↓ 1.0 6,081 1

Hash (cost=180.78..180.78 rows=6,078 width=40) (actual time=4.160..4.160 rows=6,081 loops=1)

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

Seq Scan on c_elementvalue ce2 (cost=0.00..180.78 rows=6,078 width=40) (actual time=0.025..1.673 rows=6,081 loops=1)

  • Buffers: shared hit=120
30. 5.048 12.699 ↑ 1.0 15,231 1

Hash (cost=3,386.31..3,386.31 rows=15,231 width=47) (actual time=12.699..12.699 rows=15,231 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 1,332kB
  • Buffers: shared hit=3,234
31. 7.651 7.651 ↑ 1.0 15,231 1

Seq Scan on c_bpartner bp (cost=0.00..3,386.31 rows=15,231 width=47) (actual time=0.016..7.651 rows=15,231 loops=1)

  • Buffers: shared hit=3,234
32. 2.047 4.119 ↑ 1.0 7,067 1

Hash (cost=384.73..384.73 rows=7,273 width=45) (actual time=4.119..4.119 rows=7,067 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 605kB
  • Buffers: shared hit=312
33. 2.072 2.072 ↑ 1.0 7,067 1

Seq Scan on m_product mp (cost=0.00..384.73 rows=7,273 width=45) (actual time=0.019..2.072 rows=7,067 loops=1)

  • Buffers: shared hit=312
34. 0.779 1.581 ↑ 1.0 2,762 1

Hash (cost=125.94..125.94 rows=2,894 width=23) (actual time=1.580..1.581 rows=2,762 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 186kB
  • Buffers: shared hit=97
35. 0.802 0.802 ↑ 1.0 2,762 1

Seq Scan on c_project cp (cost=0.00..125.94 rows=2,894 width=23) (actual time=0.017..0.802 rows=2,762 loops=1)

  • Buffers: shared hit=97
36. 0.036 0.070 ↑ 1.0 99 1

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

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

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

  • Buffers: shared hit=2
38. 0.229 1.353 ↓ 1.0 1,020 1

Hash (cost=195.98..195.98 rows=1,018 width=34) (actual time=1.353..1.353 rows=1,020 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 80kB
  • Buffers: shared hit=120
39. 1.124 1.124 ↓ 1.0 1,020 1

Seq Scan on c_elementvalue ce3 (cost=0.00..195.98 rows=1,018 width=34) (actual time=0.015..1.124 rows=1,020 loops=1)

  • Filter: (ad_client_id = '1000000'::numeric)
  • Rows Removed by Filter: 5,061
  • Buffers: shared hit=120
40. 0.257 1.479 ↓ 1.0 1,020 1

Hash (cost=195.98..195.98 rows=1,018 width=34) (actual time=1.479..1.479 rows=1,020 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 80kB
  • Buffers: shared hit=120
41. 1.222 1.222 ↓ 1.0 1,020 1

Seq Scan on c_elementvalue ce4 (cost=0.00..195.98 rows=1,018 width=34) (actual time=0.011..1.222 rows=1,020 loops=1)

  • Filter: (ad_client_id = '1000000'::numeric)
  • Rows Removed by Filter: 5,061
  • Buffers: shared hit=120
42. 0.245 1.297 ↓ 1.0 1,020 1

Hash (cost=195.98..195.98 rows=1,018 width=34) (actual time=1.297..1.297 rows=1,020 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 80kB
  • Buffers: shared hit=120
43. 1.052 1.052 ↓ 1.0 1,020 1

Seq Scan on c_elementvalue ce5 (cost=0.00..195.98 rows=1,018 width=34) (actual time=0.015..1.052 rows=1,020 loops=1)

  • Filter: (ad_client_id = '1000000'::numeric)
  • Rows Removed by Filter: 5,061
  • Buffers: shared hit=120
44. 0.252 1.374 ↓ 1.0 1,020 1

Hash (cost=195.98..195.98 rows=1,018 width=34) (actual time=1.373..1.374 rows=1,020 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 80kB
  • Buffers: shared hit=120
45. 1.122 1.122 ↓ 1.0 1,020 1

Seq Scan on c_elementvalue ce6 (cost=0.00..195.98 rows=1,018 width=34) (actual time=0.011..1.122 rows=1,020 loops=1)

  • Filter: (ad_client_id = '1000000'::numeric)
  • Rows Removed by Filter: 5,061
  • Buffers: shared hit=120
46. 162.024 441,838.453 ↓ 2.8 58,946 1

Subquery Scan on *SELECT* 2 (cost=5,868.62..48,572.32 rows=20,723 width=820) (actual time=38.916..441,838.453 rows=58,946 loops=1)

  • Buffers: shared hit=363,523
47. 438,920.645 441,676.429 ↓ 2.8 58,946 1

Hash Left Join (cost=5,868.62..48,313.28 rows=20,723 width=792) (actual time=38.908..441,676.429 rows=58,946 loops=1)

  • Hash Cond: ("substring"((ce_1.value)::text, 1, 10) = (ce6_1.value)::text)
  • Buffers: shared hit=363,523
48. 202.154 2,754.684 ↓ 2.8 58,946 1

Hash Left Join (cost=5,659.92..37,132.67 rows=20,723 width=505) (actual time=30.430..2,754.684 rows=58,946 loops=1)

  • Hash Cond: ("substring"((ce_1.value)::text, 1, 7) = (ce5_1.value)::text)
  • Buffers: shared hit=22,969
49. 218.592 2,551.388 ↓ 2.8 58,946 1

Hash Left Join (cost=5,451.22..36,676.21 rows=20,723 width=480) (actual time=29.265..2,551.388 rows=58,946 loops=1)

  • Hash Cond: ("substring"((ce_1.value)::text, 1, 4) = (ce4_1.value)::text)
  • Buffers: shared hit=22,849
50. 271.455 2,331.696 ↓ 2.8 58,946 1

Hash Left Join (cost=5,242.52..36,219.75 rows=20,723 width=455) (actual time=28.145..2,331.696 rows=58,946 loops=1)

  • Hash Cond: ("substring"((ce_1.value)::text, 1, 2) = (ce3_1.value)::text)
  • Buffers: shared hit=22,729
51. 137.920 2,058.871 ↓ 2.8 58,946 1

Hash Left Join (cost=5,033.82..35,763.29 rows=20,723 width=430) (actual time=26.749..2,058.871 rows=58,946 loops=1)

  • Hash Cond: (f_1.c_projecttask_id = cpt_1.c_projecttask_id)
  • Buffers: shared hit=22,609
52. 121.215 1,920.893 ↓ 2.8 58,946 1

Hash Left Join (cost=5,029.59..35,704.66 rows=20,723 width=413) (actual time=26.675..1,920.893 rows=58,946 loops=1)

  • Hash Cond: (f_1.c_project_id = cp_1.c_project_id)
  • Buffers: shared hit=22,607
53. 192.664 1,798.276 ↓ 2.8 58,946 1

Hash Left Join (cost=4,867.47..35,488.15 rows=20,723 width=396) (actual time=25.246..1,798.276 rows=58,946 loops=1)

  • Hash Cond: (f_1.m_product_id = mp_1.m_product_id)
  • Buffers: shared hit=22,510
54. 203.558 1,601.502 ↓ 2.8 58,946 1

Hash Left Join (cost=4,391.83..34,958.10 rows=20,723 width=357) (actual time=21.086..1,601.502 rows=58,946 loops=1)

  • Hash Cond: (f_1.c_bpartner_id = bp_1.c_bpartner_id)
  • Buffers: shared hit=22,198
55. 141.570 1,386.064 ↓ 2.8 58,946 1

Hash Left Join (cost=815.13..31,326.99 rows=20,723 width=316) (actual time=9.151..1,386.064 rows=58,946 loops=1)

  • Hash Cond: (f_1.user2_id = ce2_1.c_elementvalue_id)
  • Buffers: shared hit=18,964
56. 130.392 1,241.795 ↓ 2.8 58,946 1

Hash Left Join (cost=558.38..31,015.84 rows=20,723 width=282) (actual time=6.427..1,241.795 rows=58,946 loops=1)

  • Hash Cond: (f_1.user1_id = ce1_1.c_elementvalue_id)
  • Buffers: shared hit=18,844
57. 195.044 1,108.683 ↓ 2.8 58,946 1

Hash Left Join (cost=301.62..30,704.68 rows=20,723 width=248) (actual time=3.682..1,108.683 rows=58,946 loops=1)

  • Hash Cond: (f_1.account_id = ce_1.c_elementvalue_id)
  • Buffers: shared hit=18,724
58. 187.820 910.554 ↓ 2.8 58,946 1

Hash Left Join (cost=44.87..30,393.50 rows=20,723 width=210) (actual time=0.570..910.554 rows=58,946 loops=1)

  • Hash Cond: (f_1.c_period_id = per_1.c_period_id)
  • Buffers: shared hit=18,604
59. 339.097 722.356 ↓ 2.8 58,946 1

Merge Left Join (cost=6.27..30,300.25 rows=20,723 width=202) (actual time=0.174..722.356 rows=58,946 loops=1)

  • Merge Cond: (f_1.ad_table_id = ad_1.ad_table_id)
  • Buffers: shared hit=18,587
60. 382.764 382.764 ↓ 2.8 58,946 1

Index Scan using fact_acct_record_dateacct on fact_acct f_1 (cost=0.56..29,984.53 rows=20,723 width=169) (actual time=0.083..382.764 rows=58,946 loops=1)

  • Index Cond: ((ad_client_id = '1000000'::numeric) AND (dateacct >= to_date('01/01/2019'::text, 'MM/DD/YYYY'::text)) AND (dateacct <= to_date('01/31/2019'::text, 'MM/DD/YYYY'::text)))
  • Filter: (isactive = 'Y'::bpchar)
  • Buffers: shared hit=18,171
61. 0.495 0.495 ↑ 1.9 687 1

Index Scan using ad_table_pkey on ad_table ad_1 (cost=0.28..91.76 rows=1,272 width=38) (actual time=0.013..0.495 rows=687 loops=1)

  • Buffers: shared hit=416
62. 0.204 0.378 ↑ 1.2 770 1

Hash (cost=26.60..26.60 rows=960 width=14) (actual time=0.378..0.378 rows=770 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 44kB
  • Buffers: shared hit=17
63. 0.174 0.174 ↑ 1.2 770 1

Seq Scan on c_period per_1 (cost=0.00..26.60 rows=960 width=14) (actual time=0.015..0.174 rows=770 loops=1)

  • Buffers: shared hit=17
64. 1.706 3.085 ↓ 1.0 6,081 1

Hash (cost=180.78..180.78 rows=6,078 width=44) (actual time=3.085..3.085 rows=6,081 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 532kB
  • Buffers: shared hit=120
65. 1.379 1.379 ↓ 1.0 6,081 1

Seq Scan on c_elementvalue ce_1 (cost=0.00..180.78 rows=6,078 width=44) (actual time=0.012..1.379 rows=6,081 loops=1)

  • Buffers: shared hit=120
66. 1.588 2.720 ↓ 1.0 6,081 1

Hash (cost=180.78..180.78 rows=6,078 width=40) (actual time=2.720..2.720 rows=6,081 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 505kB
  • Buffers: shared hit=120
67. 1.132 1.132 ↓ 1.0 6,081 1

Seq Scan on c_elementvalue ce1_1 (cost=0.00..180.78 rows=6,078 width=40) (actual time=0.008..1.132 rows=6,081 loops=1)

  • Buffers: shared hit=120
68. 1.553 2.699 ↓ 1.0 6,081 1

Hash (cost=180.78..180.78 rows=6,078 width=40) (actual time=2.698..2.699 rows=6,081 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 505kB
  • Buffers: shared hit=120
69. 1.146 1.146 ↓ 1.0 6,081 1

Seq Scan on c_elementvalue ce2_1 (cost=0.00..180.78 rows=6,078 width=40) (actual time=0.009..1.146 rows=6,081 loops=1)

  • Buffers: shared hit=120
70. 4.475 11.880 ↑ 1.0 15,231 1

Hash (cost=3,386.31..3,386.31 rows=15,231 width=47) (actual time=11.880..11.880 rows=15,231 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 1,332kB
  • Buffers: shared hit=3,234
71. 7.405 7.405 ↑ 1.0 15,231 1

Seq Scan on c_bpartner bp_1 (cost=0.00..3,386.31 rows=15,231 width=47) (actual time=0.010..7.405 rows=15,231 loops=1)

  • Buffers: shared hit=3,234
72. 2.024 4.110 ↑ 1.0 7,067 1

Hash (cost=384.73..384.73 rows=7,273 width=45) (actual time=4.110..4.110 rows=7,067 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 605kB
  • Buffers: shared hit=312
73. 2.086 2.086 ↑ 1.0 7,067 1

Seq Scan on m_product mp_1 (cost=0.00..384.73 rows=7,273 width=45) (actual time=0.014..2.086 rows=7,067 loops=1)

  • Buffers: shared hit=312
74. 0.665 1.402 ↑ 1.0 2,762 1

Hash (cost=125.94..125.94 rows=2,894 width=23) (actual time=1.402..1.402 rows=2,762 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 186kB
  • Buffers: shared hit=97
75. 0.737 0.737 ↑ 1.0 2,762 1

Seq Scan on c_project cp_1 (cost=0.00..125.94 rows=2,894 width=23) (actual time=0.015..0.737 rows=2,762 loops=1)

  • Buffers: shared hit=97
76. 0.026 0.058 ↑ 1.0 99 1

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

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

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

  • Buffers: shared hit=2
78. 0.227 1.370 ↓ 1.0 1,020 1

Hash (cost=195.98..195.98 rows=1,018 width=34) (actual time=1.370..1.370 rows=1,020 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 80kB
  • Buffers: shared hit=120
79. 1.143 1.143 ↓ 1.0 1,020 1

Seq Scan on c_elementvalue ce3_1 (cost=0.00..195.98 rows=1,018 width=34) (actual time=0.016..1.143 rows=1,020 loops=1)

  • Filter: (ad_client_id = '1000000'::numeric)
  • Rows Removed by Filter: 5,061
  • Buffers: shared hit=120
80. 0.221 1.100 ↓ 1.0 1,020 1

Hash (cost=195.98..195.98 rows=1,018 width=34) (actual time=1.100..1.100 rows=1,020 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 80kB
  • Buffers: shared hit=120
81. 0.879 0.879 ↓ 1.0 1,020 1

Seq Scan on c_elementvalue ce4_1 (cost=0.00..195.98 rows=1,018 width=34) (actual time=0.010..0.879 rows=1,020 loops=1)

  • Filter: (ad_client_id = '1000000'::numeric)
  • Rows Removed by Filter: 5,061
  • Buffers: shared hit=120
82. 0.252 1.142 ↓ 1.0 1,020 1

Hash (cost=195.98..195.98 rows=1,018 width=34) (actual time=1.142..1.142 rows=1,020 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 80kB
  • Buffers: shared hit=120
83. 0.890 0.890 ↓ 1.0 1,020 1

Seq Scan on c_elementvalue ce5_1 (cost=0.00..195.98 rows=1,018 width=34) (actual time=0.010..0.890 rows=1,020 loops=1)

  • Filter: (ad_client_id = '1000000'::numeric)
  • Rows Removed by Filter: 5,061
  • Buffers: shared hit=120
84. 0.225 1.100 ↓ 1.0 1,020 1

Hash (cost=195.98..195.98 rows=1,018 width=34) (actual time=1.100..1.100 rows=1,020 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 80kB
  • Buffers: shared hit=120
85. 0.875 0.875 ↓ 1.0 1,020 1

Seq Scan on c_elementvalue ce6_1 (cost=0.00..195.98 rows=1,018 width=34) (actual time=0.011..0.875 rows=1,020 loops=1)

  • Filter: (ad_client_id = '1000000'::numeric)
  • Rows Removed by Filter: 5,061
  • Buffers: shared hit=120
Execution time : 463,080.031 ms