explain.depesz.com

PostgreSQL's explain analyze made readable

Result: p6Xy

Settings
# exclusive inclusive rows x rows loops node
1. 22.018 10,448.605 ↑ 2.2 11,178 1

Hash Left Join (cost=85,232.45..119,574.22 rows=24,397 width=178) (actual time=1,775.775..10,448.605 rows=11,178 loops=1)

  • Hash Cond: (deliverypoint.deliverypointid = dp.deliverypointid)
2.          

Initplan (for Hash Left Join)

3. 0.065 0.065 ↑ 1.0 1 1

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

  • Index Cond: ((propertycode)::text = 'defaultCountryCode'::text)
4. 18.660 9,411.476 ↑ 2.2 11,178 1

Hash Left Join (cost=44,159.02..78,165.34 rows=24,397 width=154) (actual time=760.633..9,411.476 rows=11,178 loops=1)

  • Hash Cond: (co.customerid = cu.customerid)
5. 55.513 9,367.693 ↑ 2.2 11,178 1

Hash Join (cost=43,510.20..77,181.05 rows=24,397 width=141) (actual time=735.486..9,367.693 rows=11,178 loops=1)

  • Hash Cond: ((SubPlan 2) = generalconfig.generalconfigid)
6. 0.000 872.915 ↑ 2.0 12,557 1

Hash Right Join (cost=42,710.80..72,774.90 rows=24,681 width=106) (actual time=697.501..872.915 rows=12,557 loops=1)

  • Hash Cond: ((ch.contractid = co.contractid) AND (ch.contracthistentry = (SubPlan 4)))
7. 7.285 7.285 ↓ 1.0 17,246 1

Seq Scan on contracthistory ch (cost=0.00..388.43 rows=17,243 width=12) (actual time=0.018..7.285 rows=17,246 loops=1)

8. 150.622 697.372 ↑ 2.0 12,557 1

Hash (cost=42,340.58..42,340.58 rows=24,681 width=106) (actual time=697.372..697.372 rows=12,557 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 1,650kB
9. 17.268 546.750 ↑ 2.0 12,557 1

Hash Left Join (cost=3,039.01..42,340.58 rows=24,681 width=106) (actual time=123.552..546.750 rows=12,557 loops=1)

  • Hash Cond: (deliveryperiod.deliveryperiodid = cdp.deliveryperiodid)
10. 16.912 487.266 ↑ 1.9 10,879 1

Hash Left Join (cost=2,099.57..40,895.01 rows=20,746 width=78) (actual time=81.299..487.266 rows=10,879 loops=1)

  • Hash Cond: ((deliverypointcomponent.deliverypointcomponentid = deliveryperiod.deliverypointcomponentid) AND (consumption.deliveryperiodid = deliveryperiod.deliveryperiodid))
11. 15.701 456.199 ↑ 1.9 10,879 1

Hash Left Join (cost=1,731.27..40,371.09 rows=20,746 width=82) (actual time=67.102..456.199 rows=10,879 loops=1)

  • Hash Cond: ((deliverypointcomponent.componentnature)::text = (componentnature.componentnature)::text)
12. 13.685 439.989 ↑ 1.9 10,879 1

Hash Left Join (cost=1,721.10..40,075.65 rows=20,746 width=74) (actual time=66.580..439.989 rows=10,879 loops=1)

  • Hash Cond: (consumption.deliverypointcomponentid = deliverypointcomponent.deliverypointcomponentid)
13. 15.761 413.403 ↑ 1.9 10,879 1

Hash Join (cost=1,415.98..39,485.28 rows=20,746 width=66) (actual time=53.640..413.403 rows=10,879 loops=1)

  • Hash Cond: ((consumptiondetail.measurementnature)::text = (measurementnature.nature)::text)
14. 6.884 397.579 ↑ 1.9 10,879 1

Hash Left Join (cost=1,414.33..39,198.37 rows=20,746 width=83) (actual time=53.559..397.579 rows=10,879 loops=1)

  • Hash Cond: (consumptiondetail.logicalregisterid = logicalregister.logicalregisterid)
15. 13.961 349.843 ↑ 1.9 10,879 1

Nested Loop (cost=346.54..38,052.39 rows=20,746 width=55) (actual time=12.656..349.843 rows=10,879 loops=1)

16. 9.548 193.313 ↑ 1.4 6,789 1

Hash Left Join (cost=346.12..5,663.55 rows=9,358 width=38) (actual time=12.631..193.313 rows=6,789 loops=1)

  • Hash Cond: (consumption.deliverypointid = deliverypoint.deliverypointid)
17. 171.196 171.196 ↑ 1.4 6,789 1

Seq Scan on consumption (cost=0.00..5,188.76 rows=9,358 width=35) (actual time=0.027..171.196 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: 106,949
18. 5.123 12.569 ↓ 1.0 8,497 1

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

  • Buckets: 16,384 Batches: 1 Memory Usage: 626kB
19. 7.446 7.446 ↓ 1.0 8,497 1

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

  • Filter: (deleted IS FALSE)
20. 142.569 142.569 ↑ 1.5 2 6,789

Index Scan using "IX_consumptiondetail_consumptionid_consumptiondetail" on consumptiondetail (cost=0.42..3.43 rows=3 width=25) (actual time=0.015..0.021 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
21. 14.149 40.852 ↑ 1.0 25,324 1

Hash (cost=751.24..751.24 rows=25,324 width=36) (actual time=40.852..40.852 rows=25,324 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 1,147kB
22. 26.703 26.703 ↑ 1.0 25,324 1

Seq Scan on logicalregister (cost=0.00..751.24 rows=25,324 width=36) (actual time=0.017..26.703 rows=25,324 loops=1)

  • Filter: (ignored IS FALSE)
23. 0.024 0.063 ↑ 1.0 29 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
24. 0.039 0.039 ↑ 1.0 29 1

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

25. 4.903 12.901 ↓ 1.0 8,497 1

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

  • Buckets: 16,384 Batches: 1 Memory Usage: 494kB
26. 7.998 7.998 ↓ 1.0 8,497 1

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

  • Filter: (deleted IS FALSE)
27. 0.009 0.509 ↑ 1.0 11 1

Hash (cost=10.04..10.04 rows=11 width=48) (actual time=0.509..0.509 rows=11 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
28. 0.020 0.500 ↑ 1.0 11 1

Hash Left Join (cost=3.97..10.04 rows=11 width=48) (actual time=0.460..0.500 rows=11 loops=1)

  • Hash Cond: ((componentnature.componentnature)::text = (codetranslation.code)::text)
29. 0.046 0.460 ↑ 1.0 11 1

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

  • Hash Cond: ((codetranslation_1.code)::text = (componentnature.componentnature)::text)
30. 0.374 0.374 ↓ 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.366..0.374 rows=11 loops=1)

  • Index Cond: (((category)::text = 'componentnature'::text) AND ((countrycode)::text = ($0)::text))
31. 0.011 0.040 ↑ 1.0 11 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
32. 0.029 0.029 ↑ 1.0 11 1

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

33. 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: 1,024 Batches: 1 Memory Usage: 8kB
34. 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))
35. 6.078 14.155 ↑ 1.0 8,873 1

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

  • Buckets: 16,384 Batches: 1 Memory Usage: 475kB
36. 8.077 8.077 ↑ 1.0 8,873 1

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

  • Filter: (deleted IS FALSE)
37. 7.354 42.216 ↓ 1.0 10,629 1

Hash (cost=806.62..806.62 rows=10,626 width=36) (actual time=42.215..42.216 rows=10,629 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 836kB
38. 14.588 34.862 ↓ 1.0 10,629 1

Hash Left Join (cost=410.25..806.62 rows=10,626 width=36) (actual time=15.964..34.862 rows=10,629 loops=1)

  • Hash Cond: (cdp.contractid = co.contractid)
39. 4.362 4.362 ↓ 1.0 10,629 1

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

40. 6.629 15.912 ↓ 1.0 10,414 1

Hash (cost=280.11..280.11 rows=10,411 width=28) (actual time=15.912..15.912 rows=10,414 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 739kB
41. 9.283 9.283 ↓ 1.0 10,414 1

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

42.          

SubPlan (for Hash Right Join)

43. 0.000 242.690 ↑ 1.0 1 24,269

Limit (cost=1.70..1.71 rows=1 width=4) (actual time=0.009..0.010 rows=1 loops=24,269)

44.          

Initplan (for Limit)

45. 48.538 194.152 ↑ 1.0 1 24,269

Limit (cost=0.29..1.70 rows=1 width=4) (actual time=0.007..0.008 rows=1 loops=24,269)

46. 145.614 145.614 ↑ 2.0 1 24,269

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

  • Index Cond: ((contractid = co.contractid) AND (contracthistentry IS NOT NULL))
  • Heap Fetches: 23,424
47. 218.421 218.421 ↑ 1.0 1 24,269

Result (cost=1.70..1.71 rows=1 width=4) (actual time=0.009..0.009 rows=1 loops=24,269)

48. 10.543 37.075 ↓ 1.0 16,841 1

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

  • Buckets: 32,768 Batches: 1 Memory Usage: 1,250kB
49. 26.532 26.532 ↓ 1.0 16,841 1

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

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

SubPlan (for Hash Join)

51. 8,402.190 8,402.190 ↑ 1.0 1 23,735

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

52. 4.016 25.123 ↑ 1.0 7,163 1

Hash (cost=559.29..559.29 rows=7,163 width=21) (actual time=25.123..25.123 rows=7,163 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 428kB
53. 9.119 21.107 ↑ 1.0 7,163 1

Hash Left Join (cost=245.17..559.29 rows=7,163 width=21) (actual time=8.261..21.107 rows=7,163 loops=1)

  • Hash Cond: (cu.customerid = crm.customerid)
54. 3.780 3.780 ↑ 1.0 7,163 1

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

55. 3.470 8.208 ↑ 1.0 7,163 1

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

  • Buckets: 8,192 Batches: 1 Memory Usage: 344kB
56. 4.738 4.738 ↑ 1.0 7,163 1

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

57. 5.962 1,015.046 ↓ 1.0 8,498 1

Hash (cost=40,964.97..40,964.97 rows=8,494 width=20) (actual time=1,015.046..1,015.046 rows=8,498 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 543kB
58. 9.208 1,009.084 ↓ 1.0 8,498 1

Hash Left Join (cost=1,150.20..40,964.97 rows=8,494 width=20) (actual time=40.961..1,009.084 rows=8,498 loops=1)

  • Hash Cond: (actor_dgo.actorid = dgo_actor.actorid)
59. 15.053 999.797 ↓ 1.0 8,498 1

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

  • Hash Cond: (((deliveryperiodbrpjournal.brp)::text = (actor_brp.externalid)::text) AND ((dp.market)::text = (actor_brp.marketcode)::text))
60. 16.917 984.677 ↓ 1.0 8,497 1

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

  • Hash Cond: (((deliveryperiod_1.supplier)::text = (actor_sup.externalid)::text) AND ((dp.market)::text = (actor_sup.marketcode)::text))
61. 26.896 967.680 ↓ 1.0 8,497 1

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

  • Hash Cond: ((SubPlan 7) = deliveryperiodbrpjournal.deliveryperiodbrpjournalid)
62. 34.853 582.584 ↓ 1.0 8,497 1

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

  • Hash Cond: ((SubPlan 6) = deliveryperiod_1.deliveryperiodid)
63. 42.437 333.006 ↓ 1.0 8,497 1

Hash Left Join (cost=6.74..9,747.19 rows=8,494 width=11) (actual time=0.289..333.006 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 5))::text)
  • Rows Removed by Join Filter: 322
64. 10.566 17.113 ↓ 1.0 8,497 1

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

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

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

  • Filter: (deleted IS FALSE)
66. 0.005 0.061 ↑ 1.0 3 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
67. 0.056 0.056 ↑ 1.0 3 1

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

  • Filter: ((role)::text = 'RR'::text)
  • Rows Removed by Filter: 69
68. 0.051 0.129 ↑ 1.0 60 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 11kB
69. 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.023..0.078 rows=60 loops=1)

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

SubPlan (for Hash Left Join)

71. 273.327 273.327 ↑ 1.0 1 8,817

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

  • Filter: (gridoperatorid = actor_dgo.actorid)
  • Rows Removed by Filter: 57
72. 4.456 11.073 ↑ 1.0 8,873 1

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

  • Buckets: 16,384 Batches: 1 Memory Usage: 543kB
73. 6.617 6.617 ↑ 1.0 8,873 1

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

  • Filter: (deleted IS FALSE)
74.          

SubPlan (for Hash Left Join)

75. 16.971 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)

76. 67.884 186.681 ↑ 1.0 1 16,971

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

  • Sort Key: deliveryperiod_3.todate DESC
  • Sort Method: quicksort Memory: 25kB
77. 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)
78. 4.681 29.040 ↓ 1.0 8,776 1

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

  • Buckets: 16,384 Batches: 1 Memory Usage: 572kB
79. 10.417 24.359 ↓ 1.0 8,776 1

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

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

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

81. 4.168 10.784 ↑ 1.0 8,873 1

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

  • Buckets: 16,384 Batches: 1 Memory Usage: 440kB
82. 6.616 6.616 ↑ 1.0 8,873 1

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

  • Filter: (deleted IS FALSE)
83.          

SubPlan (for Hash Left Join)

84. 32.916 329.160 ↑ 1.0 1 16,458

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

85. 65.832 296.244 ↑ 1.0 1 16,458

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

  • Sort Key: deliveryperiodbrpjournal_1.todate DESC
  • Sort Method: quicksort Memory: 25kB
86. 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)

87. 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)
88. 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.006..0.006 rows=1 loops=16,764)

  • Index Cond: (deliveryperiodid = deliveryperiod_1.deliveryperiodid)
  • Filter: (deleted IS FALSE)
89. 0.005 0.080 ↑ 1.0 2 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
90. 0.075 0.075 ↑ 1.0 2 1

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

  • Filter: ((role)::text = 'S'::text)
  • Rows Removed by Filter: 70
91. 0.007 0.067 ↑ 1.0 6 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
92. 0.060 0.060 ↑ 1.0 6 1

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

  • Filter: ((role)::text = 'B'::text)
  • Rows Removed by Filter: 66
93. 0.033 0.079 ↑ 1.0 72 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 12kB
94. 0.046 0.046 ↑ 1.0 72 1

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

Planning time : 42.989 ms
Execution time : 10,451.989 ms