explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vAsf

Settings
# exclusive inclusive rows x rows loops node
1. 1,195.055 133,473.080 ↑ 1.0 1 1

Aggregate (cost=2,636,204.17..2,636,204.18 rows=1 width=8) (actual time=133,473.08..133,473.08 rows=1 loops=1)

  • Buffers: shared hit=21462985 read=831671 written=170, temp read=56513 written=56515
2. 1,487.361 132,278.025 ↑ 10.2 5,370,199 1

Hash Join (cost=1,177,192.85..2,499,783.36 rows=54,568,322 width=0) (actual time=88,458.799..132,278.025 rows=5,370,199 loops=1)

  • Buffers: shared hit=21462985 read=831671 written=170, temp read=56513 written=56515
3. 4,046.516 130,784.848 ↓ 1.0 5,370,199 1

Hash Join (cost=1,176,996.46..1,873,980.45 rows=5,328,220 width=16) (actual time=88,452.958..130,784.848 rows=5,370,199 loops=1)

  • Buffers: shared hit=21462985 read=831669 written=170, temp read=56513 written=56515
4. 3,595.127 113,307.478 ↓ 1.0 5,370,199 1

Hash Join (cost=1,086,400.2..1,739,415.15 rows=5,328,220 width=48) (actual time=75,016.213..113,307.478 rows=5,370,199 loops=1)

  • Buffers: shared hit=16337362 read=794928 written=97, temp read=56513 written=56515
5. 939.747 108,949.750 ↓ 1.0 5,370,199 1

Nested Loop (cost=1,030,513.19..1,669,541.54 rows=5,328,220 width=32) (actual time=74,252.882..108,949.75 rows=5,370,199 loops=1)

  • Buffers: shared hit=16337362 read=766447 written=97, temp read=56513 written=56515
6. 3,126.622 102,639.804 ↓ 1.0 5,370,199 1

Hash Join (cost=1,030,513.19..1,496,374.39 rows=5,328,220 width=60) (actual time=74,252.872..102,639.804 rows=5,370,199 loops=1)

  • Buffers: shared hit=16337362 read=766447 written=97, temp read=56513 written=56515
7. 2,833.026 99,085.140 ↓ 1.0 5,370,199 1

Hash Join (cost=1,015,960.7..1,408,558.88 rows=5,328,220 width=72) (actual time=73,823.309..99,085.14 rows=5,370,199 loops=1)

  • Buffers: shared hit=16337362 read=760720 written=97, temp read=56513 written=56515
8. 5,445.397 96,072.484 ↓ 1.0 5,370,199 1

Hash Join (cost=1,007,654.3..1,386,265.66 rows=5,328,220 width=88) (actual time=73,642.336..96,072.484 rows=5,370,199 loops=1)

  • Buffers: shared hit=16336232 read=759235 written=97, temp read=56513 written=56515
9. 5,667.005 63,967.056 ↓ 1.0 5,370,199 1

Hash Join (cost=515,628.26..880,253.03 rows=5,328,220 width=104) (actual time=46,982.165..63,967.056 rows=5,370,199 loops=1)

  • Buffers: shared hit=16336215 read=506194, temp read=27890 written=27891
10. 2,937.243 11,508.927 ↓ 1.0 5,370,199 1

Hash Join (cost=10,769.08..361,407.26 rows=5,328,220 width=88) (actual time=190.992..11,508.927 rows=5,370,199 loops=1)

  • Buffers: shared hit=126 read=252739
11. 2,692.359 8,538.127 ↓ 1.0 5,370,199 1

Hash Join (cost=8,744.44..338,605.49 rows=5,328,220 width=100) (actual time=157.415..8,538.127 rows=5,370,199 loops=1)

  • Buffers: shared hit=13 read=251809
12. 3,496.210 5,842.206 ↓ 1.0 5,370,199 1

Hash Join (cost=8,516.51..324,380.53 rows=5,328,220 width=84) (actual time=153.768..5,842.206 rows=5,370,199 loops=1)

  • Buffers: shared hit=6 read=251704
13. 2,192.814 2,192.814 ↓ 1.0 5,370,199 1

Seq Scan on claim_product cx (cost=0..301,877.2 rows=5,328,220 width=64) (actual time=0.216..2,192.814 rows=5,370,199 loops=1)

  • Buffers: shared read=248595
14. 75.444 153.182 ↓ 1.0 240,276 1

Hash (cost=5,515.67..5,515.67 rows=240,067 width=36) (actual time=153.182..153.182 rows=240,276 loops=1)

  • Buffers: shared hit=6 read=3109
15. 77.738 77.738 ↓ 1.0 240,276 1

Seq Scan on claim c (cost=0..5,515.67 rows=240,067 width=36) (actual time=0.134..77.738 rows=240,276 loops=1)

  • Buffers: shared hit=6 read=3109
16. 1.240 3.562 ↓ 1.0 5,287 1

Hash (cost=161.86..161.86 rows=5,286 width=24) (actual time=3.562..3.562 rows=5,287 loops=1)

  • Buffers: shared hit=4 read=105
17. 2.322 2.322 ↓ 1.0 5,287 1

Seq Scan on contract_family contract_family (cost=0..161.86 rows=5,286 width=24) (actual time=0.15..2.322 rows=5,287 loops=1)

  • Buffers: shared hit=4 read=105
18. 1.384 33.557 ↓ 66.9 5,287 1

Hash (cost=2,023.65..2,023.65 rows=79 width=20) (actual time=33.557..33.557 rows=5,287 loops=1)

  • Buffers: shared hit=113 read=930
19. 1.902 32.173 ↓ 66.9 5,287 1

Hash Join (cost=1,819.87..2,023.65 rows=79 width=20) (actual time=25.842..32.173 rows=5,287 loops=1)

  • Buffers: shared hit=113 read=930
20. 2.231 30.257 ↓ 1.0 5,287 1

Hash Join (cost=1,818.8..2,008.41 rows=5,286 width=48) (actual time=25.819..30.257 rows=5,287 loops=1)

  • Buffers: shared hit=112 read=930
21. 1.621 2.405 ↓ 1.0 5,287 1

Hash Join (cost=12.03..187.76 rows=5,286 width=48) (actual time=0.102..2.405 rows=5,287 loops=1)

  • Buffers: shared hit=110 read=9
22. 0.690 0.690 ↓ 1.0 5,287 1

Seq Scan on contract_family c_1 (cost=0..161.86 rows=5,286 width=48) (actual time=0.002..0.69 rows=5,287 loops=1)

  • Buffers: shared hit=109
23. 0.022 0.094 ↑ 1.0 90 1

Hash (cost=10.9..10.9 rows=90 width=32) (actual time=0.093..0.094 rows=90 loops=1)

  • Buffers: shared hit=1 read=9
24. 0.072 0.072 ↑ 1.0 90 1

Seq Scan on grouping_company gc (cost=0..10.9 rows=90 width=32) (actual time=0.005..0.072 rows=90 loops=1)

  • Buffers: shared hit=1 read=9
25. 10.303 25.621 ↑ 1.0 39,279 1

Hash (cost=1,315.79..1,315.79 rows=39,279 width=32) (actual time=25.621..25.621 rows=39,279 loops=1)

  • Buffers: shared hit=2 read=921
26. 15.318 15.318 ↑ 1.0 39,279 1

Seq Scan on company cmp (cost=0..1,315.79 rows=39,279 width=32) (actual time=0.179..15.318 rows=39,279 loops=1)

  • Buffers: shared hit=2 read=921
27. 0.007 0.014 ↑ 1.0 3 1

Hash (cost=1.03..1.03 rows=3 width=20) (actual time=0.014..0.014 rows=3 loops=1)

  • Buffers: shared hit=1
28. 0.007 0.007 ↑ 1.0 3 1

Seq Scan on company_type ct (cost=0..1.03 rows=3 width=20) (actual time=0.005..0.007 rows=3 loops=1)

  • Buffers: shared hit=1
29. 1,856.172 46,791.124 ↓ 1,430.5 5,028,093 1

Hash (cost=504,815.24..504,815.24 rows=3,515 width=32) (actual time=46,791.124..46,791.124 rows=5,028,093 loops=1)

  • Buffers: shared hit=16336089 read=253455, temp read=27890 written=27891
30. 1,209.618 44,934.952 ↓ 1,430.5 5,028,093 1

Subquery Scan on conx (cost=504,762.52..504,815.24 rows=3,515 width=32) (actual time=40,973.326..44,934.952 rows=5,028,093 loops=1)

  • Buffers: shared hit=16336089 read=253455, temp read=27890 written=27891
31. 1,431.862 43,725.334 ↓ 1,430.5 5,028,093 1

Unique (cost=504,762.52..504,780.09 rows=3,515 width=49) (actual time=40,973.323..43,725.334 rows=5,028,093 loops=1)

  • Buffers: shared hit=16336089 read=253455, temp read=27890 written=27891
32. 7,963.563 42,293.472 ↓ 1,508.6 5,302,772 1

Sort (cost=504,762.52..504,771.31 rows=3,515 width=49) (actual time=40,973.32..42,293.472 rows=5,302,772 loops=1)

  • Sort Key: clp.claim_product_id, ((cav.contract_state = 'TERMINATED'::enum.contract_state))
  • Sort Method: external merge Disk: 223120kB
  • Buffers: shared hit=16336089 read=253455, temp read=27890 written=27891
33. 940.757 34,329.909 ↓ 1,508.6 5,302,772 1

Nested Loop (cost=10,742.07..504,555.5 rows=3,515 width=49) (actual time=171.637..34,329.909 rows=5,302,772 loops=1)

  • Buffers: shared hit=16336081 read=253455
34. 11,359.137 17,062.708 ↓ 494.0 5,442,148 1

Hash Join (cost=10,741.65..490,955.88 rows=11,017 width=52) (actual time=171.098..17,062.708 rows=5,442,148 loops=1)

  • Buffers: shared hit=4467 read=248591
35. 3,224.675 5,674.402 ↓ 1.0 5,370,199 1

Hash Join (cost=8,516.51..324,380.53 rows=5,328,220 width=40) (actual time=141.823..5,674.402 rows=5,370,199 loops=1)

  • Buffers: shared hit=3119 read=248591
36. 2,309.210 2,309.210 ↓ 1.0 5,370,199 1

Seq Scan on claim_product clp (cost=0..301,877.2 rows=5,328,220 width=52) (actual time=0.015..2,309.21 rows=5,370,199 loops=1)

  • Buffers: shared hit=4 read=248591
37. 79.089 140.517 ↓ 1.0 240,276 1

Hash (cost=5,515.67..5,515.67 rows=240,067 width=20) (actual time=140.517..140.517 rows=240,276 loops=1)

  • Buffers: shared hit=3115
38. 61.428 61.428 ↓ 1.0 240,276 1

Seq Scan on claim cl (cost=0..5,515.67 rows=240,067 width=20) (actual time=0.01..61.428 rows=240,276 loops=1)

  • Buffers: shared hit=3115
39. 3.772 29.169 ↓ 1.0 11,731 1

Hash (cost=2,078.56..2,078.56 rows=11,727 width=38) (actual time=29.169..29.169 rows=11,731 loops=1)

  • Buffers: shared hit=1348
40. 5.326 25.397 ↓ 1.0 11,731 1

Hash Join (cost=898.37..2,078.56 rows=11,727 width=38) (actual time=9.455..25.397 rows=11,731 loops=1)

  • Buffers: shared hit=1348
41. 5.444 17.561 ↓ 1.0 11,731 1

Hash Join (cost=670.44..1,819.81 rows=11,727 width=50) (actual time=6.896..17.561 rows=11,731 loops=1)

  • Buffers: shared hit=1239
42. 5.350 5.350 ↓ 1.0 11,731 1

Seq Scan on contract_amend_version cav (cost=0..1,118.59 rows=11,727 width=36) (actual time=0.013..5.35 rows=11,731 loops=1)

  • Filter: (cav.contract_state = ANY ('{APPROVED,ACTIVE,EXPIRED,TERMINATED}'::enum.contract_state[]))
  • Buffers: shared hit=836
43. 3.873 6.767 ↓ 1.0 11,889 1

Hash (cost=521.86..521.86 rows=11,886 width=46) (actual time=6.767..6.767 rows=11,889 loops=1)

  • Buffers: shared hit=403
44. 2.894 2.894 ↓ 1.0 11,889 1

Seq Scan on contract_renew_version crv (cost=0..521.86 rows=11,886 width=46) (actual time=0.008..2.894 rows=11,889 loops=1)

  • Buffers: shared hit=403
45. 1.245 2.510 ↓ 1.0 5,287 1

Hash (cost=161.86..161.86 rows=5,286 width=20) (actual time=2.51..2.51 rows=5,287 loops=1)

  • Buffers: shared hit=109
46. 1.265 1.265 ↓ 1.0 5,287 1

Seq Scan on contract_family cf (cost=0..161.86 rows=5,286 width=20) (actual time=0.008..1.265 rows=5,287 loops=1)

  • Buffers: shared hit=109
47. 16,326.444 16,326.444 ↑ 1.0 1 5,442,148

Index Only Scan using contract_product_materialized_pkey on contract_product_materialized contract_product_materialized (cost=0.42..1.23 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=5,442,148)

  • Index Cond: ((contract_product_materialized.contract_id = cav.contract_amend_version_id) AND (contract_product_materialized.product_id = clp.product_id))
  • Buffers: shared hit=16331614 read=4864
48. 1,827.328 26,660.031 ↓ 468.7 5,163,167 1

Hash (cost=491,888.33..491,888.33 rows=11,017 width=32) (actual time=26,660.031..26,660.031 rows=5,163,167 loops=1)

  • Buffers: shared hit=17 read=253041 written=97, temp read=28623 written=28624
49. 1,112.335 24,832.703 ↓ 468.7 5,163,167 1

Subquery Scan on ccb (cost=491,723.08..491,888.33 rows=11,017 width=32) (actual time=21,351.733..24,832.703 rows=5,163,167 loops=1)

  • Buffers: shared hit=17 read=253041 written=97, temp read=28623 written=28624
50. 1,283.744 23,720.368 ↓ 468.7 5,163,167 1

Unique (cost=491,723.08..491,778.16 rows=11,017 width=33) (actual time=21,351.729..23,720.368 rows=5,163,167 loops=1)

  • Buffers: shared hit=17 read=253041 written=97, temp read=28623 written=28624
51. 6,941.336 22,436.624 ↓ 494.0 5,442,148 1

Sort (cost=491,723.08..491,750.62 rows=11,017 width=33) (actual time=21,351.725..22,436.624 rows=5,442,148 loops=1)

  • Sort Key: clp_1.claim_product_id, ((cav_1.contract_state = 'TERMINATED'::enum.contract_state))
  • Sort Method: external merge Disk: 228984kB
  • Buffers: shared hit=17 read=253041 written=97, temp read=28623 written=28624
52. 10,446.600 15,495.288 ↓ 494.0 5,442,148 1

Hash Join (cost=10,741.65..490,983.43 rows=11,017 width=33) (actual time=203.716..15,495.288 rows=5,442,148 loops=1)

  • Buffers: shared hit=17 read=253041 written=97
53. 2,853.032 5,008.000 ↓ 1.0 5,370,199 1

Hash Join (cost=8,516.51..324,380.53 rows=5,328,220 width=24) (actual time=162.923..5,008 rows=5,370,199 loops=1)

  • Buffers: shared hit=7 read=251703 written=97
54. 1,993.365 1,993.365 ↓ 1.0 5,370,199 1

Seq Scan on claim_product clp_1 (cost=0..301,877.2 rows=5,328,220 width=36) (actual time=0.009..1,993.365 rows=5,370,199 loops=1)

  • Buffers: shared hit=1 read=248594 written=97
55. 84.763 161.603 ↓ 1.0 240,276 1

Hash (cost=5,515.67..5,515.67 rows=240,067 width=20) (actual time=161.603..161.603 rows=240,276 loops=1)

  • Buffers: shared hit=6 read=3109
56. 76.840 76.840 ↓ 1.0 240,276 1

Seq Scan on claim cl_1 (cost=0..5,515.67 rows=240,067 width=20) (actual time=0.181..76.84 rows=240,276 loops=1)

  • Buffers: shared hit=6 read=3109
57. 4.028 40.688 ↓ 1.0 11,731 1

Hash (cost=2,078.56..2,078.56 rows=11,727 width=38) (actual time=40.688..40.688 rows=11,731 loops=1)

  • Buffers: shared hit=10 read=1338
58. 5.715 36.660 ↓ 1.0 11,731 1

Hash Join (cost=898.37..2,078.56 rows=11,727 width=38) (actual time=14.667..36.66 rows=11,731 loops=1)

  • Buffers: shared hit=10 read=1338
59. 5.916 26.960 ↓ 1.0 11,731 1

Hash Join (cost=670.44..1,819.81 rows=11,727 width=50) (actual time=10.633..26.96 rows=11,731 loops=1)

  • Buffers: shared hit=6 read=1233
60. 10.702 10.702 ↓ 1.0 11,731 1

Seq Scan on contract_amend_version cav_1 (cost=0..1,118.59 rows=11,727 width=36) (actual time=0.194..10.702 rows=11,731 loops=1)

  • Filter: (cav_1.contract_state = ANY ('{APPROVED,ACTIVE,EXPIRED,TERMINATED}'::enum.contract_state[]))
  • Buffers: shared hit=3 read=833
61. 3.917 10.342 ↓ 1.0 11,889 1

Hash (cost=521.86..521.86 rows=11,886 width=46) (actual time=10.342..10.342 rows=11,889 loops=1)

  • Buffers: shared hit=3 read=400
62. 6.425 6.425 ↓ 1.0 11,889 1

Seq Scan on contract_renew_version crv_1 (cost=0..521.86 rows=11,886 width=46) (actual time=0.156..6.425 rows=11,889 loops=1)

  • Buffers: shared hit=3 read=400
63. 1.553 3.985 ↓ 1.0 5,287 1

Hash (cost=161.86..161.86 rows=5,286 width=20) (actual time=3.984..3.985 rows=5,287 loops=1)

  • Buffers: shared hit=4 read=105
64. 2.432 2.432 ↓ 1.0 5,287 1

Seq Scan on contract_family cf_1 (cost=0..161.86 rows=5,286 width=20) (actual time=0.337..2.432 rows=5,287 loops=1)

  • Buffers: shared hit=4 read=105
65. 74.885 179.630 ↓ 1.0 222,530 1

Hash (cost=5,526.4..5,526.4 rows=222,399 width=16) (actual time=179.63..179.63 rows=222,530 loops=1)

  • Buffers: shared hit=1130 read=1485
66. 104.745 104.745 ↓ 1.0 222,530 1

Index Only Scan using claim_transaction_claim_id_idx on claim_transaction claim_transaction (cost=0.42..5,526.4 rows=222,399 width=16) (actual time=0.893..104.745 rows=222,530 loops=1)

  • Buffers: shared hit=1130 read=1485
67. 67.681 428.042 ↓ 1.0 178,977 1

Hash (cost=12,316.94..12,316.94 rows=178,844 width=20) (actual time=428.042..428.042 rows=178,977 loops=1)

  • Buffers: shared read=5727
68. 94.266 360.361 ↓ 1.0 178,977 1

Hash Join (cost=4,504.2..12,316.94 rows=178,844 width=20) (actual time=78.649..360.361 rows=178,977 loops=1)

  • Buffers: shared read=5727
69. 58.896 216.322 ↓ 1.0 178,977 1

Hash Join (cost=1,807.84..8,446.49 rows=178,844 width=20) (actual time=28.456..216.322 rows=178,977 loops=1)

  • Buffers: shared read=4172
70. 79.887 157.294 ↓ 1.0 178,977 1

Hash Join (cost=1,806.78..7,312.74 rows=178,844 width=32) (actual time=28.295..157.294 rows=178,977 loops=1)

  • Buffers: shared read=4171
71. 49.814 49.814 ↓ 1.0 178,977 1

Seq Scan on invoice i (cost=0..5,036.44 rows=178,844 width=32) (actual time=0.277..49.814 rows=178,977 loops=1)

  • Buffers: shared read=3248
72. 13.369 27.593 ↑ 1.0 39,279 1

Hash (cost=1,315.79..1,315.79 rows=39,279 width=32) (actual time=27.593..27.593 rows=39,279 loops=1)

  • Buffers: shared read=923
73. 14.224 14.224 ↑ 1.0 39,279 1

Seq Scan on company clac (cost=0..1,315.79 rows=39,279 width=32) (actual time=0.019..14.224 rows=39,279 loops=1)

  • Buffers: shared read=923
74. 0.014 0.132 ↑ 1.0 3 1

Hash (cost=1.03..1.03 rows=3 width=20) (actual time=0.131..0.132 rows=3 loops=1)

  • Buffers: shared read=1
75. 0.118 0.118 ↑ 1.0 3 1

Seq Scan on company_type clact (cost=0..1.03 rows=3 width=20) (actual time=0.117..0.118 rows=3 loops=1)

  • Buffers: shared read=1
76. 19.449 49.773 ↑ 1.0 50,454 1

Hash (cost=2,062.27..2,062.27 rows=50,727 width=32) (actual time=49.773..49.773 rows=50,454 loops=1)

  • Buffers: shared read=1555
77. 30.324 30.324 ↓ 1.0 50,793 1

Seq Scan on import_invoice ii (cost=0..2,062.27 rows=50,727 width=32) (actual time=0.342..30.324 rows=50,793 loops=1)

  • Buffers: shared read=1555
78. 5,370.199 5,370.199 ↑ 1.0 1 5,370,199

Subquery Scan on cpri (cost=0..0.02 rows=1 width=16) (actual time=0..0.001 rows=1 loops=5,370,199)

  • Filter: (cx.claim_product_id = cpri.claim_product_id)
79. 0.000 0.000 ↑ 1.0 1 5,370,199

Result (cost=0..0.01 rows=1 width=24) (actual time=0..0 rows=1 loops=5,370,199)

80. 139.189 762.601 ↓ 2.9 249,033 1

Hash (cost=54,812.72..54,812.72 rows=85,944 width=32) (actual time=762.601..762.601 rows=249,033 loops=1)

  • Buffers: shared read=28481
81. 540.686 623.412 ↓ 2.9 249,033 1

Bitmap Heap Scan on claim_product_reason_code cprc_override (cost=6,184.59..54,812.72 rows=85,944 width=32) (actual time=91.427..623.412 rows=249,033 loops=1)

  • Buffers: shared read=28481
82. 82.726 82.726 ↓ 2.9 249,033 1

Bitmap Index Scan on claim_product_reason_code_current_idx (cost=0..6,163.1 rows=85,944 width=0) (actual time=82.726..82.726 rows=249,033 loops=1)

  • Index Cond: (cprc_override.claim_reason_type = 'OVERRIDE'::enum.claim_reason_type)
  • Buffers: shared read=2979
83. 1,296.278 13,430.854 ↓ 2.8 2,266,138 1

Hash (cost=78,499..78,499 rows=806,484 width=32) (actual time=13,430.854..13,430.854 rows=2,266,138 loops=1)

  • Buffers: shared hit=5125623 read=36741 written=73
84. 770.870 12,134.576 ↓ 2.8 2,266,138 1

Hash Join (cost=545.95..78,499 rows=806,484 width=32) (actual time=52.287..12,134.576 rows=2,266,138 loops=1)

  • Buffers: shared hit=5125623 read=36741 written=73
85. 419.389 11,358.570 ↓ 2.2 895,649 1

Nested Loop (cost=371.07..67,709.97 rows=407,890 width=64) (actual time=47.118..11,358.57 rows=895,649 loops=1)

  • Buffers: shared hit=5125623 read=36693 written=73
86. 678.990 3,199.761 ↓ 101.1 1,547,884 1

Hash Join (cost=370.65..49,668.88 rows=15,311 width=64) (actual time=10.012..3,199.761 rows=1,547,884 loops=1)

  • Buffers: shared hit=48 read=25534 written=68
87. 718.216 2,517.600 ↓ 101.1 1,547,884 1

Hash Join (cost=287.19..49,457.79 rows=15,311 width=64) (actual time=6.786..2,517.6 rows=1,547,884 loops=1)

  • Buffers: shared hit=48 read=25504 written=68
88. 844.562 1,796.931 ↓ 99.4 1,547,884 1

Hash Join (cost=188.97..49,318.66 rows=15,568 width=48) (actual time=4.307..1,796.931 rows=1,547,884 loops=1)

  • Buffers: shared hit=48 read=25491 written=68
89. 245.059 948.240 ↑ 1.0 1,547,884 1

Append (cost=0..40,998.64 rows=1,548,764 width=48) (actual time=0.145..948.24 rows=1,547,884 loops=1)

  • Buffers: shared read=25491 written=68
90. 0.600 0.600 ↑ 1.0 599 1

Seq Scan on price_default price_default (cost=0..13.99 rows=599 width=48) (actual time=0.143..0.6 rows=599 loops=1)

  • Buffers: shared read=8
91. 700.199 700.199 ↑ 1.0 1,542,993 1

Seq Scan on price_sale price_sale (cost=0..40,841.93 rows=1,542,993 width=48) (actual time=0.094..700.199 rows=1,542,993 loops=1)

  • Buffers: shared read=25412 written=68
92. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on price_company price_company (cost=0..14.2 rows=420 width=48) (actual time=0.007..0.007 rows=0 loops=1)

93. 0.014 0.014 ↓ 0.0 0 1

Seq Scan on price_list price_list (cost=0..14.6 rows=460 width=48) (actual time=0.014..0.014 rows=0 loops=1)

94. 2.361 2.361 ↑ 1.0 4,292 1

Seq Scan on price_class price_class (cost=0..113.92 rows=4,292 width=48) (actual time=0.23..2.361 rows=4,292 loops=1)

  • Buffers: shared read=71
95. 2.513 4.129 ↑ 1.0 5,639 1

Hash (cost=104.39..104.39 rows=5,639 width=32) (actual time=4.129..4.129 rows=5,639 loops=1)

  • Buffers: shared hit=48
96. 1.616 1.616 ↑ 1.0 5,639 1

Seq Scan on product_uom_conversion suomc (cost=0..104.39 rows=5,639 width=32) (actual time=0.008..1.616 rows=5,639 loops=1)

  • Buffers: shared hit=48
97. 1.162 2.453 ↑ 1.0 2,852 1

Hash (cost=62.56..62.56 rows=2,852 width=16) (actual time=2.453..2.453 rows=2,852 loops=1)

  • Buffers: shared read=13
98. 1.291 1.291 ↑ 1.0 2,852 1

Index Only Scan using product_pkey on product pro (cost=0.28..62.56 rows=2,852 width=16) (actual time=0.369..1.291 rows=2,852 loops=1)

  • Buffers: shared read=13
99. 1.287 3.171 ↓ 3.0 3,205 1

Hash (cost=70.1..70.1 rows=1,069 width=16) (actual time=3.171..3.171 rows=3,205 loops=1)

  • Buffers: shared read=30
100. 1.884 1.884 ↓ 3.0 3,205 1

Seq Scan on price_modified pm (cost=0..70.1 rows=1,069 width=16) (actual time=0.201..1.884 rows=3,205 loops=1)

  • Filter: upper_inf(pm.active_range)
  • Buffers: shared read=30
101. 7,739.420 7,739.420 ↑ 27.0 1 1,547,884

Index Scan using idx_claim_product_price_price_id on claim_product_price claim_product_price (cost=0.42..0.91 rows=27 width=32) (actual time=0.004..0.005 rows=1 loops=1,547,884)

  • Index Cond: (claim_product_price.price_id = price_default.price_id)
  • Buffers: shared hit=5125575 read=11159 written=5
102. 2.695 5.136 ↑ 1.0 5,639 1

Hash (cost=104.39..104.39 rows=5,639 width=32) (actual time=5.136..5.136 rows=5,639 loops=1)

  • Buffers: shared read=48
103. 2.441 2.441 ↑ 1.0 5,639 1

Seq Scan on product_uom_conversion tuomc (cost=0..104.39 rows=5,639 width=32) (actual time=0.216..2.441 rows=5,639 loops=1)

  • Buffers: shared read=48
104. 0.052 5.816 ↑ 10.3 115 1

Hash (cost=181.54..181.54 rows=1,188 width=16) (actual time=5.816..5.816 rows=115 loops=1)

  • Buffers: shared read=2
105. 0.388 5.764 ↑ 10.3 115 1

Hash Join (cost=104.61..181.54 rows=1,188 width=16) (actual time=5.225..5.764 rows=115 loops=1)

  • Buffers: shared read=2
106. 5.009 5.009 ↑ 1.7 1,226 1

Foreign Scan (cost=100..171.44 rows=2,048 width=16) (actual time=4.844..5.009 rows=1,226 loops=1)

107. 0.060 0.367 ↑ 1.0 116 1

Hash (cost=3.16..3.16 rows=116 width=32) (actual time=0.367..0.367 rows=116 loops=1)

  • Buffers: shared read=2
108. 0.307 0.307 ↑ 1.0 116 1

Seq Scan on account_client account_client (cost=0..3.16 rows=116 width=32) (actual time=0.261..0.307 rows=116 loops=1)

  • Buffers: shared read=2