explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OmxN

Settings
# exclusive inclusive rows x rows loops node
1. 0.020 44,598.462 ↑ 1.1 132 1

Limit (cost=1,071,931.87..1,071,932.22 rows=140 width=232) (actual time=44,598.427..44,598.462 rows=132 loops=1)

2. 1.252 44,598.442 ↑ 1.1 132 1

Sort (cost=1,071,931.87..1,071,932.22 rows=140 width=232) (actual time=44,598.426..44,598.442 rows=132 loops=1)

  • Sort Key: deliverypoint.gsrn
  • Sort Method: quicksort Memory: 48kB
3. 0.979 44,597.190 ↑ 1.1 132 1

HashAggregate (cost=1,071,924.08..1,071,925.48 rows=140 width=82) (actual time=44,597.118..44,597.190 rows=132 loops=1)

  • Group Key: deliverypoint.gsrn, co.contractid, co.customerid, co.supplierref, cdp.contractdeliveryid, m.smartmeterstatus, m.metertype, (CASE WHEN (m.metertype IS NULL) THEN NULL::text WHEN (((m.metertype)::text = 'SMART_METER'::text) AND ((m.smartmeterstatus)::text = 'ACTIVE_READABLE'::text)) THEN 'SMART_METER'::text ELSE 'METERING_COMPANY'::text END), (to_date(((('2019-'::text || (date_part('month'::text, (co_1.supplierindexcollectiondate)::timestamp without time zone))::text) || '-'::text) || (date_part('day'::text, (co_1.supplierindexcollectiondate)::timestamp without time zone))::text), 'YYYY-MM-DD'::text)), (((to_date(((('2019-'::text || (date_part('month'::text, (co_1.supplierindexcollectiondate)::timestamp without time zone))::text) || '-'::text) || (date_part('day'::text, (co_1.supplierindexcollectiondate)::timestamp without time zone))::text), 'YYYY-MM-DD'::text)) + 6)), (((to_date(((('2019-'::text || (date_part('month'::text, (co_1.supplierindexcollectiondate)::timestamp without time zone))::text) || '-'::text) || (date_part('day'::text, (co_1.supplierindexcollectiondate)::timestamp without time zone))::text), 'YYYY-MM-DD'::text)) + 14)), ((SubPlan 8)), ((SubPlan 9)), ((SubPlan 10)), ((SubPlan 11))
4. 0.117 44,596.211 ↑ 1.1 132 1

Append (cost=53,428.97..1,071,918.83 rows=140 width=82) (actual time=3,152.288..44,596.211 rows=132 loops=1)

5. 0.000 20,583.154 ↓ 2.5 100 1

Limit (cost=53,428.97..159,183.33 rows=40 width=82) (actual time=3,152.286..20,583.154 rows=100 loops=1)

6.          

Initplan (for Limit)

7. 0.337 0.337 ↑ 1.0 1 1

Index Scan using parametervalue_valuecode_idx on parametervalue parametervalue_1 (cost=0.28..8.29 rows=1 width=4) (actual time=0.336..0.337 rows=1 loops=1)

  • Index Cond: ((valuecode)::text = 'NL.excludedFromConventionalMeteringRequest'::text)
  • Filter: ((parametercategorycode)::text = 'contractUserItemCode'::text)
8. 2.076 20,583.082 ↓ 2.5 100 1

Nested Loop Anti Join (cost=53,420.68..159,175.04 rows=40 width=82) (actual time=3,152.286..20,583.082 rows=100 loops=1)

  • Join Filter: (cw.effectivedate = (to_date(((('2019-'::text || (date_part('month'::text, (co_1.supplierindexcollectiondate)::timestamp without time zone))::text) || '-'::text) || (date_part('day'::text, (co_1.supplierindexcollectiondate)::timestamp without time zone))::text), 'YYYY-MM-DD'::text)))
  • Rows Removed by Join Filter: 126
9. 11.204 4,793.826 ↓ 2.5 102 1

Hash Join (cost=53,418.44..69,655.08 rows=40 width=82) (actual time=2,828.804..4,793.826 rows=102 loops=1)

  • Hash Cond: ((SubPlan 12) = m.meterid)
10. 3.286 3,622.629 ↓ 22.4 2,863 1

Nested Loop Anti Join (cost=28,796.95..39,115.87 rows=128 width=58) (actual time=1,814.467..3,622.629 rows=2,863 loops=1)

11. 6.027 3,095.414 ↓ 12.4 2,863 1

Nested Loop Left Join (cost=28,796.52..38,792.52 rows=230 width=58) (actual time=1,813.207..3,095.414 rows=2,863 loops=1)

  • Join Filter: ((physicalconfig.fromdate <= (to_date(((('2019-'::text || (date_part('month'::text, (co_1.supplierindexcollectiondate)::timestamp without time zone))::text) || '-'::text) || (date_part('day'::text, (co_1.supplierindexcollectiondate)::timestamp without time zone))::text), 'YYYY-MM-DD'::text))) AND ((physicalconfig.todate IS NULL) OR (physicalconfig.todate > (to_date(((('2019-'::text || (date_part('month'::text, (co_1.supplierindexcollectiondate)::timestamp without time zone))::text) || '-'::text) || (date_part('day'::text, (co_1.supplierindexcollectiondate)::timestamp without time zone))::text), 'YYYY-MM-DD'::text)))))
  • Rows Removed by Join Filter: 3014
12. 5.806 2,920.470 ↓ 12.4 2,863 1

Nested Loop (cost=28,796.10..38,644.12 rows=230 width=54) (actual time=1,811.437..2,920.470 rows=2,863 loops=1)

  • Join Filter: (co_1.contractid = co.contractid)
13. 10.604 2,800.144 ↓ 12.2 2,863 1

Nested Loop Left Join (cost=28,795.68..38,514.45 rows=235 width=43) (actual time=1,811.224..2,800.144 rows=2,863 loops=1)

  • Join Filter: ((generalconfig.fromdate <= (to_date(((('2019-'::text || (date_part('month'::text, (co_1.supplierindexcollectiondate)::timestamp without time zone))::text) || '-'::text) || (date_part('day'::text, (co_1.supplierindexcollectiondate)::timestamp without time zone))::text), 'YYYY-MM-DD'::text))) AND ((generalconfig.todate IS NULL) OR (generalconfig.todate > (to_date(((('2019-'::text || (date_part('month'::text, (co_1.supplierindexcollectiondate)::timestamp without time zone))::text) || '-'::text) || (date_part('day'::text, (co_1.supplierindexcollectiondate)::timestamp without time zone))::text), 'YYYY-MM-DD'::text)))) AND (generalconfig.deliverypointid = deliverypoint.deliverypointid))
  • Rows Removed by Join Filter: 4135
  • Filter: (((generalconfig.category IS NULL) OR ((generalconfig.category)::text = 'SMALL_CAPACITY'::text)) AND ((generalconfig.readingfrequency IS NULL) OR ((generalconfig.readingfrequency)::text <> 'NOT_MEASURED'::text)) AND ((generalconfig.state IS NULL) OR ((generalconfig.state)::text = 'IN_USE'::text)))
  • Rows Removed by Filter: 465
14. 5.027 2,393.508 ↓ 10.4 3,328 1

Nested Loop (cost=28,795.26..38,162.05 rows=320 width=43) (actual time=1,810.799..2,393.508 rows=3,328 loops=1)

15. 5.434 2,291.969 ↓ 10.4 3,328 1

Nested Loop (cost=28,794.84..37,993.98 rows=320 width=43) (actual time=1,810.436..2,291.969 rows=3,328 loops=1)

16. 4.435 2,170.055 ↓ 10.4 3,328 1

Nested Loop (cost=28,794.42..37,819.07 rows=320 width=24) (actual time=1,810.248..2,170.055 rows=3,328 loops=1)

17. 6.506 2,035.828 ↓ 10.4 3,328 1

Nested Loop (cost=28,794.00..37,641.10 rows=320 width=20) (actual time=1,809.838..2,035.828 rows=3,328 loops=1)

18. 31.124 1,814.172 ↓ 5.4 8,275 1

HashAggregate (cost=28,793.58..28,808.82 rows=1,524 width=8) (actual time=1,808.517..1,814.172 rows=8,275 loops=1)

  • Group Key: co_1.contractid, (to_date(((('2019-'::text || (date_part('month'::text, (co_1.supplierindexcollectiondate)::timestamp without time zone))::text) || '-'::text) || (date_part('day'::text, (co_1.supplierindexcollectiondate)::timestamp without time zone))::text), 'YYYY-MM-DD'::text))
19. 5.356 1,783.048 ↓ 20.0 30,543 1

Append (cost=0.00..28,785.96 rows=1,524 width=8) (actual time=2.242..1,783.048 rows=30,543 loops=1)

20. 772.182 772.182 ↓ 1.0 782 1

Seq Scan on contract co_1 (cost=0.00..14,385.36 rows=762 width=8) (actual time=2.241..772.182 rows=782 loops=1)

  • Filter: ((supplierindexcollectiondate IS NOT NULL) AND (to_date(((('2019-'::text || (date_part('month'::text, (supplierindexcollectiondate)::timestamp without time zone))::text) || '-'::text) || (date_part('day'::text, (supplierindexcollectiondate)::timestamp without time zone))::text), 'YYYY-MM-DD'::text) >= '2019-12-24'::date) AND (to_date(((('2019-'::text || (date_part('month'::text, (supplierindexcollectiondate)::timestamp without time zone))::text) || '-'::text) || (date_part('day'::text, (supplierindexcollectiondate)::timestamp without time zone))::text), 'YYYY-MM-DD'::text) < '2020-01-13'::date))
  • Rows Removed by Filter: 152263
21. 1,005.510 1,005.510 ↓ 39.1 29,761 1

Seq Scan on contract co_2 (cost=0.00..14,385.36 rows=762 width=8) (actual time=0.089..1,005.510 rows=29,761 loops=1)

  • Filter: ((supplierindexcollectiondate IS NOT NULL) AND (to_date(((('2020-'::text || (date_part('month'::text, (supplierindexcollectiondate)::timestamp without time zone))::text) || '-'::text) || (date_part('day'::text, (supplierindexcollectiondate)::timestamp without time zone))::text), 'YYYY-MM-DD'::text) >= '2019-12-24'::date) AND (to_date(((('2020-'::text || (date_part('month'::text, (supplierindexcollectiondate)::timestamp without time zone))::text) || '-'::text) || (date_part('day'::text, (supplierindexcollectiondate)::timestamp without time zone))::text), 'YYYY-MM-DD'::text) < '2020-01-13'::date))
  • Rows Removed by Filter: 123284
22. 215.150 215.150 ↓ 0.0 0 8,275

Index Scan using contractdelively_contract_id_idx on contractdelivery cdp (cost=0.42..5.78 rows=1 width=20) (actual time=0.026..0.026 rows=0 loops=8,275)

  • Index Cond: (contractid = co_1.contractid)
  • Filter: ((fromdate <= (to_date(((('2019-'::text || (date_part('month'::text, (co_1.supplierindexcollectiondate)::timestamp without time zone))::text) || '-'::text) || (date_part('day'::text, (co_1.supplierindexcollectiondate)::timestamp without time zone))::text), 'YYYY-MM-DD'::text))) AND ((todate IS NULL) OR (todate > (to_date(((('2019-'::text || (date_part('month'::text, (co_1.supplierindexcollectiondate)::timestamp without time zone))::text) || '-'::text) || (date_part('day'::text, (co_1.supplierindexcollectiondate)::timestamp without time zone))::text), 'YYYY-MM-DD'::text)))) AND (fromdate <> (to_date(((('2019-'::text || (date_part('month'::text, (co_1.supplierindexcollectiondate)::timestamp without time zone))::text) || '-'::text) || (date_part('day'::text, (co_1.supplierindexcollectiondate)::timestamp without time zone))::text), 'YYYY-MM-DD'::text))) AND ((todate IS NULL) OR (todate <> (to_date(((('2019-'::text || (date_part('month'::text, (co_1.supplierindexcollectiondate)::timestamp without time zone))::text) || '-'::text) || (date_part('day'::text, (co_1.supplierindexcollectiondate)::timestamp without time zone))::text), 'YYYY-MM-DD'::text)))))
  • Rows Removed by Filter: 1
23. 129.792 129.792 ↑ 1.0 1 3,328

Index Scan using deliveryperiod_pkey on deliveryperiod deliveryperiod_1 (cost=0.42..0.55 rows=1 width=12) (actual time=0.038..0.039 rows=1 loops=3,328)

  • Index Cond: (deliveryperiodid = cdp.deliveryperiodid)
  • Filter: (deleted IS FALSE)
24. 116.480 116.480 ↑ 1.0 1 3,328

Index Scan using deliverypoint_pkey on deliverypoint (cost=0.42..0.54 rows=1 width=23) (actual time=0.035..0.035 rows=1 loops=3,328)

  • Index Cond: (deliverypointid = deliveryperiod_1.deliverypointid)
  • Filter: (deleted IS FALSE)
25. 96.512 96.512 ↑ 1.0 1 3,328

Index Scan using deliverypointcomponent_pk on deliverypointcomponent (cost=0.42..0.52 rows=1 width=4) (actual time=0.029..0.029 rows=1 loops=3,328)

  • Index Cond: (deliverypointcomponentid = deliveryperiod_1.deliverypointcomponentid)
  • Filter: (deleted IS FALSE)
26. 396.032 396.032 ↑ 1.0 2 3,328

Index Scan using generalconfig_deliverypointcomponentid_idx on generalconfig (cost=0.42..1.05 rows=2 width=42) (actual time=0.061..0.119 rows=2 loops=3,328)

  • Index Cond: (deliverypointcomponentid = deliverypointcomponent.deliverypointcomponentid)
  • Filter: ((deleted IS FALSE) AND ((sourceid)::text = 'DGO'::text))
  • Rows Removed by Filter: 1
27. 114.520 114.520 ↑ 1.0 1 2,863

Index Scan using contract_pkey on contract co (cost=0.42..0.54 rows=1 width=19) (actual time=0.039..0.040 rows=1 loops=2,863)

  • Index Cond: (contractid = cdp.contractid)
28. 168.917 168.917 ↓ 2.0 2 2,863

Index Scan using physicalconfigid on physicalconfig (cost=0.42..0.63 rows=1 width=20) (actual time=0.036..0.059 rows=2 loops=2,863)

  • Index Cond: ((deliverypointid = deliverypoint.deliverypointid) AND (deliverypointcomponentid = deliverypointcomponent.deliverypointcomponentid))
  • Filter: ((deleted IS FALSE) AND ((sourceid)::text = 'DGO'::text))
29. 523.929 523.929 ↓ 0.0 0 2,863

Index Scan using idx_contractuserfields_contractid_pk on contractuserfields cuf (cost=0.43..1.40 rows=1 width=4) (actual time=0.183..0.183 rows=0 loops=2,863)

  • Index Cond: (contractid = co.contractid)
  • Filter: (useritemcodeparamid = $56)
  • Rows Removed by Filter: 14
30. 83.796 973.198 ↓ 2.0 147,573 1

Hash (cost=23,193.56..23,193.56 rows=73,834 width=32) (actual time=973.198..973.198 rows=147,573 loops=1)

  • Buckets: 2048 Batches: 16 (originally 8) Memory Usage: 1025kB
31. 313.842 889.402 ↓ 2.0 147,573 1

Hash Join (cost=9,552.00..23,193.56 rows=73,834 width=32) (actual time=335.163..889.402 rows=147,573 loops=1)

  • Hash Cond: (physicalconfig_1.physicalconfigid = m.physicalconfigid)
32. 241.764 241.764 ↑ 1.0 259,073 1

Seq Scan on physicalconfig physicalconfig_1 (cost=0.00..8,031.65 rows=259,265 width=4) (actual time=0.019..241.764 rows=259,073 loops=1)

  • Filter: (deleted IS FALSE)
  • Rows Removed by Filter: 1
33. 88.109 333.796 ↓ 2.0 147,573 1

Hash (cost=8,052.08..8,052.08 rows=73,834 width=36) (actual time=333.796..333.796 rows=147,573 loops=1)

  • Buckets: 2048 Batches: 16 (originally 8) Memory Usage: 1025kB
34. 245.687 245.687 ↓ 2.0 147,573 1

Seq Scan on meter m (cost=0.00..8,052.08 rows=73,834 width=36) (actual time=0.008..245.687 rows=147,573 loops=1)

  • Filter: (((metertype)::text = 'SMART_METER'::text) AND ((smartmeterstatus)::text = 'ACTIVE_READABLE'::text))
  • Rows Removed by Filter: 111501
35.          

SubPlan (for Hash Join)

36. 8.895 186.795 ↑ 1.0 1 2,965

Aggregate (cost=16.89..16.90 rows=1 width=4) (actual time=0.062..0.063 rows=1 loops=2,965)

37. 5.930 177.900 ↑ 1.0 1 2,965

Nested Loop (cost=0.84..16.89 rows=1 width=4) (actual time=0.059..0.060 rows=1 loops=2,965)

38. 124.530 124.530 ↑ 1.0 1 2,965

Index Scan using meter_physicalconfigid_idx on meter m_3 (cost=0.42..8.44 rows=1 width=8) (actual time=0.042..0.042 rows=1 loops=2,965)

  • Index Cond: (physicalconfigid = physicalconfig.physicalconfigid)
39. 47.440 47.440 ↑ 1.0 1 2,965

Index Scan using physicalconfig_pk on physicalconfig physicalconfig_5 (cost=0.42..8.44 rows=1 width=4) (actual time=0.016..0.016 rows=1 loops=2,965)

  • Index Cond: (physicalconfigid = physicalconfig.physicalconfigid)
  • Filter: (deleted IS FALSE)
40. 0.558 208.080 ↑ 1.0 1 102

Nested Loop (cost=2.24..6.01 rows=1 width=23) (actual time=1.492..2.040 rows=1 loops=102)

41. 1.109 206.244 ↓ 2.0 2 102

Nested Loop (cost=1.96..5.70 rows=1 width=27) (actual time=1.168..2.022 rows=2 loops=102)

42. 1.281 196.350 ↓ 2.1 17 102

Nested Loop (cost=1.69..3.24 rows=8 width=31) (actual time=0.514..1.925 rows=17 loops=102)

43. 0.345 32.844 ↑ 1.0 1 102

Nested Loop (cost=1.26..1.67 rows=1 width=23) (actual time=0.315..0.322 rows=1 loops=102)

44. 0.510 26.724 ↑ 1.0 1 102

Nested Loop (cost=0.84..1.11 rows=1 width=23) (actual time=0.260..0.262 rows=1 loops=102)

45. 18.564 18.564 ↑ 1.0 1 102

Index Scan using deliverypoint_gsrn_idx on deliverypoint dp_w (cost=0.42..0.55 rows=1 width=23) (actual time=0.182..0.182 rows=1 loops=102)

  • Index Cond: ((gsrn)::text = (deliverypoint.gsrn)::text)
46. 7.650 7.650 ↑ 1.0 1 102

Index Scan using "IX_deliveryperiod_deliverypointid_deliveryperiod" on deliveryperiod (cost=0.42..0.55 rows=1 width=8) (actual time=0.074..0.075 rows=1 loops=102)

  • Index Cond: (deliverypointid = dp_w.deliverypointid)
47. 5.775 5.775 ↑ 1.0 1 105

Index Scan using contractdelivery_deliveryperiodid_idx on contractdelivery cdp_1 (cost=0.42..0.55 rows=1 width=8) (actual time=0.055..0.055 rows=1 loops=105)

  • Index Cond: (deliveryperiodid = deliveryperiod.deliveryperiodid)
48. 162.225 162.225 ↓ 1.1 17 105

Index Scan using crmworkflow_contractdeliveryid_idx on crmworkflow cw (cost=0.43..1.42 rows=15 width=16) (actual time=0.194..1.545 rows=17 loops=105)

  • Index Cond: (contractdeliveryid = cdp_1.contractdeliveryid)
49. 8.785 8.785 ↓ 0.0 0 1,757

Index Scan using parametervalueid on parametervalue pv_t (cost=0.28..0.30 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=1,757)

  • Index Cond: (parametervalueid = cw.crmworkflowtypeparamid)
  • Filter: ((valuecode)::text = 'NL_indexCollectionKV'::text)
  • Rows Removed by Filter: 1
50. 1.278 1.278 ↑ 1.0 1 213

Index Scan using parametervalueid on parametervalue pv_s (cost=0.28..0.30 rows=1 width=4) (actual time=0.006..0.006 rows=1 loops=213)

  • Index Cond: (parametervalueid = cw.crmworkflowstatusparamid)
  • Filter: ((internalparametervaluecode)::text = ANY ('{RUNNING,SUCCESS}'::text[]))
  • Rows Removed by Filter: 0
51.          

SubPlan (for Nested Loop Anti Join)

52. 0.300 50.800 ↑ 1.0 1 100

Aggregate (cost=496.75..496.76 rows=1 width=0) (actual time=0.508..0.508 rows=1 loops=100)

53. 0.200 50.500 ↓ 0.0 0 100

Nested Loop (cost=1.67..496.75 rows=1 width=0) (actual time=0.505..0.505 rows=0 loops=100)

54. 0.300 50.300 ↓ 0.0 0 100

Nested Loop (cost=1.40..496.44 rows=1 width=4) (actual time=0.503..0.503 rows=0 loops=100)

  • Join Filter: (cw_6.crmworkflowtypeparamid = pv_t_6.parametervalueid)
  • Rows Removed by Join Filter: 1
55. 2.500 2.500 ↑ 1.0 1 100

Index Scan using parametervalue_valuecode_idx on parametervalue pv_t_6 (cost=0.28..8.29 rows=1 width=4) (actual time=0.025..0.025 rows=1 loops=100)

  • Index Cond: ((valuecode)::text = 'NL_indexCollectionKV'::text)
56. 1.881 47.500 ↑ 39.0 1 100

Nested Loop (cost=1.12..487.66 rows=39 width=8) (actual time=0.433..0.475 rows=1 loops=100)

57. 42.000 42.000 ↑ 39.0 1 100

Index Scan using crmworkflowdata_key_value_idx on crmworkflowdata cwd_3 (cost=0.69..157.82 rows=39 width=4) (actual time=0.380..0.420 rows=1 loops=100)

  • Index Cond: (((key)::text = 'BUSINESS_KEY'::text) AND (value = (((deliverypoint.gsrn)::text || '_'::text) || to_char(((to_date(((('2019-'::text || (date_part('month'::text, (co_1.supplierindexcollectiondate)::timestamp without time zone))::text) || '-'::text) || (date_part('day'::text, (co_1.supplierindexcollectiondate)::timestamp without time zone))::text), 'YYYY-MM-DD'::text)))::timestamp with time zone, 'YYYYMMDD'::text))))
58. 3.619 3.619 ↑ 1.0 1 77

Index Scan using crmworkflow_pkey on crmworkflow cw_6 (cost=0.43..8.45 rows=1 width=12) (actual time=0.044..0.047 rows=1 loops=77)

  • Index Cond: (crmworkflowid = cwd_3.crmworkflowid)
59. 0.000 0.000 ↓ 0.0 0

Index Scan using parametervalueid on parametervalue pv_s_6 (cost=0.28..0.30 rows=1 width=4) (never executed)

  • Index Cond: (parametervalueid = cw_6.crmworkflowstatusparamid)
  • Filter: ((internalparametervaluecode)::text = 'ERROR'::text)
60. 0.100 15,293.000 ↓ 0.0 0 100

Limit (cost=9.69..1,213.06 rows=1 width=4) (actual time=152.930..152.930 rows=0 loops=100)

61. 73.461 15,292.900 ↓ 0.0 0 100

Nested Loop (cost=9.69..1,213.06 rows=1 width=4) (actual time=152.929..152.929 rows=0 loops=100)

62. 111.300 13,079.500 ↓ 2,378.0 2,378 100

Nested Loop (cost=9.01..1,205.28 rows=1 width=4) (actual time=0.105..130.795 rows=2,378 loops=100)

63. 1,110.196 12,253.000 ↓ 397.3 2,384 100

Hash Join (cost=8.74..1,203.28 rows=6 width=8) (actual time=0.097..122.530 rows=2,384 loops=100)

  • Hash Cond: (cw_7.crmworkflowstatusparamid = pv_s_7.parametervalueid)
64. 11,142.700 11,142.700 ↓ 8.4 50,751 100

Index Scan using crmworkflow_effectivedate_idx on crmworkflow cw_7 (cost=0.43..1,172.23 rows=6,049 width=12) (actual time=0.035..111.427 rows=50,751 loops=100)

  • Index Cond: ((effectivedate >= ((to_date(((('2019-'::text || (date_part('month'::text, (co_1.supplierindexcollectiondate)::timestamp without time zone))::text) || '-'::text) || (date_part('day'::text, (co_1.supplierindexcollectiondate)::timestamp without time zone))::text), 'YYYY-MM-DD'::text)) - 5)) AND (effectivedate <= ((to_date(((('2019-'::text || (date_part('month'::text, (co_1.supplierindexcollectiondate)::timestamp without time zone))::text) || '-'::text) || (date_part('day'::text, (co_1.supplierindexcollectiondate)::timestamp without time zone))::text), 'YYYY-MM-DD'::text)) + 5)))
65. 0.003 0.104 ↑ 1.0 1 1

Hash (cost=8.29..8.29 rows=1 width=4) (actual time=0.104..0.104 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
66. 0.101 0.101 ↑ 1.0 1 1

Index Scan using parametervalue_internalparametervaluecode_idx on parametervalue pv_s_7 (cost=0.28..8.29 rows=1 width=4) (actual time=0.100..0.101 rows=1 loops=1)

  • Index Cond: ((internalparametervaluecode)::text = 'RUNNING'::text)
67. 715.200 715.200 ↑ 1.0 1 238,400

Index Scan using parametervalueid on parametervalue pv_t_7 (cost=0.28..0.32 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=238,400)

  • Index Cond: (parametervalueid = cw_7.crmworkflowtypeparamid)
  • Filter: ((valuecode)::text = ANY ('{NL_indexCollectionKV,NL_VKOindex}'::text[]))
  • Rows Removed by Filter: 0
68. 2,139.939 2,139.939 ↓ 0.0 0 237,771

Index Only Scan using crmworkflowdata_crmworkflowid_key_value_idx on crmworkflowdata cwd_4 (cost=0.68..7.77 rows=1 width=4) (actual time=0.009..0.009 rows=0 loops=237,771)

  • Index Cond: ((crmworkflowid = cw_7.crmworkflowid) AND (key = 'BUSINESS_KEY'::text))
  • Filter: (value ~~ ((deliverypoint.gsrn)::text || '_%'::text))
  • Rows Removed by Filter: 1
  • Heap Fetches: 238112
69. 0.200 215.500 ↓ 0.0 0 100

Limit (cost=27.36..66.48 rows=1 width=4) (actual time=2.155..2.155 rows=0 loops=100)

70. 0.280 215.300 ↓ 0.0 0 100

Nested Loop (cost=27.36..66.48 rows=1 width=4) (actual time=2.153..2.153 rows=0 loops=100)

71. 1.740 208.300 ↑ 1.0 1 100

Nested Loop Left Join (cost=26.93..30.99 rows=1 width=4) (actual time=2.083..2.083 rows=1 loops=100)

  • Filter: ((((index_1.sourceid)::text = 'USER'::text) AND ((i2_1.marketstatus)::text = ANY ('{SUBMITTED,ACCEPTED}'::text[]))) OR ((index_1.sourceid)::text <> 'USER'::text))
72. 151.200 191.600 ↑ 1.0 1 100

Bitmap Heap Scan on index index_1 (cost=10.01..14.04 rows=1 width=11) (actual time=1.915..1.916 rows=1 loops=100)

  • Recheck Cond: ((deliverypointcomponentid = deliverypointcomponent.deliverypointcomponentid) AND (deliverypointid = deliverypoint.deliverypointid))
  • Filter: ((deleted IS FALSE) AND ((status)::text = 'ACTUAL'::text) AND (todate >= ((to_date(((('2019-'::text || (date_part('month'::text, (co_1.supplierindexcollectiondate)::timestamp without time zone))::text) || '-'::text) || (date_part('day'::text, (co_1.supplierindexcollectiondate)::timestamp without time zone))::text), 'YYYY-MM-DD'::text)) - 5)) AND (todate <= ((to_date(((('2019-'::text || (date_part('month'::text, (co_1.supplierindexcollectiondate)::timestamp without time zone))::text) || '-'::text) || (date_part('day'::text, (co_1.supplierindexcollectiondate)::timestamp without time zone))::text), 'YYYY-MM-DD'::text)) + 5)))
  • Rows Removed by Filter: 20
  • Heap Blocks: exact=1926
73. 0.700 40.400 ↓ 0.0 0 100

BitmapAnd (cost=10.01..10.01 rows=1 width=0) (actual time=0.404..0.404 rows=0 loops=100)

74. 20.800 20.800 ↑ 2.9 21 100

Bitmap Index Scan on index_dpcomp_idx (cost=0.00..4.88 rows=60 width=0) (actual time=0.208..0.208 rows=21 loops=100)

  • Index Cond: (deliverypointcomponentid = deliverypointcomponent.deliverypointcomponentid)
75. 18.900 18.900 ↑ 2.9 21 100

Bitmap Index Scan on index_deliverypointid_idx (cost=0.00..4.88 rows=60 width=0) (actual time=0.189..0.189 rows=21 loops=100)

  • Index Cond: (deliverypointid = deliverypoint.deliverypointid)
76. 0.320 14.960 ↓ 0.0 0 80

Limit (cost=16.92..16.92 rows=1 width=156) (actual time=0.187..0.187 rows=0 loops=80)

77. 0.960 14.640 ↓ 0.0 0 80

Sort (cost=16.92..16.92 rows=1 width=156) (actual time=0.183..0.183 rows=0 loops=80)

  • Sort Key: (CASE WHEN ((i2_1.marketstatus)::text = 'ACCEPTED'::text) THEN 1 WHEN ((i2_1.marketstatus)::text = 'SUMBITTED'::text) THEN 2 WHEN ((i2_1.marketstatus)::text = 'REJECTED'::text) THEN 3 ELSE NULL::integer END)
  • Sort Method: quicksort Memory: 25kB
78. 0.160 13.680 ↓ 0.0 0 80

Nested Loop (cost=0.85..16.91 rows=1 width=156) (actual time=0.171..0.171 rows=0 loops=80)

79. 13.520 13.520 ↓ 0.0 0 80

Index Only Scan using indexrelation_pk on indexrelation ir_1 (cost=0.42..8.44 rows=1 width=4) (actual time=0.169..0.169 rows=0 loops=80)

  • Index Cond: (sourceindexid = index_1.indexid)
  • Heap Fetches: 0
80. 0.000 0.000 ↓ 0.0 0

Index Scan using index_pk on index i2_1 (cost=0.43..8.45 rows=1 width=156) (never executed)

  • Index Cond: (indexid = ir_1.targetindexid)
  • Filter: ((sourceid)::text = 'SUPPLIER'::text)
81. 6.720 6.720 ↓ 0.0 0 80

Index Scan using consumption_indexid_idx on consumption consumption_1 (cost=0.43..35.25 rows=25 width=4) (actual time=0.084..0.084 rows=0 loops=80)

  • Index Cond: (endindexid = index_1.indexid)
  • Filter: ((deleted IS FALSE) AND ((sourceid)::text = 'DGO'::text))
  • Rows Removed by Filter: 1
82. 0.200 19.800 ↓ 0.0 0 100

Limit (cost=455.57..455.57 rows=1 width=41) (actual time=0.198..0.198 rows=0 loops=100)

83. 0.500 19.600 ↓ 0.0 0 100

Sort (cost=455.57..455.57 rows=1 width=41) (actual time=0.196..0.196 rows=0 loops=100)

  • Sort Key: cw_8.crmworkflowid
  • Sort Method: quicksort Memory: 25kB
84. 0.200 19.100 ↓ 0.0 0 100

Nested Loop (cost=2.35..455.56 rows=1 width=41) (actual time=0.191..0.191 rows=0 loops=100)

85. 0.086 18.900 ↓ 0.0 0 100

Nested Loop (cost=2.08..455.25 rows=1 width=45) (actual time=0.189..0.189 rows=0 loops=100)

86. 0.124 18.800 ↓ 0.0 0 100

Nested Loop (cost=1.80..450.33 rows=16 width=49) (actual time=0.188..0.188 rows=0 loops=100)

  • Join Filter: (cwd_5.crmworkflowid = cw_8.crmworkflowid)
87. 1.737 18.600 ↓ 0.0 0 100

Nested Loop (cost=1.38..433.70 rows=16 width=45) (actual time=0.186..0.186 rows=0 loops=100)

88. 7.700 7.700 ↑ 39.0 1 100

Index Scan using crmworkflowdata_key_value_idx on crmworkflowdata cwd_5 (cost=0.69..157.82 rows=39 width=4) (actual time=0.072..0.077 rows=1 loops=100)

  • Index Cond: (((key)::text = 'BUSINESS_KEY'::text) AND (value = (((deliverypoint.gsrn)::text || '_'::text) || to_char(((to_date(((('2019-'::text || (date_part('month'::text, (co_1.supplierindexcollectiondate)::timestamp without time zone))::text) || '-'::text) || (date_part('day'::text, (co_1.supplierindexcollectiondate)::timestamp without time zone))::text), 'YYYY-MM-DD'::text)))::timestamp with time zone, 'YYYYMMDD'::text))))
89. 9.163 9.163 ↓ 0.0 0 77

Index Only Scan using crmworkflowdata_crmworkflowid_key_value_idx on crmworkflowdata cwd_err_1 (cost=0.68..7.06 rows=1 width=41) (actual time=0.119..0.119 rows=0 loops=77)

  • Index Cond: ((crmworkflowid = cwd_5.crmworkflowid) AND (key = 'ERROR_REASON'::text))
  • Heap Fetches: 2
90. 0.076 0.076 ↑ 1.0 1 2

Index Scan using crmworkflow_pkey on crmworkflow cw_8 (cost=0.43..1.03 rows=1 width=12) (actual time=0.032..0.038 rows=1 loops=2)

  • Index Cond: (crmworkflowid = cwd_err_1.crmworkflowid)
91. 0.014 0.014 ↓ 0.0 0 2

Index Scan using parametervalueid on parametervalue pv_t_8 (cost=0.28..0.30 rows=1 width=4) (actual time=0.007..0.007 rows=0 loops=2)

  • Index Cond: (parametervalueid = cw_8.crmworkflowtypeparamid)
  • Filter: ((valuecode)::text = 'NL_indexCollectionKV'::text)
  • Rows Removed by Filter: 1
92. 0.000 0.000 ↓ 0.0 0

Index Scan using parametervalueid on parametervalue pv_s_8 (cost=0.28..0.30 rows=1 width=4) (never executed)

  • Index Cond: (parametervalueid = cw_8.crmworkflowstatusparamid)
  • Filter: ((internalparametervaluecode)::text = 'ERROR'::text)
93. 0.000 24,012.940 ↑ 3.1 32 1

Limit (cost=224,617.47..912,734.10 rows=100 width=82) (actual time=22,476.990..24,012.940 rows=32 loops=1)

94.          

Initplan (for Limit)

95. 0.048 0.048 ↑ 1.0 1 1

Index Scan using parametervalue_valuecode_idx on parametervalue (cost=0.28..8.29 rows=1 width=4) (actual time=0.047..0.048 rows=1 loops=1)

  • Index Cond: ((valuecode)::text = 'NL.excludedFromConventionalMeteringRequest'::text)
  • Filter: ((parametercategorycode)::text = 'contractUserItemCode'::text)
96. 0.702 24,012.928 ↑ 5.5 32 1

Nested Loop Anti Join (cost=224,609.17..1,442,575.61 rows=177 width=82) (actual time=22,476.990..24,012.928 rows=32 loops=1)

  • Join Filter: (cw_1.effectivedate = (to_date(((('2019-'::text || (date_part('month'::text, (co_4.supplierindexcollectiondate)::timestamp without time zone))::text) || '-'::text) || (date_part('day'::text, (co_4.supplierindexcollectiondate)::timestamp without time zone))::text), 'YYYY-MM-DD'::text)))
  • Rows Removed by Join Filter: 52
97. 45.991 22,417.922 ↑ 5.5 32 1

Hash Join (cost=224,606.93..1,046,462.71 rows=177 width=82) (actual time=22,356.739..22,417.922 rows=32 loops=1)

  • Hash Cond: ((SubPlan 5) = m_1.meterid)
98. 215.466 21,748.188 ↑ 11.9 48 1

Hash Join (cost=199,985.45..997,278.78 rows=569 width=58) (actual time=5,235.411..21,748.188 rows=48 loops=1)

  • Hash Cond: ((SubPlan 7) = cw3.crmworkflowid)
99. 124.019 4,068.211 ↓ 4.4 111,428 1

Hash Anti Join (cost=160,070.27..202,521.04 rows=25,474 width=58) (actual time=2,661.674..4,068.211 rows=111,428 loops=1)

  • Hash Cond: (co_3.contractid = cuf_1.contractid)
100. 191.188 3,943.910 ↓ 2.4 111,428 1

Hash Join (cost=134,490.53..169,032.24 rows=45,953 width=58) (actual time=2,661.372..3,943.910 rows=111,428 loops=1)

  • Hash Cond: (co_4.contractid = co_3.contractid)
101. 541.583 3,652.774 ↓ 2.4 111,428 1

Hash Right Join (cost=127,264.58..159,202.64 rows=46,968 width=47) (actual time=2,557.536..3,652.774 rows=111,428 loops=1)

  • Hash Cond: ((generalconfig_1.deliverypointid = deliverypoint_1.deliverypointid) AND (generalconfig_1.deliverypointcomponentid = deliverypointcomponent_1.deliverypointcomponentid))
  • Join Filter: ((generalconfig_1.fromdate <= (to_date(((('2019-'::text || (date_part('month'::text, (co_4.supplierindexcollectiondate)::timestamp without time zone))::text) || '-'::text) || (date_part('day'::text, (co_4.supplierindexcollectiondate)::timestamp without time zone))::text), 'YYYY-MM-DD'::text))) AND ((generalconfig_1.todate IS NULL) OR (generalconfig_1.todate > (to_date(((('2019-'::text || (date_part('month'::text, (co_4.supplierindexcollectiondate)::timestamp without time zone))::text) || '-'::text) || (date_part('day'::text, (co_4.supplierindexcollectiondate)::timestamp without time zone))::text), 'YYYY-MM-DD'::text)))))
  • Rows Removed by Join Filter: 182462
  • Filter: (((generalconfig_1.category IS NULL) OR ((generalconfig_1.category)::text = 'SMALL_CAPACITY'::text)) AND ((generalconfig_1.readingfrequency IS NULL) OR ((generalconfig_1.readingfrequency)::text <> 'NOT_MEASURED'::text)) AND ((generalconfig_1.state IS NULL) OR ((generalconfig_1.state)::text = 'IN_USE'::text)))
  • Rows Removed by Filter: 4744
102. 554.089 554.089 ↓ 1.1 312,030 1

Seq Scan on generalconfig generalconfig_1 (cost=0.00..24,096.80 rows=290,166 width=42) (actual time=0.029..554.089 rows=312,030 loops=1)

  • Filter: ((deleted IS FALSE) AND ((sourceid)::text = 'DGO'::text))
  • Rows Removed by Filter: 189789
103. 44.815 2,557.102 ↓ 1.8 116,172 1

Hash (cost=125,742.18..125,742.18 rows=63,960 width=47) (actual time=2,557.102..2,557.102 rows=116,172 loops=1)

  • Buckets: 2048 Batches: 16 (originally 8) Memory Usage: 1025kB
104. 219.697 2,512.287 ↓ 1.8 116,172 1

Hash Right Join (cost=111,514.93..125,742.18 rows=63,960 width=47) (actual time=2,165.853..2,512.287 rows=116,172 loops=1)

  • Hash Cond: ((physicalconfig_2.deliverypointid = deliverypoint_1.deliverypointid) AND (physicalconfig_2.deliverypointcomponentid = deliverypointcomponent_1.deliverypointcomponentid))
  • Join Filter: ((physicalconfig_2.fromdate <= (to_date(((('2019-'::text || (date_part('month'::text, (co_4.supplierindexcollectiondate)::timestamp without time zone))::text) || '-'::text) || (date_part('day'::text, (co_4.supplierindexcollectiondate)::timestamp without time zone))::text), 'YYYY-MM-DD'::text))) AND ((physicalconfig_2.todate IS NULL) OR (physicalconfig_2.todate > (to_date(((('2019-'::text || (date_part('month'::text, (co_4.supplierindexcollectiondate)::timestamp without time zone))::text) || '-'::text) || (date_part('day'::text, (co_4.supplierindexcollectiondate)::timestamp without time zone))::text), 'YYYY-MM-DD'::text)))))
  • Rows Removed by Join Filter: 130004
105. 127.721 127.721 ↑ 1.0 259,071 1

Seq Scan on physicalconfig physicalconfig_2 (cost=0.00..8,679.81 rows=259,256 width=20) (actual time=0.030..127.721 rows=259,071 loops=1)

  • Filter: ((deleted IS FALSE) AND ((sourceid)::text = 'DGO'::text))
  • Rows Removed by Filter: 3
106. 43.485 2,164.869 ↓ 1.8 116,172 1

Hash (cost=109,992.53..109,992.53 rows=63,960 width=43) (actual time=2,164.869..2,164.869 rows=116,172 loops=1)

  • Buckets: 2048 Batches: 16 (originally 8) Memory Usage: 1025kB
107. 102.074 2,121.384 ↓ 1.8 116,172 1

Hash Join (cost=73,471.00..109,992.53 rows=63,960 width=43) (actual time=1,307.654..2,121.384 rows=116,172 loops=1)

  • Hash Cond: (deliveryperiod_3.deliverypointid = deliverypoint_1.deliverypointid)
108. 90.872 1,882.559 ↓ 1.8 116,172 1

Hash Join (cost=66,407.44..99,817.92 rows=63,960 width=24) (actual time=1,168.155..1,882.559 rows=116,172 loops=1)

  • Hash Cond: (deliveryperiod_3.deliverypointcomponentid = deliverypointcomponent_1.deliverypointcomponentid)
109. 104.031 1,704.680 ↓ 1.8 116,172 1

Hash Join (cost=60,231.29..91,102.52 rows=63,960 width=24) (actual time=1,081.013..1,704.680 rows=116,172 loops=1)

  • Hash Cond: (cdp_2.deliveryperiodid = deliveryperiod_3.deliveryperiodid)
110. 176.859 1,456.512 ↓ 1.8 116,172 1

Merge Join (cost=52,982.15..81,151.12 rows=63,960 width=20) (actual time=936.273..1,456.512 rows=116,172 loops=1)

  • Merge Cond: (co_4.contractid = cdp_2.contractid)
  • Join Filter: ((cdp_2.fromdate <= (to_date(((('2019-'::text || (date_part('month'::text, (co_4.supplierindexcollectiondate)::timestamp without time zone))::text) || '-'::text) || (date_part('day'::text, (co_4.supplierindexcollectiondate)::timestamp without time zone))::text), 'YYYY-MM-DD'::text))) AND ((cdp_2.todate IS NULL) OR (cdp_2.todate > (to_date(((('2019-'::text || (date_part('month'::text, (co_4.supplierindexcollectiondate)::timestamp without time zone))::text) || '-'::text) || (date_part('day'::text, (co_4.supplierindexcollectiondate)::timestamp without time zone))::text), 'YYYY-MM-DD'::text)))) AND (cdp_2.fromdate <> (to_date(((('2019-'::text || (date_part('month'::text, (co_4.supplierindexcollectiondate)::timestamp without time zone))::text) || '-'::text) || (date_part('day'::text, (co_4.supplierindexcollectiondate)::timestamp without time zone))::text), 'YYYY-MM-DD'::text))) AND ((cdp_2.todate IS NULL) OR (cdp_2.todate <> (to_date(((('2019-'::text || (date_part('month'::text, (co_4.supplierindexcollectiondate)::timestamp without time zone))::text) || '-'::text) || (date_part('day'::text, (co_4.supplierindexcollectiondate)::timestamp without time zone))::text), 'YYYY-MM-DD'::text)))))
  • Rows Removed by Join Filter: 192400
111. 56.708 1,083.798 ↓ 1.0 305,014 1

Unique (cost=52,981.73..55,268.91 rows=304,958 width=8) (actual time=936.073..1,083.798 rows=305,014 loops=1)

112. 370.089 1,027.090 ↓ 1.0 305,014 1

Sort (cost=52,981.73..53,744.12 rows=304,958 width=8) (actual time=936.070..1,027.090 rows=305,014 loops=1)

  • Sort Key: co_4.contractid, (to_date(((('2019-'::text || (date_part('month'::text, (co_4.supplierindexcollectiondate)::timestamp without time zone))::text) || '-'::text) || (date_part('day'::text, (co_4.supplierindexcollectiondate)::timestamp without time zone))::text), 'YYYY-MM-DD'::text))
  • Sort Method: external merge Disk: 5376kB
113. 35.195 657.001 ↓ 1.0 305,014 1

Append (cost=0.00..21,030.72 rows=304,958 width=8) (actual time=0.048..657.001 rows=305,014 loops=1)

114. 307.824 307.824 ↓ 1.0 152,507 1

Seq Scan on contract co_4 (cost=0.00..8,990.57 rows=152,479 width=8) (actual time=0.048..307.824 rows=152,507 loops=1)

  • Filter: (supplierindexcollectiondate IS NOT NULL)
  • Rows Removed by Filter: 538
115. 313.982 313.982 ↓ 1.0 152,507 1

Seq Scan on contract co_5 (cost=0.00..8,990.57 rows=152,479 width=8) (actual time=0.030..313.982 rows=152,507 loops=1)

  • Filter: (supplierindexcollectiondate IS NOT NULL)
  • Rows Removed by Filter: 538
116. 45.054 195.855 ↓ 2.0 308,773 1

Materialize (cost=0.42..14,659.83 rows=153,030 width=20) (actual time=0.174..195.855 rows=308,773 loops=1)

117. 150.801 150.801 ↓ 1.0 154,488 1

Index Scan using contractdelively_contract_id_idx on contractdelivery cdp_2 (cost=0.42..14,277.26 rows=153,030 width=20) (actual time=0.168..150.801 rows=154,488 loops=1)

118. 45.094 144.137 ↓ 1.0 155,311 1

Hash (cost=4,570.51..4,570.51 rows=154,051 width=12) (actual time=144.137..144.137 rows=155,311 loops=1)

  • Buckets: 4096 Batches: 8 Memory Usage: 847kB
119. 99.043 99.043 ↓ 1.0 155,311 1

Seq Scan on deliveryperiod deliveryperiod_3 (cost=0.00..4,570.51 rows=154,051 width=12) (actual time=0.017..99.043 rows=155,311 loops=1)

  • Filter: (deleted IS FALSE)
120. 31.267 87.007 ↑ 1.0 147,230 1

Hash (cost=3,700.51..3,700.51 rows=150,851 width=4) (actual time=87.007..87.007 rows=147,230 loops=1)

  • Buckets: 4096 Batches: 8 Memory Usage: 654kB
121. 55.740 55.740 ↑ 1.0 147,230 1

Seq Scan on deliverypointcomponent deliverypointcomponent_1 (cost=0.00..3,700.51 rows=150,851 width=4) (actual time=0.016..55.740 rows=147,230 loops=1)

  • Filter: (deleted IS FALSE)
122. 48.978 136.751 ↓ 1.0 147,230 1

Hash (cost=4,426.25..4,426.25 rows=143,625 width=23) (actual time=136.751..136.751 rows=147,230 loops=1)

  • Buckets: 2048 Batches: 8 Memory Usage: 1015kB
123. 87.773 87.773 ↓ 1.0 147,230 1

Seq Scan on deliverypoint deliverypoint_1 (cost=0.00..4,426.25 rows=143,625 width=23) (actual time=0.015..87.773 rows=147,230 loops=1)

  • Filter: (deleted IS FALSE)
124. 43.184 99.948 ↓ 1.0 153,045 1

Hash (cost=4,416.20..4,416.20 rows=153,020 width=19) (actual time=99.948..99.948 rows=153,045 loops=1)

  • Buckets: 2048 Batches: 16 Memory Usage: 489kB
125. 56.764 56.764 ↓ 1.0 153,045 1

Seq Scan on contract co_3 (cost=0.00..4,416.20 rows=153,020 width=19) (actual time=0.015..56.764 rows=153,045 loops=1)

126. 0.001 0.282 ↓ 0.0 0 1

Hash (cost=24,460.34..24,460.34 rows=68,193 width=4) (actual time=0.282..0.282 rows=0 loops=1)

  • Buckets: 4096 Batches: 4 Memory Usage: 0kB
127. 0.001 0.281 ↓ 0.0 0 1

Bitmap Heap Scan on contractuserfields cuf_1 (cost=1,276.92..24,460.34 rows=68,193 width=4) (actual time=0.281..0.281 rows=0 loops=1)

  • Recheck Cond: (useritemcodeparamid = $21)
128. 0.280 0.280 ↓ 0.0 0 1

Bitmap Index Scan on idx_contractuserfields_useritemcodeparamid (cost=0.00..1,259.88 rows=68,193 width=0) (actual time=0.280..0.280 rows=0 loops=1)

  • Index Cond: (useritemcodeparamid = $21)
129. 10.304 520.159 ↓ 1.6 43,937 1

Hash (cost=39,471.46..39,471.46 rows=27,017 width=4) (actual time=520.159..520.159 rows=43,937 loops=1)

  • Buckets: 4096 Batches: 2 Memory Usage: 773kB
130. 509.855 509.855 ↓ 1.6 43,937 1

Seq Scan on crmworkflow cw3 (cost=0.00..39,471.46 rows=27,017 width=4) (actual time=0.114..509.855 rows=43,937 loops=1)

  • Filter: ((creationdate >= '2019-12-30'::date) AND (creationdate < '2020-01-13'::date))
  • Rows Removed by Filter: 1136142
131.          

SubPlan (for Hash Join)

132. 111.476 16,944.352 ↓ 0.0 0 111,476

Limit (cost=19.73..19.73 rows=1 width=12) (actual time=0.152..0.152 rows=0 loops=111,476)

133. 222.952 16,832.876 ↓ 0.0 0 111,476

Sort (cost=19.73..19.73 rows=1 width=12) (actual time=0.151..0.151 rows=0 loops=111,476)

  • Sort Key: cw_5.creationdate
  • Sort Method: top-N heapsort Memory: 25kB
134. 72.567 16,609.924 ↓ 0.0 0 111,476

Nested Loop (cost=2.24..19.72 rows=1 width=12) (actual time=0.134..0.149 rows=0 loops=111,476)

135. 208.051 16,275.496 ↑ 1.0 1 111,476

Nested Loop (cost=1.96..19.32 rows=1 width=16) (actual time=0.117..0.146 rows=1 loops=111,476)

136. 167.667 15,718.116 ↑ 1.0 1 111,476

Nested Loop (cost=1.69..18.91 rows=1 width=20) (actual time=0.109..0.141 rows=1 loops=111,476)

137. 45.817 7,134.464 ↑ 1.0 1 111,476

Nested Loop (cost=1.26..17.45 rows=1 width=4) (actual time=0.062..0.064 rows=1 loops=111,476)

138. 222.952 5,796.752 ↑ 1.0 1 111,476

Nested Loop (cost=0.84..16.89 rows=1 width=4) (actual time=0.050..0.052 rows=1 loops=111,476)

139. 4,124.612 4,124.612 ↑ 1.0 1 111,476

Index Scan using deliverypoint_gsrn_idx on deliverypoint dp_w_2 (cost=0.42..8.44 rows=1 width=4) (actual time=0.036..0.037 rows=1 loops=111,476)

  • Index Cond: ((gsrn)::text = (deliverypoint_1.gsrn)::text)
140. 1,449.188 1,449.188 ↑ 1.0 1 111,476

Index Scan using "IX_deliveryperiod_deliverypointid_deliveryperiod" on deliveryperiod deliveryperiod_4 (cost=0.42..8.44 rows=1 width=8) (actual time=0.012..0.013 rows=1 loops=111,476)

  • Index Cond: (deliverypointid = dp_w_2.deliverypointid)
141. 1,291.895 1,291.895 ↑ 1.0 1 117,445

Index Scan using contractdelivery_deliveryperiodid_idx on contractdelivery cdp_4 (cost=0.42..0.55 rows=1 width=8) (actual time=0.011..0.011 rows=1 loops=117,445)

  • Index Cond: (deliveryperiodid = deliveryperiod_4.deliveryperiodid)
142. 8,415.985 8,415.985 ↑ 1.0 1 118,535

Index Scan using crmworkflow_contractdeliveryid_idx on crmworkflow cw_5 (cost=0.43..1.46 rows=1 width=24) (actual time=0.043..0.071 rows=1 loops=118,535)

  • Index Cond: (contractdeliveryid = cdp_4.contractdeliveryid)
  • Filter: (effectivedate = (to_date(((('2019-'::text || (date_part('month'::text, (co_4.supplierindexcollectiondate)::timestamp without time zone))::text) || '-'::text) || (date_part('day'::text, (co_4.supplierindexcollectiondate)::timestamp without time zone))::text), 'YYYY-MM-DD'::text)))
  • Rows Removed by Filter: 12
143. 349.329 349.329 ↑ 1.0 1 116,443

Index Scan using parametervalueid on parametervalue pv_t_5 (cost=0.28..0.39 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=116,443)

  • Index Cond: (parametervalueid = cw_5.crmworkflowtypeparamid)
  • Filter: ((valuecode)::text = 'NL_indexCollectionKV'::text)
  • Rows Removed by Filter: 0
144. 261.861 261.861 ↓ 0.0 0 87,287

Index Scan using parametervalueid on parametervalue pv_s_5 (cost=0.28..0.39 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=87,287)

  • Index Cond: (parametervalueid = cw_5.crmworkflowstatusparamid)
  • Filter: ((internalparametervaluecode)::text = 'ERROR'::text)
  • Rows Removed by Filter: 1
145. 49.808 615.583 ↓ 2.0 147,573 1

Hash (cost=23,193.56..23,193.56 rows=73,834 width=32) (actual time=615.583..615.583 rows=147,573 loops=1)

  • Buckets: 2048 Batches: 16 (originally 8) Memory Usage: 1025kB
146. 196.750 565.775 ↓ 2.0 147,573 1

Hash Join (cost=9,552.00..23,193.56 rows=73,834 width=32) (actual time=213.217..565.775 rows=147,573 loops=1)

  • Hash Cond: (physicalconfig_3.physicalconfigid = m_1.physicalconfigid)
147. 157.166 157.166 ↑ 1.0 259,073 1

Seq Scan on physicalconfig physicalconfig_3 (cost=0.00..8,031.65 rows=259,265 width=4) (actual time=0.109..157.166 rows=259,073 loops=1)

  • Filter: (deleted IS FALSE)
  • Rows Removed by Filter: 1
148. 64.260 211.859 ↓ 2.0 147,573 1

Hash (cost=8,052.08..8,052.08 rows=73,834 width=36) (actual time=211.859..211.859 rows=147,573 loops=1)

  • Buckets: 2048 Batches: 16 (originally 8) Memory Usage: 1025kB
149. 147.599 147.599 ↓ 2.0 147,573 1

Seq Scan on meter m_1 (cost=0.00..8,052.08 rows=73,834 width=36) (actual time=0.150..147.599 rows=147,573 loops=1)

  • Filter: (((metertype)::text = 'SMART_METER'::text) AND ((smartmeterstatus)::text = 'ACTIVE_READABLE'::text))
  • Rows Removed by Filter: 111501
150.          

SubPlan (for Hash Join)

151. 0.320 8.160 ↑ 1.0 1 80

Aggregate (cost=16.89..16.90 rows=1 width=4) (actual time=0.102..0.102 rows=1 loops=80)

152. 0.240 7.840 ↑ 1.0 1 80

Nested Loop (cost=0.84..16.89 rows=1 width=4) (actual time=0.097..0.098 rows=1 loops=80)

153. 4.480 4.480 ↑ 1.0 1 80

Index Scan using meter_physicalconfigid_idx on meter m_2 (cost=0.42..8.44 rows=1 width=8) (actual time=0.056..0.056 rows=1 loops=80)

  • Index Cond: (physicalconfigid = physicalconfig_2.physicalconfigid)
154. 3.120 3.120 ↑ 1.0 1 80

Index Scan using physicalconfig_pk on physicalconfig physicalconfig_4 (cost=0.42..8.44 rows=1 width=4) (actual time=0.039..0.039 rows=1 loops=80)

  • Index Cond: (physicalconfigid = physicalconfig_2.physicalconfigid)
  • Filter: (deleted IS FALSE)
155. 0.096 17.760 ↓ 2.0 2 32

Nested Loop (cost=2.24..6.01 rows=1 width=23) (actual time=0.417..0.555 rows=2 loops=32)

156. 0.935 16.992 ↓ 5.0 5 32

Nested Loop (cost=1.96..5.70 rows=1 width=27) (actual time=0.168..0.531 rows=5 loops=32)

157. 0.384 13.600 ↓ 3.2 26 32

Nested Loop (cost=1.69..3.24 rows=8 width=31) (actual time=0.153..0.425 rows=26 loops=32)

158. 0.096 4.000 ↑ 1.0 1 32

Nested Loop (cost=1.26..1.67 rows=1 width=23) (actual time=0.122..0.125 rows=1 loops=32)

159. 0.160 3.008 ↑ 1.0 1 32

Nested Loop (cost=0.84..1.11 rows=1 width=23) (actual time=0.092..0.094 rows=1 loops=32)

160. 1.952 1.952 ↑ 1.0 1 32

Index Scan using deliverypoint_gsrn_idx on deliverypoint dp_w_1 (cost=0.42..0.55 rows=1 width=23) (actual time=0.061..0.061 rows=1 loops=32)

  • Index Cond: ((gsrn)::text = (deliverypoint_1.gsrn)::text)
161. 0.896 0.896 ↑ 1.0 1 32

Index Scan using "IX_deliveryperiod_deliverypointid_deliveryperiod" on deliveryperiod deliveryperiod_2 (cost=0.42..0.55 rows=1 width=8) (actual time=0.028..0.028 rows=1 loops=32)

  • Index Cond: (deliverypointid = dp_w_1.deliverypointid)
162. 0.896 0.896 ↑ 1.0 1 32

Index Scan using contractdelivery_deliveryperiodid_idx on contractdelivery cdp_3 (cost=0.42..0.55 rows=1 width=8) (actual time=0.027..0.028 rows=1 loops=32)

  • Index Cond: (deliveryperiodid = deliveryperiod_2.deliveryperiodid)
163. 9.216 9.216 ↓ 1.7 26 32

Index Scan using crmworkflow_contractdeliveryid_idx on crmworkflow cw_1 (cost=0.43..1.42 rows=15 width=16) (actual time=0.028..0.288 rows=26 loops=32)

  • Index Cond: (contractdeliveryid = cdp_3.contractdeliveryid)
164. 2.457 2.457 ↓ 0.0 0 819

Index Scan using parametervalueid on parametervalue pv_t_1 (cost=0.28..0.30 rows=1 width=4) (actual time=0.003..0.003 rows=0 loops=819)

  • Index Cond: (parametervalueid = cw_1.crmworkflowtypeparamid)
  • Filter: ((valuecode)::text = 'NL_indexCollectionKV'::text)
  • Rows Removed by Filter: 1
165. 0.672 0.672 ↓ 0.0 0 168

Index Scan using parametervalueid on parametervalue pv_s_1 (cost=0.28..0.30 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=168)

  • Index Cond: (parametervalueid = cw_1.crmworkflowstatusparamid)
  • Filter: ((internalparametervaluecode)::text = ANY ('{RUNNING,SUCCESS}'::text[]))
  • Rows Removed by Filter: 1
166.          

SubPlan (for Nested Loop Anti Join)

167. 0.128 23.520 ↑ 1.0 1 32

Aggregate (cost=496.75..496.76 rows=1 width=0) (actual time=0.735..0.735 rows=1 loops=32)

168. 0.164 23.392 ↓ 3.0 3 32

Nested Loop (cost=1.67..496.75 rows=1 width=0) (actual time=0.354..0.731 rows=3 loops=32)

169. 0.096 22.848 ↓ 3.0 3 32

Nested Loop (cost=1.40..496.44 rows=1 width=4) (actual time=0.347..0.714 rows=3 loops=32)

  • Join Filter: (cw_2.crmworkflowtypeparamid = pv_t_2.parametervalueid)
  • Rows Removed by Join Filter: 1
170. 0.672 0.672 ↑ 1.0 1 32

Index Scan using parametervalue_valuecode_idx on parametervalue pv_t_2 (cost=0.28..8.29 rows=1 width=4) (actual time=0.020..0.021 rows=1 loops=32)

  • Index Cond: ((valuecode)::text = 'NL_indexCollectionKV'::text)
171. 0.479 22.080 ↑ 9.8 4 32

Nested Loop (cost=1.12..487.66 rows=39 width=8) (actual time=0.325..0.690 rows=4 loops=32)

172. 16.960 16.960 ↑ 9.8 4 32

Index Scan using crmworkflowdata_key_value_idx on crmworkflowdata cwd (cost=0.69..157.82 rows=39 width=4) (actual time=0.296..0.530 rows=4 loops=32)

  • Index Cond: (((key)::text = 'BUSINESS_KEY'::text) AND (value = (((deliverypoint_1.gsrn)::text || '_'::text) || to_char(((to_date(((('2019-'::text || (date_part('month'::text, (co_4.supplierindexcollectiondate)::timestamp without time zone))::text) || '-'::text) || (date_part('day'::text, (co_4.supplierindexcollectiondate)::timestamp without time zone))::text), 'YYYY-MM-DD'::text)))::timestamp with time zone, 'YYYYMMDD'::text))))
173. 4.641 4.641 ↑ 1.0 1 119

Index Scan using crmworkflow_pkey on crmworkflow cw_2 (cost=0.43..8.45 rows=1 width=12) (actual time=0.038..0.039 rows=1 loops=119)

  • Index Cond: (crmworkflowid = cwd.crmworkflowid)
174. 0.380 0.380 ↑ 1.0 1 95

Index Scan using parametervalueid on parametervalue pv_s_2 (cost=0.28..0.30 rows=1 width=4) (actual time=0.003..0.004 rows=1 loops=95)

  • Index Cond: (parametervalueid = cw_2.crmworkflowstatusparamid)
  • Filter: ((internalparametervaluecode)::text = 'ERROR'::text)
175. 0.032 1,458.784 ↓ 0.0 0 32

Limit (cost=9.69..1,213.06 rows=1 width=4) (actual time=45.587..45.587 rows=0 loops=32)

176. 0.256 1,458.752 ↓ 0.0 0 32

Nested Loop (cost=9.69..1,213.06 rows=1 width=4) (actual time=45.586..45.586 rows=0 loops=32)

177. 0.450 1,449.088 ↓ 9.0 9 32

Nested Loop (cost=9.01..1,205.28 rows=1 width=4) (actual time=0.712..45.284 rows=9 loops=32)

178. 244.946 1,447.168 ↓ 1.5 9 32

Hash Join (cost=8.74..1,203.28 rows=6 width=8) (actual time=0.704..45.224 rows=9 loops=32)

  • Hash Cond: (cw_3.crmworkflowstatusparamid = pv_s_3.parametervalueid)
179. 1,202.112 1,202.112 ↓ 5.7 34,267 32

Index Scan using crmworkflow_effectivedate_idx on crmworkflow cw_3 (cost=0.43..1,172.23 rows=6,049 width=12) (actual time=0.030..37.566 rows=34,267 loops=32)

  • Index Cond: ((effectivedate >= ((to_date(((('2019-'::text || (date_part('month'::text, (co_4.supplierindexcollectiondate)::timestamp without time zone))::text) || '-'::text) || (date_part('day'::text, (co_4.supplierindexcollectiondate)::timestamp without time zone))::text), 'YYYY-MM-DD'::text)) - 5)) AND (effectivedate <= ((to_date(((('2019-'::text || (date_part('month'::text, (co_4.supplierindexcollectiondate)::timestamp without time zone))::text) || '-'::text) || (date_part('day'::text, (co_4.supplierindexcollectiondate)::timestamp without time zone))::text), 'YYYY-MM-DD'::text)) + 5)))
180. 0.003 0.110 ↑ 1.0 1 1

Hash (cost=8.29..8.29 rows=1 width=4) (actual time=0.110..0.110 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
181. 0.107 0.107 ↑ 1.0 1 1

Index Scan using parametervalue_internalparametervaluecode_idx on parametervalue pv_s_3 (cost=0.28..8.29 rows=1 width=4) (actual time=0.106..0.107 rows=1 loops=1)

  • Index Cond: ((internalparametervaluecode)::text = 'RUNNING'::text)
182. 1.470 1.470 ↑ 1.0 1 294

Index Scan using parametervalueid on parametervalue pv_t_3 (cost=0.28..0.32 rows=1 width=4) (actual time=0.004..0.005 rows=1 loops=294)

  • Index Cond: (parametervalueid = cw_3.crmworkflowtypeparamid)
  • Filter: ((valuecode)::text = ANY ('{NL_indexCollectionKV,NL_VKOindex}'::text[]))
183. 9.408 9.408 ↓ 0.0 0 294

Index Only Scan using crmworkflowdata_crmworkflowid_key_value_idx on crmworkflowdata cwd_1 (cost=0.68..7.77 rows=1 width=4) (actual time=0.032..0.032 rows=0 loops=294)

  • Index Cond: ((crmworkflowid = cw_3.crmworkflowid) AND (key = 'BUSINESS_KEY'::text))
  • Filter: (value ~~ ((deliverypoint_1.gsrn)::text || '_%'::text))
  • Rows Removed by Filter: 1
  • Heap Fetches: 294
184. 0.064 76.896 ↓ 0.0 0 32

Limit (cost=27.36..66.48 rows=1 width=4) (actual time=2.403..2.403 rows=0 loops=32)

185. 0.096 76.832 ↓ 0.0 0 32

Nested Loop (cost=27.36..66.48 rows=1 width=4) (actual time=2.401..2.401 rows=0 loops=32)

186. 0.556 74.432 ↑ 1.0 1 32

Nested Loop Left Join (cost=26.93..30.99 rows=1 width=4) (actual time=2.261..2.326 rows=1 loops=32)

  • Filter: ((((index.sourceid)::text = 'USER'::text) AND ((i2.marketstatus)::text = ANY ('{SUBMITTED,ACCEPTED}'::text[]))) OR ((index.sourceid)::text <> 'USER'::text))
187. 55.520 68.224 ↑ 1.0 1 32

Bitmap Heap Scan on index (cost=10.01..14.04 rows=1 width=11) (actual time=2.077..2.132 rows=1 loops=32)

  • Recheck Cond: ((deliverypointcomponentid = deliverypointcomponent_1.deliverypointcomponentid) AND (deliverypointid = deliverypoint_1.deliverypointid))
  • Filter: ((deleted IS FALSE) AND ((status)::text = 'ACTUAL'::text) AND (todate >= ((to_date(((('2019-'::text || (date_part('month'::text, (co_4.supplierindexcollectiondate)::timestamp without time zone))::text) || '-'::text) || (date_part('day'::text, (co_4.supplierindexcollectiondate)::timestamp without time zone))::text), 'YYYY-MM-DD'::text)) - 5)) AND (todate <= ((to_date(((('2019-'::text || (date_part('month'::text, (co_4.supplierindexcollectiondate)::timestamp without time zone))::text) || '-'::text) || (date_part('day'::text, (co_4.supplierindexcollectiondate)::timestamp without time zone))::text), 'YYYY-MM-DD'::text)) + 5)))
  • Rows Removed by Filter: 24
  • Heap Blocks: exact=756
188. 0.256 12.704 ↓ 0.0 0 32

BitmapAnd (cost=10.01..10.01 rows=1 width=0) (actual time=0.397..0.397 rows=0 loops=32)

189. 6.304 6.304 ↑ 2.2 27 32

Bitmap Index Scan on index_dpcomp_idx (cost=0.00..4.88 rows=60 width=0) (actual time=0.197..0.197 rows=27 loops=32)

  • Index Cond: (deliverypointcomponentid = deliverypointcomponent_1.deliverypointcomponentid)
190. 6.144 6.144 ↑ 2.3 26 32

Bitmap Index Scan on index_deliverypointid_idx (cost=0.00..4.88 rows=60 width=0) (actual time=0.192..0.192 rows=26 loops=32)

  • Index Cond: (deliverypointid = deliverypoint_1.deliverypointid)
191. 0.108 5.652 ↓ 0.0 0 36

Limit (cost=16.92..16.92 rows=1 width=156) (actual time=0.157..0.157 rows=0 loops=36)

192. 0.504 5.544 ↓ 0.0 0 36

Sort (cost=16.92..16.92 rows=1 width=156) (actual time=0.154..0.154 rows=0 loops=36)

  • Sort Key: (CASE WHEN ((i2.marketstatus)::text = 'ACCEPTED'::text) THEN 1 WHEN ((i2.marketstatus)::text = 'SUMBITTED'::text) THEN 2 WHEN ((i2.marketstatus)::text = 'REJECTED'::text) THEN 3 ELSE NULL::integer END)
  • Sort Method: quicksort Memory: 25kB
193. 0.180 5.040 ↑ 1.0 1 36

Nested Loop (cost=0.85..16.91 rows=1 width=156) (actual time=0.096..0.140 rows=1 loops=36)

194. 1.404 1.404 ↑ 1.0 1 36

Index Only Scan using indexrelation_pk on indexrelation ir (cost=0.42..8.44 rows=1 width=4) (actual time=0.030..0.039 rows=1 loops=36)

  • Index Cond: (sourceindexid = index.indexid)
  • Heap Fetches: 48
195. 3.456 3.456 ↑ 1.0 1 48

Index Scan using index_pk on index i2 (cost=0.43..8.45 rows=1 width=156) (actual time=0.071..0.072 rows=1 loops=48)

  • Index Cond: (indexid = ir.targetindexid)
  • Filter: ((sourceid)::text = 'SUPPLIER'::text)
196. 2.304 2.304 ↓ 0.0 0 36

Index Scan using consumption_indexid_idx on consumption (cost=0.43..35.25 rows=25 width=4) (actual time=0.064..0.064 rows=0 loops=36)

  • Index Cond: (endindexid = index.indexid)
  • Filter: ((deleted IS FALSE) AND ((sourceid)::text = 'DGO'::text))
  • Rows Removed by Filter: 0
197. 0.064 17.344 ↑ 1.0 1 32

Limit (cost=455.57..455.57 rows=1 width=41) (actual time=0.542..0.542 rows=1 loops=32)

198. 0.320 17.280 ↑ 1.0 1 32

Sort (cost=455.57..455.57 rows=1 width=41) (actual time=0.540..0.540 rows=1 loops=32)

  • Sort Key: cw_4.crmworkflowid
  • Sort Method: top-N heapsort Memory: 25kB
199. 0.101 16.960 ↓ 3.0 3 32

Nested Loop (cost=2.35..455.56 rows=1 width=41) (actual time=0.144..0.530 rows=3 loops=32)

200. 0.144 16.384 ↓ 3.0 3 32

Nested Loop (cost=2.08..455.25 rows=1 width=45) (actual time=0.136..0.512 rows=3 loops=32)

201. 0.256 15.840 ↑ 5.3 3 32

Nested Loop (cost=1.80..450.33 rows=16 width=49) (actual time=0.129..0.495 rows=3 loops=32)

  • Join Filter: (cwd_2.crmworkflowid = cw_4.crmworkflowid)
202. 0.612 14.784 ↑ 5.3 3 32

Nested Loop (cost=1.38..433.70 rows=16 width=45) (actual time=0.115..0.462 rows=3 loops=32)

203. 2.272 2.272 ↑ 9.8 4 32

Index Scan using crmworkflowdata_key_value_idx on crmworkflowdata cwd_2 (cost=0.69..157.82 rows=39 width=4) (actual time=0.065..0.071 rows=4 loops=32)

  • Index Cond: (((key)::text = 'BUSINESS_KEY'::text) AND (value = (((deliverypoint_1.gsrn)::text || '_'::text) || to_char(((to_date(((('2019-'::text || (date_part('month'::text, (co_4.supplierindexcollectiondate)::timestamp without time zone))::text) || '-'::text) || (date_part('day'::text, (co_4.supplierindexcollectiondate)::timestamp without time zone))::text), 'YYYY-MM-DD'::text)))::timestamp with time zone, 'YYYYMMDD'::text))))
204. 11.900 11.900 ↑ 1.0 1 119

Index Only Scan using crmworkflowdata_crmworkflowid_key_value_idx on crmworkflowdata cwd_err (cost=0.68..7.06 rows=1 width=41) (actual time=0.099..0.100 rows=1 loops=119)

  • Index Cond: ((crmworkflowid = cwd_2.crmworkflowid) AND (key = 'ERROR_REASON'::text))
  • Heap Fetches: 100
205. 0.800 0.800 ↑ 1.0 1 100

Index Scan using crmworkflow_pkey on crmworkflow cw_4 (cost=0.43..1.03 rows=1 width=12) (actual time=0.008..0.008 rows=1 loops=100)

  • Index Cond: (crmworkflowid = cwd_err.crmworkflowid)
206. 0.400 0.400 ↑ 1.0 1 100

Index Scan using parametervalueid on parametervalue pv_t_4 (cost=0.28..0.30 rows=1 width=4) (actual time=0.004..0.004 rows=1 loops=100)

  • Index Cond: (parametervalueid = cw_4.crmworkflowtypeparamid)
  • Filter: ((valuecode)::text = 'NL_indexCollectionKV'::text)
  • Rows Removed by Filter: 0
207. 0.475 0.475 ↑ 1.0 1 95

Index Scan using parametervalueid on parametervalue pv_s_4 (cost=0.28..0.30 rows=1 width=4) (actual time=0.004..0.005 rows=1 loops=95)

  • Index Cond: (parametervalueid = cw_4.crmworkflowstatusparamid)
  • Filter: ((internalparametervaluecode)::text = 'ERROR'::text)
Planning time : 155.023 ms
Execution time : 44,604.313 ms