explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lS1T

Settings
# exclusive inclusive rows x rows loops node
1. 13.465 10,468.021 ↓ 3.2 11,178 1

Hash Left Join (cost=51,473.36..91,287.18 rows=3,537 width=178) (actual time=9,504.830..10,468.021 rows=11,178 loops=1)

  • Hash Cond: (actor_dgo.actorid = dgo_actor.actorid)
2.          

CTE conso

3. 13.015 262.940 ↑ 1.9 10,879 1

Nested Loop (cost=0.42..37,577.61 rows=20,746 width=939) (actual time=0.056..262.940 rows=10,879 loops=1)

4. 154.879 154.879 ↑ 1.4 6,789 1

Seq Scan on consumption (cost=0.00..5,188.76 rows=9,358 width=95) (actual time=0.032..154.879 rows=6,789 loops=1)

  • Filter: ((deleted IS FALSE) AND ((measurementfrequency)::text <> ALL ('{HOURLY,QUARTER_HOURLY}'::text[])) AND ((todate IS NULL) OR (todate > '2019-01-01'::date)) AND (fromdate <= '2019-07-15'::date) AND ((status)::text = 'ACTUAL'::text))
  • Rows Removed by Filter: 106949
5. 95.046 95.046 ↑ 1.5 2 6,789

Index Scan using "IX_consumptiondetail_consumptionid_consumptiondetail" on consumptiondetail (cost=0.42..3.43 rows=3 width=863) (actual time=0.011..0.014 rows=2 loops=6,789)

  • Index Cond: (consumptionid = consumption.consumptionid)
  • Filter: ((ignored IS FALSE) AND ((measurementnature)::text <> ALL ('{REACTIVE_CAPACITIVE_ENERGY,REACTIVE_CAPACITIVE_POWER,REACTIVE_INDUCTIVE_ENERGY,REACTIVE_INDUCTIVE_POWER}'::text[])))
  • Rows Removed by Filter: 0
6.          

CTE componentnature

7. 0.000 0.599 ↑ 1.0 11 1

Hash Left Join (cost=6.26..12.33 rows=11 width=64) (actual time=0.557..0.599 rows=11 loops=1)

  • Hash Cond: ((componentnature_1.componentnature)::text = (codetranslation.code)::text)
8.          

Initplan (for Hash Left Join)

9. 0.083 0.083 ↑ 1.0 1 1

Index Scan using property_pkey on property (cost=0.27..2.29 rows=1 width=8) (actual time=0.080..0.083 rows=1 loops=1)

  • Index Cond: ((propertycode)::text = 'defaultCountryCode'::text)
10. 0.033 0.558 ↑ 1.0 11 1

Hash Right Join (cost=1.53..7.55 rows=11 width=40) (actual time=0.528..0.558 rows=11 loops=1)

  • Hash Cond: ((codetranslation_1.code)::text = (componentnature_1.componentnature)::text)
11. 0.504 0.504 ↓ 2.2 11 1

Index Scan using codetranslation_category_code_countrycode_idx on codetranslation codetranslation_1 (cost=0.28..6.27 rows=5 width=20) (actual time=0.492..0.504 rows=11 loops=1)

  • Index Cond: (((category)::text = 'componentnature'::text) AND ((countrycode)::text = ($2)::text))
12. 0.010 0.021 ↑ 1.0 11 1

Hash (cost=1.11..1.11 rows=11 width=32) (actual time=0.021..0.021 rows=11 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
13. 0.011 0.011 ↑ 1.0 11 1

Seq Scan on componentnature componentnature_1 (cost=0.00..1.11 rows=11 width=32) (actual time=0.006..0.011 rows=11 loops=1)

14. 0.001 0.020 ↓ 0.0 0 1

Hash (cost=2.43..2.43 rows=1 width=20) (actual time=0.020..0.020 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
15. 0.019 0.019 ↓ 0.0 0 1

Index Scan using codetranslation_category_code_countrycode_idx on codetranslation (cost=0.28..2.43 rows=1 width=20) (actual time=0.019..0.019 rows=0 loops=1)

  • Index Cond: (((category)::text = 'componentnature'::text) AND (countrycode IS NULL))
16. 14.853 10,454.474 ↓ 3.2 11,178 1

Hash Right Join (cost=13,879.80..53,644.99 rows=3,537 width=170) (actual time=9,504.737..10,454.474 rows=11,178 loops=1)

  • Hash Cond: (dp.deliverypointid = deliverypoint.deliverypointid)
17. 14.994 977.597 ↓ 1.0 8,498 1

Hash Left Join (cost=1,146.58..40,844.55 rows=8,494 width=8) (actual time=42.336..977.597 rows=8,498 loops=1)

  • Hash Cond: (((deliveryperiodbrpjournal.brp)::text = (actor_brp.externalid)::text) AND ((dp.market)::text = (actor_brp.marketcode)::text))
18. 16.394 962.542 ↓ 1.0 8,497 1

Hash Left Join (cost=1,143.59..40,709.98 rows=8,494 width=26) (actual time=42.266..962.542 rows=8,497 loops=1)

  • Hash Cond: (((deliveryperiod_1.supplier)::text = (actor_sup.externalid)::text) AND ((dp.market)::text = (actor_sup.marketcode)::text))
19. 34.717 946.087 ↓ 1.0 8,497 1

Hash Left Join (cost=1,140.66..40,620.73 rows=8,494 width=37) (actual time=42.190..946.087 rows=8,497 loops=1)

  • Hash Cond: ((SubPlan 9) = deliveryperiodbrpjournal.deliveryperiodbrpjournalid)
20. 30.353 568.227 ↓ 1.0 8,497 1

Hash Left Join (cost=352.71..20,052.38 rows=8,494 width=26) (actual time=11.699..568.227 rows=8,497 loops=1)

  • Hash Cond: ((SubPlan 8) = deliveryperiod_1.deliveryperiodid)
21. 41.701 323.167 ↓ 1.0 8,497 1

Hash Left Join (cost=6.74..9,747.19 rows=8,494 width=11) (actual time=0.352..323.167 rows=8,497 loops=1)

  • Hash Cond: (((dp.market)::text = (actor_dgo.marketcode)::text) AND ((dp.gridoperator)::text = (actor_dgo.externalid)::text))
  • Join Filter: ((dp.regulator)::text = ((SubPlan 7))::text)
  • Rows Removed by Join Filter: 322
22. 10.642 16.828 ↓ 1.0 8,497 1

Hash Left Join (cost=2.94..299.51 rows=8,494 width=21) (actual time=0.133..16.828 rows=8,497 loops=1)

  • Hash Cond: ((dp.regulator)::text = (actor_reg.externalid)::text)
23. 6.095 6.095 ↓ 1.0 8,497 1

Seq Scan on deliverypoint dp (cost=0.00..239.94 rows=8,494 width=21) (actual time=0.027..6.095 rows=8,497 loops=1)

  • Filter: (deleted IS FALSE)
24. 0.006 0.091 ↑ 1.0 3 1

Hash (cost=2.90..2.90 rows=3 width=13) (actual time=0.091..0.091 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
25. 0.085 0.085 ↑ 1.0 3 1

Seq Scan on actor actor_reg (cost=0.00..2.90 rows=3 width=13) (actual time=0.028..0.085 rows=3 loops=1)

  • Filter: ((role)::text = 'RR'::text)
  • Rows Removed by Filter: 69
26. 0.050 0.128 ↑ 1.0 60 1

Hash (cost=2.90..2.90 rows=60 width=15) (actual time=0.128..0.128 rows=60 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
27. 0.078 0.078 ↑ 1.0 60 1

Seq Scan on actor actor_dgo (cost=0.00..2.90 rows=60 width=15) (actual time=0.022..0.078 rows=60 loops=1)

  • Filter: ((role)::text = ANY ('{D,T}'::text[]))
  • Rows Removed by Filter: 12
28.          

SubPlan (for Hash Left Join)

29. 264.510 264.510 ↑ 1.0 1 8,817

Seq Scan on gridoperator dgo (cost=0.00..1.73 rows=1 width=32) (actual time=0.021..0.030 rows=1 loops=8,817)

  • Filter: (gridoperatorid = actor_dgo.actorid)
  • Rows Removed by Filter: 57
30. 4.388 11.055 ↑ 1.0 8,873 1

Hash (cost=234.32..234.32 rows=8,932 width=15) (actual time=11.055..11.055 rows=8,873 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 543kB
31. 6.667 6.667 ↑ 1.0 8,873 1

Seq Scan on deliveryperiod deliveryperiod_1 (cost=0.00..234.32 rows=8,932 width=15) (actual time=0.016..6.667 rows=8,873 loops=1)

  • Filter: (deleted IS FALSE)
32.          

SubPlan (for Hash Left Join)

33. 33.942 203.652 ↑ 1.0 1 16,971

Limit (cost=2.31..2.32 rows=1 width=8) (actual time=0.012..0.012 rows=1 loops=16,971)

34. 50.913 169.710 ↑ 1.0 1 16,971

Sort (cost=2.31..2.32 rows=1 width=8) (actual time=0.010..0.010 rows=1 loops=16,971)

  • Sort Key: deliveryperiod_3.todate DESC
  • Sort Method: quicksort Memory: 25kB
35. 118.797 118.797 ↑ 1.0 1 16,971

Index Scan using "IX_deliveryperiod_deliverypointid_deliveryperiod" on deliveryperiod deliveryperiod_3 (cost=0.29..2.30 rows=1 width=8) (actual time=0.006..0.007 rows=1 loops=16,971)

  • Index Cond: (deliverypointid = dp.deliverypointid)
  • Filter: (deleted IS FALSE)
36. 4.839 30.441 ↓ 1.0 8,776 1

Hash (cost=678.31..678.31 rows=8,772 width=19) (actual time=30.441..30.441 rows=8,776 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 572kB
37. 10.092 25.602 ↓ 1.0 8,776 1

Hash Join (cost=345.97..678.31 rows=8,772 width=19) (actual time=10.647..25.602 rows=8,776 loops=1)

  • Hash Cond: (deliveryperiodbrpjournal.deliveryperiodid = deliveryperiod_2.deliveryperiodid)
38. 4.923 4.923 ↓ 1.0 8,776 1

Seq Scan on deliveryperiodbrpjournal (cost=0.00..211.72 rows=8,772 width=23) (actual time=0.028..4.923 rows=8,776 loops=1)

39. 4.128 10.587 ↑ 1.0 8,873 1

Hash (cost=234.32..234.32 rows=8,932 width=4) (actual time=10.587..10.587 rows=8,873 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 440kB
40. 6.459 6.459 ↑ 1.0 8,873 1

Seq Scan on deliveryperiod deliveryperiod_2 (cost=0.00..234.32 rows=8,932 width=4) (actual time=0.011..6.459 rows=8,873 loops=1)

  • Filter: (deleted IS FALSE)
41.          

SubPlan (for Hash Left Join)

42. 16.458 312.702 ↑ 1.0 1 16,458

Limit (cost=4.62..4.63 rows=1 width=8) (actual time=0.019..0.019 rows=1 loops=16,458)

43. 65.832 296.244 ↑ 1.0 1 16,458

Sort (cost=4.62..4.63 rows=1 width=8) (actual time=0.017..0.018 rows=1 loops=16,458)

  • Sort Key: deliveryperiodbrpjournal_1.todate DESC
  • Sort Method: quicksort Memory: 25kB
44. 31.080 230.412 ↑ 1.0 1 16,458

Nested Loop (cost=0.57..4.61 rows=1 width=8) (actual time=0.012..0.014 rows=1 loops=16,458)

45. 98.748 98.748 ↑ 1.0 1 16,458

Index Scan using "IX_deliveryperiodbrpjournal_delivetyperiodid_deliveryperiodbrpj" on deliveryperiodbrpjournal deliveryperiodbrpjournal_1 (cost=0.29..2.30 rows=1 width=12) (actual time=0.005..0.006 rows=1 loops=16,458)

  • Index Cond: (deliveryperiodid = deliveryperiod_1.deliveryperiodid)
46. 100.584 100.584 ↑ 1.0 1 16,764

Index Scan using deliveryperiod_pkey on deliveryperiod deliveryperiod_4 (cost=0.29..2.30 rows=1 width=4) (actual time=0.005..0.006 rows=1 loops=16,764)

  • Index Cond: (deliveryperiodid = deliveryperiod_1.deliveryperiodid)
  • Filter: (deleted IS FALSE)
47. 0.004 0.061 ↑ 1.0 2 1

Hash (cost=2.90..2.90 rows=2 width=11) (actual time=0.061..0.061 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
48. 0.057 0.057 ↑ 1.0 2 1

Seq Scan on actor actor_sup (cost=0.00..2.90 rows=2 width=11) (actual time=0.018..0.057 rows=2 loops=1)

  • Filter: ((role)::text = 'S'::text)
  • Rows Removed by Filter: 70
49. 0.008 0.061 ↑ 1.0 6 1

Hash (cost=2.90..2.90 rows=6 width=11) (actual time=0.061..0.061 rows=6 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
50. 0.053 0.053 ↑ 1.0 6 1

Seq Scan on actor actor_brp (cost=0.00..2.90 rows=6 width=11) (actual time=0.014..0.053 rows=6 loops=1)

  • Filter: ((role)::text = 'B'::text)
  • Rows Removed by Filter: 66
51. 14.797 9,462.024 ↓ 3.2 11,178 1

Hash (cost=12,689.01..12,689.01 rows=3,537 width=170) (actual time=9,462.024..9,462.024 rows=11,178 loops=1)

  • Buckets: 16384 (originally 4096) Batches: 1 (originally 1) Memory Usage: 1749kB
52. 173.569 9,447.227 ↓ 3.2 11,178 1

Nested Loop Left Join (cost=4,438.07..12,689.01 rows=3,537 width=170) (actual time=519.458..9,447.227 rows=11,178 loops=1)

53. 16.408 9,206.590 ↓ 3.2 11,178 1

Hash Left Join (cost=4,436.07..5,424.15 rows=3,537 width=170) (actual time=518.889..9,206.590 rows=11,178 loops=1)

  • Hash Cond: (cu.customerid = crm.customerid)
54. 17.715 9,181.645 ↓ 3.2 11,178 1

Hash Left Join (cost=4,190.90..5,130.35 rows=3,537 width=170) (actual time=510.333..9,181.645 rows=11,178 loops=1)

  • Hash Cond: (co.customerid = cu.customerid)
55. 55.879 9,153.313 ↓ 3.2 11,178 1

Hash Join (cost=3,885.73..4,776.55 rows=3,537 width=157) (actual time=499.693..9,153.313 rows=11,178 loops=1)

  • Hash Cond: ((SubPlan 4) = generalconfig.generalconfigid)
56. 21.457 484.298 ↓ 3.5 12,557 1

Hash Right Join (cost=3,086.33..3,454.28 rows=3,578 width=122) (actual time=453.309..484.298 rows=12,557 loops=1)

  • Hash Cond: (co.contractid = cdp.contractid)
57. 9.756 9.756 ↓ 1.0 10,414 1

Seq Scan on contract co (cost=0.00..280.11 rows=10,411 width=28) (actual time=0.202..9.756 rows=10,414 loops=1)

58. 7.312 453.085 ↓ 3.5 12,557 1

Hash (cost=3,041.61..3,041.61 rows=3,578 width=98) (actual time=453.085..453.085 rows=12,557 loops=1)

  • Buckets: 16384 (originally 4096) Batches: 1 (originally 1) Memory Usage: 1149kB
59. 13.287 445.773 ↓ 3.5 12,557 1

Hash Right Join (cost=2,715.72..3,041.61 rows=3,578 width=98) (actual time=426.890..445.773 rows=12,557 loops=1)

  • Hash Cond: (cdp.deliveryperiodid = deliveryperiod.deliveryperiodid)
60. 5.807 5.807 ↓ 1.0 10,629 1

Seq Scan on contractdelivery cdp (cost=0.00..250.26 rows=10,626 width=12) (actual time=0.191..5.807 rows=10,629 loops=1)

61. 6.248 426.679 ↓ 3.6 10,879 1

Hash (cost=2,678.12..2,678.12 rows=3,008 width=94) (actual time=426.679..426.679 rows=10,879 loops=1)

  • Buckets: 16384 (originally 4096) Batches: 1 (originally 1) Memory Usage: 973kB
62. 15.053 420.431 ↓ 3.6 10,879 1

Hash Right Join (cost=2,376.80..2,678.12 rows=3,008 width=94) (actual time=397.998..420.431 rows=10,879 loops=1)

  • Hash Cond: ((deliveryperiod.deliverypointcomponentid = deliverypointcomponent.deliverypointcomponentid) AND (deliveryperiod.deliveryperiodid = c.deliveryperiodid))
63. 7.428 7.428 ↑ 1.0 8,873 1

Seq Scan on deliveryperiod (cost=0.00..234.32 rows=8,932 width=8) (actual time=0.018..7.428 rows=8,873 loops=1)

  • Filter: (deleted IS FALSE)
64. 9.307 397.950 ↓ 3.6 10,879 1

Hash (cost=2,331.68..2,331.68 rows=3,008 width=98) (actual time=397.950..397.950 rows=10,879 loops=1)

  • Buckets: 16384 (originally 4096) Batches: 1 (originally 1) Memory Usage: 986kB
65. 13.701 388.643 ↓ 3.6 10,879 1

Hash Left Join (cost=654.93..2,331.68 rows=3,008 width=98) (actual time=29.008..388.643 rows=10,879 loops=1)

  • Hash Cond: (c.deliverypointid = deliverypoint.deliverypointid)
66. 9.988 360.413 ↓ 3.6 10,879 1

Nested Loop Left Join (cost=308.81..1,944.21 rows=3,008 width=76) (actual time=14.445..360.413 rows=10,879 loops=1)

67. 14.121 339.546 ↓ 3.6 10,879 1

Hash Left Join (cost=308.52..914.04 rows=3,008 width=48) (actual time=14.442..339.546 rows=10,879 loops=1)

  • Hash Cond: ((deliverypointcomponent.componentnature)::text = (componentnature.componentnature)::text)
68. 12.490 324.728 ↓ 3.6 10,879 1

Hash Left Join (cost=306.77..870.93 rows=3,008 width=24) (actual time=13.734..324.728 rows=10,879 loops=1)

  • Hash Cond: (c.deliverypointcomponentid = deliverypointcomponent.deliverypointcomponentid)
69. 16.711 298.687 ↓ 3.6 10,879 1

Hash Join (cost=1.65..524.45 rows=3,008 width=16) (actual time=0.148..298.687 rows=10,879 loops=1)

  • Hash Cond: ((c.measurementnature)::text = (measurementnature.nature)::text)
70. 281.903 281.903 ↑ 1.9 10,879 1

CTE Scan on conso c (cost=0.00..414.92 rows=20,746 width=52) (actual time=0.061..281.903 rows=10,879 loops=1)

71. 0.021 0.073 ↑ 1.0 29 1

Hash (cost=1.29..1.29 rows=29 width=32) (actual time=0.073..0.073 rows=29 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
72. 0.052 0.052 ↑ 1.0 29 1

Seq Scan on measurementnature (cost=0.00..1.29 rows=29 width=32) (actual time=0.036..0.052 rows=29 loops=1)

73. 4.940 13.551 ↓ 1.0 8,497 1

Hash (cost=198.94..198.94 rows=8,494 width=12) (actual time=13.551..13.551 rows=8,497 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 494kB
74. 8.611 8.611 ↓ 1.0 8,497 1

Seq Scan on deliverypointcomponent (cost=0.00..198.94 rows=8,494 width=12) (actual time=0.017..8.611 rows=8,497 loops=1)

  • Filter: (deleted IS FALSE)
75. 0.007 0.697 ↑ 1.0 11 1

Hash (cost=1.62..1.62 rows=11 width=64) (actual time=0.697..0.697 rows=11 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
76. 0.031 0.690 ↑ 1.0 11 1

Hash Left Join (cost=0.36..1.62 rows=11 width=64) (actual time=0.669..0.690 rows=11 loops=1)

  • Hash Cond: ((componentnature.componentnature)::text = (country.componentnature)::text)
77. 0.035 0.035 ↑ 1.0 11 1

Seq Scan on componentnature (cost=0.00..1.11 rows=11 width=32) (actual time=0.033..0.035 rows=11 loops=1)

78. 0.011 0.624 ↑ 1.0 11 1

Hash (cost=0.22..0.22 rows=11 width=64) (actual time=0.624..0.624 rows=11 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
79. 0.613 0.613 ↑ 1.0 11 1

CTE Scan on componentnature country (cost=0.00..0.22 rows=11 width=64) (actual time=0.560..0.613 rows=11 loops=1)

80. 10.879 10.879 ↓ 0.0 0 10,879

Index Scan using logicalregister_pk on logicalregister (cost=0.29..0.33 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=10,879)

  • Index Cond: (c.logicalregisterid = logicalregisterid)
  • Filter: (ignored IS FALSE)
81. 5.212 14.529 ↓ 1.0 8,497 1

Hash (cost=239.94..239.94 rows=8,494 width=26) (actual time=14.529..14.529 rows=8,497 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 626kB
82. 9.317 9.317 ↓ 1.0 8,497 1

Seq Scan on deliverypoint (cost=0.00..239.94 rows=8,494 width=26) (actual time=0.014..9.317 rows=8,497 loops=1)

  • Filter: (deleted IS FALSE)
83. 10.904 44.801 ↓ 1.0 16,841 1

Hash (cost=588.92..588.92 rows=16,838 width=43) (actual time=44.801..44.801 rows=16,841 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1250kB
84. 33.897 33.897 ↓ 1.0 16,841 1

Seq Scan on generalconfig (cost=0.00..588.92 rows=16,838 width=43) (actual time=0.306..33.897 rows=16,841 loops=1)

  • Filter: ((deleted IS FALSE) AND ((direction)::text = 'CONSUMPTION'::text))
  • Rows Removed by Filter: 196
85.          

SubPlan (for Hash Join)

86. 8,568.335 8,568.335 ↑ 1.0 1 23,735

Result (cost=0.00..0.27 rows=1 width=4) (actual time=0.361..0.361 rows=1 loops=23,735)

87. 3.708 10.617 ↑ 1.0 7,163 1

Hash (cost=215.63..215.63 rows=7,163 width=17) (actual time=10.617..10.617 rows=7,163 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 400kB
88. 6.909 6.909 ↑ 1.0 7,163 1

Seq Scan on customer cu (cost=0.00..215.63 rows=7,163 width=17) (actual time=0.219..6.909 rows=7,163 loops=1)

89. 3.447 8.537 ↑ 1.0 7,163 1

Hash (cost=155.63..155.63 rows=7,163 width=8) (actual time=8.537..8.537 rows=7,163 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 344kB
90. 5.090 5.090 ↑ 1.0 7,163 1

Seq Scan on crmdata crm (cost=0.00..155.63 rows=7,163 width=8) (actual time=0.027..5.090 rows=7,163 loops=1)

91. 0.000 67.068 ↑ 1.0 1 11,178

Index Scan using "Key4" on contracthistory ch (cost=2.00..2.04 rows=1 width=12) (actual time=0.006..0.006 rows=1 loops=11,178)

  • Index Cond: ((contractid = co.contractid) AND (contracthistentry = (SubPlan 6)))
92.          

SubPlan (for Index Scan)

93. 0.000 122.958 ↑ 1.0 1 11,178

Limit (cost=1.70..1.71 rows=1 width=4) (actual time=0.011..0.011 rows=1 loops=11,178)

94.          

Initplan (for Limit)

95. 11.178 100.602 ↑ 1.0 1 11,178

Limit (cost=0.29..1.70 rows=1 width=4) (actual time=0.009..0.009 rows=1 loops=11,178)

96. 89.424 89.424 ↑ 2.0 1 11,178

Index Only Scan Backward using "Key4" on contracthistory ch2 (cost=0.29..3.11 rows=2 width=4) (actual time=0.008..0.008 rows=1 loops=11,178)

  • Index Cond: ((contractid = co.contractid) AND (contracthistentry IS NOT NULL))
  • Heap Fetches: 11178
97. 122.958 122.958 ↑ 1.0 1 11,178

Result (cost=1.70..1.71 rows=1 width=4) (actual time=0.011..0.011 rows=1 loops=11,178)

98. 0.042 0.082 ↑ 1.0 72 1

Hash (cost=2.72..2.72 rows=72 width=20) (actual time=0.082..0.082 rows=72 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
99. 0.040 0.040 ↑ 1.0 72 1

Seq Scan on actor dgo_actor (cost=0.00..2.72 rows=72 width=20) (actual time=0.011..0.040 rows=72 loops=1)

Planning time : 39.557 ms
Execution time : 10,471.782 ms